Tech Exam Prep

Tech Exam Prep

By Ran Chen, EA, CFP®EducationHow ToCourses
Download on the App Store

Tech Exam Prep episodes

  • [PL-300] 46, Mobile, Accessible, and Personalized Reports
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams.
    In this episode you will learn:
    - How Mobile Layout modifications function independently without altering the desktop view in Power BI Desktop
    - How to configure Tab Order and hide decorative elements in the Selection pane for screen reader accessibility
    - Techniques for setting static and dynamic conditional DAX alt text for accessibility compliance
    - Best practices for combining color contrast with status icons to support color-blind users
    - How to configure report-level visual personalization and restrict changes on specific KPI visuals
    For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    4 min
  • [PL-300] 45, Sync Slicers, Sorting, and the Selection Pane
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams.
    In this episode you will learn:
    - How to configure Sync Slicers for background filter propagation using sync and visibility controls across report pages
    - Techniques for resolving chronological sorting errors using the Sort by Column feature and numeric field mappings
    - Methods for managing Z-order layering and object visibility in the Selection pane to resolve visual stacking conflicts
    - Best practices for integrating Selection pane visibility toggles with bookmarks and display property settings
    - Strategies for configuring accessible Tab Order and custom Sync Groups to pass PL-300 report design questions
    For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    5 min
  • [PL-300] 44, Navigation, Drillthrough, and Buttons
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams.
    In this episode you will learn:
    - Difference between Page navigation, Bookmark, Drillthrough, Back, and Web URL button actions in Power BI
    - How to configure drillthrough target pages using the Drillthrough filters well
    - Impact of the Keep all filters toggle on filter context propagation between report pages
    - Common exam traps around disabled drillthrough buttons and dynamic Back button behavior
    - The DRILL mnemonic for remembering key steps in drillthrough configuration and troubleshooting
    For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    4 min
  • [PL-300] 43, Tooltips and Visual Interactions
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams.
    In this episode you will learn:
    - How to properly configure report-page tooltips by setting page dimensions and toggling Allow as Tooltip.
    - How filter context is passed from the source visual data point directly into the tooltip page.
    - The distinction between Highlight, Filter, and None interaction modes in Power BI visual controls.
    - How default interaction behaviors differ between standard charts and slicer or card visuals.
    - How to avoid common exam traps involving interaction direction and missing tooltip options.
    For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    4 min
  • [PL-300] 42, Bookmarks and Report State
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams.
    In this episode you will learn:
    - How Data, Display, and Current Page options affect bookmark behavior on PL-300 exam scenarios.
    - How to configure view switching and toggle buttons without resetting user slicer selections.
    - How to set up a reset filters button using All Visuals and proper bookmark properties.
    - How to diagnose and resolve unexpected filter overrides caused by improper Data state settings.
    - How to correctly update bookmarks using Selected Visuals to avoid report navigation and visual bugs.
    For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    4 min
  • [PL-300] 41, Visual Calculations with DAX
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams.
    In this episode you will learn:
    - How visual calculations differ from semantic-model DAX measures in scope and reusability
    - Key visual calculation functions including RUNNINGSUM, MOVINGAVERAGE, and PREVIOUS
    - How to configure hierarchy reset behaviors across matrix rows and columns
    - Common exam traps regarding field removal and visual context dependencies
    - Strategic criteria for selecting visual calculations versus model measures in PL-300 scenario questions
    For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    4 min
  • [PL-300] 40, Interactive Reports vs Paginated Reports
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams.
    In this episode you will learn:
    - Key differences between interactive .pbix and paginated .rdl reports on the PL-300 exam
    - How to identify pixel-perfect, print-ready document requirements in scenario questions
    - How table truncation, scrollbars, and PDF rendering differ between report types
    - Exam traps surrounding email subscriptions, parameterization, and multi-page exports
    - A simple mnemonic rule to quickly select the correct report format under exam pressure
    For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    4 min
  • [PL-300] 39, Creating Reports and Narratives with Copilot
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams.
    In this episode you will learn:
    - Prerequisites for using Copilot in Power BI including Fabric F64 or Premium capacity requirements and tenant settings.
    - How Copilot generates report pages and dynamic narrative visuals based on semantic model metadata.
    - Techniques for validating Copilot narrative output against underlying DAX measures and model figures.
    - How to fix inaccurate AI outputs by optimizing semantic models, adding synonyms, and defining explicit DAX measures.
    - How Copilot strictly enforces Row-Level Security and Object-Level Security permissions in Power BI reports.
    For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    5 min
  • [PL-300] 38, Configuring Report Pages and Refresh Behavior
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams.
    In this episode you will learn:
    - Setting page size to Tooltip creates lightweight overlay canvases for hover cards and drillthrough targets.
    - Hiding a report page removes tab navigation but does not restrict security or data access for users.
    - Automatic Page Refresh (APR) requires DirectQuery or Live Connection and is not supported on Import mode datasets.
    - Remember the mnemonic: Import stays asleep, DirectQuery ticks the clock for real-time automatic page refresh.
    - Capacity minimum refresh intervals configured by tenant admins can override and throttle user-defined APR frequencies.
    For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    4 min
  • [PL-300] 37, Slicers, Filters, and Filter Scope
    This podcast is made by Ran Chen, who holds an EA license, Insurance and Securities licenses (Series 6, 63, 65), and the CFP® designation. He is passionate about opening access to high-quality exam preparation resources and helping learners prepare more effectively for professional certification exams.
    In this episode you will learn:
    - How visual-level, page-level, and report-level filters differ in scope and evaluation hierarchy
    - Configuring Sync Slicers to propagate filter selections across report pages without requiring visual display
    - Adjusting Edit Interactions to switch visual behaviors between filtering, highlighting, and none
    - Setting up Top N and relative date filters in the Filter pane including required field placements
    - Troubleshooting unexpected filter behavior caused by visual interactions, locked filters, or DAX measure overrides
    For more free exam prep tools, practice questions, and AI-powered explanations, visit https://open-exam-prep.com/ or YouTube Channel: https://www.youtube.com/@Open-exam-prep
    5 min

About Tech Exam Prep

From the publisher's feed

Tech Exam Prep is a free, daily podcast by OpenExamPrep covering the most in-demand IT and technology certification exams — including CompTIA Security+, AWS Cloud Practitioner, CompTIA Network+, CCNA,…