
Tech Exam Prep
Tech Exam Prep is a free, daily podcast covering the most in-demand IT and technology certification exams, including CompTIA Security+, AWS Cloud Practitioner, and CCNA. Each five-minute episode breaks down one exam topic with concrete examples, common exam traps, and memory tricks to help listeners pass on their first attempt. The podcast is created by Ran Chen, who holds multiple licenses and designations, and is passionate about making high-quality exam preparation accessible. For free practice questions, AI-powered explanations, and study guides, listeners can visit the OpenExamPrep website.
Episodes
![[PL-300] 45, Sync Slicers, Sorting, and the Selection Pane](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[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 propagati
![[PL-300] 44, Navigation, Drillthrough, and Buttons](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[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, B
![[PL-300] 43, Tooltips and Visual Interactions](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[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 pag
![[PL-300] 42, Bookmarks and Report State](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[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 b
![[PL-300] 41, Visual Calculations with DAX](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[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 measur
![[PL-300] 40, Interactive Reports vs Paginated Reports](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[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
![[PL-300] 39, Creating Reports and Narratives with Copilot](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[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
![[PL-300] 38, Configuring Report Pages and Refresh Behavior](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[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 canv
![[PL-300] 37, Slicers, Filters, and Filter Scope](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[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
![[PL-300] 36, Themes and Conditional Formatting](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 36, Themes and Conditional Formatting
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 report themes establish global design consistency across
![[PL-300] 35, Formatting and Configuring Visuals](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 35, Formatting and Configuring Visuals
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 implicit field aggregations differ from explicit DAX meas
![[PL-300] 34, Choosing the Right Power BI Visual](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 34, Choosing the Right Power BI Visual
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 match core business requirements like trends, correlat
![[PL-300] 33, Optimizing Model and DAX Performance](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 33, Optimizing Model and DAX Performance
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 removing unnecessary rows and columns improves VertiPaq c
![[PL-300] 32, Semi-Additive Measures, Quick Measures, and Calculation Groups](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 32, Semi-Additive Measures, Quick Measures, and Calculation Groups
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 semi-additive measures aggregate across spatial dimension
![[PL-300] 31, Iterator and Statistical Functions](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 31, Iterator and Statistical Functions
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 differentiate standard column aggregators from row-by-
![[PL-300] 30, DAX Time Intelligence](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 30, DAX Time Intelligence
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:
- Essential prerequisites for proper date tables including cont
![[PL-300] 29, FILTER, ALL, VALUES, and Filter Modification](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 29, FILTER, ALL, VALUES, and Filter Modification
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 ALL and REMOVEFILTERS clear existing filter context to ca
![[PL-300] 28, CALCULATE and Context Transition](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 28, CALCULATE and Context Transition
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 CALCULATE modifies filter context and follows a strict ev
![[PL-300] 27, Building Aggregation Measures](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 27, Building Aggregation Measures
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 choose between COUNT, COUNTA, and COUNTROWS for effici
![[PL-300] 26, DAX Syntax, Row Context, and Filter Context](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 26, DAX Syntax, Row Context, and Filter Context
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:
- The crucial distinction between scalar values and table resul
![[PL-300] 25, Measures vs Calculated Columns and Tables](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 25, Measures vs Calculated Columns and Tables
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:
- Differences in evaluation time and RAM storage between measur
![[PL-300] 24, Creating a Common Date Table](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 24, Creating a Common Date Table
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 generate date tables using DAX functions like CALENDAR
![[PL-300] 23, Cross-Filter Direction and Relationship Paths](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 23, Cross-Filter Direction and Relationship Paths
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:
- Default to single cross-filter direction to preserve query pe
![[PL-300] 22, Relationship Cardinality](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 22, Relationship Cardinality
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 select one-to-many, one-to-one, and many-to-many cardi
![[PL-300] 21, Role-Playing Dimensions](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 21, Role-Playing Dimensions
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 identify role-playing dimension scenarios involving Or
![[PL-300] 20, Table and Column Properties](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 20, Table and Column Properties
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 Sort by Column to resolve chronological sort
![[PL-300] 19, Star Schema Design and Model Granularity](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 19, Star Schema Design and Model Granularity
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 distinguish fact tables from dimension tables to estab
![[PL-300] 18, Relationship Keys and Query Load Settings](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 18, Relationship Keys and Query Load Settings
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 handle composite keys by concatenating columns or crea
![[PL-300] 17, Merge Queries vs Append Queries](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 17, Merge Queries vs Append Queries
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 Merge Queries joins tables horizontally using matching ke
![[PL-300] 16, Reference Queries vs Duplicate Queries](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 16, Reference Queries vs Duplicate Queries
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 reference queries maintain parent-child lineage and autom
![[PL-300] 15, Building Fact and Dimension Tables in Power Query](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 15, Building Fact and Dimension Tables in Power Query
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 transform flat source data into fact and dimension tab
![[PL-300] 14, Converting JSON, XML, and Lists into Tables](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 14, Converting JSON, XML, and Lists into Tables
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 convert top-level JSON and XML list structures into ta
![[PL-300] 13, Pivoting, Unpivoting, and Transposing Data](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 13, Pivoting, Unpivoting, and Transposing Data
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:
- Why Unpivot Other Columns is necessary to dynamically absorb
![[PL-300] 12, Grouping and Aggregating Rows](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 12, Grouping and Aggregating Rows
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 single and multiple key combinations dictate table granul
![[PL-300] 11, Creating and Transforming Columns](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 11, Creating and Transforming Columns
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 distinguish between Power Query transformations and DA
![[PL-300] 10, Data Types, Locale, and Type Conversion](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 10, Data Types, Locale, and Type Conversion
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 distinction between decimal and fixed decimal for financi
![[PL-300] 9, Fixing Nulls, Errors, and Data Quality Problems](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 9, Fixing Nulls, Errors, and Data Quality Problems
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 replacing errors with zero versus leaving nulls impacts D
![[PL-300] 8, Data Profiling, Column Quality, and Statistics](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 8, Data Profiling, Column Quality, and Statistics
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 Column Quality, Distribution, and Profile features functi
![[PL-300] 7, Creating and Using Power Query Parameters](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 7, Creating and Using Power Query Parameters
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 Power Query parameters dynamically modify server names, f
![[PL-300] 6, Import, DirectQuery, and DirectLake](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 6, Import, DirectQuery, and DirectLake
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:
- Core operational differences between Import, DirectQuery, and
![[PL-300] 5, Data Source Settings, Credentials, and Privacy Levels](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 5, Data Source Settings, Credentials, and Privacy Levels
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 data source settings, file paths, and authen
![[PL-300] 4, Connecting to Files, Databases, and Semantic Models](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 4, Connecting to Files, Databases, and Semantic Models
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 choose between single file connectors and the Folder c
![[PL-300] 3, The End-to-End Power BI Data Analyst Workflow](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 3, The End-to-End Power BI Data Analyst Workflow
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:
- Domain 1 responsibilities including data connections, Power Q
![[PL-300] 2, Exam Domains, Scoring, and Question Strategy](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 2, Exam Domains, Scoring, and Question Strategy
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:
- Breakdown of the four PL-300 exam domain weightings across da
![[PL-300] 1, What the PL-300 Exam Covers](https://artwork.captivate.fm/907c2e4d-00fc-42d7-ab0b-4e2a868ab36e/tech-exam-prep-cover.png)
[PL-300] 1, What the PL-300 Exam Covers
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:
- Structure, scoring, and audience requirements for the Microso

CCA-F Exam Prep 45, Reliability — Idempotency, Timeouts, and Failure Modes
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 idempotent tool actions prevent duplicate operations duri

CCA-F Exam Prep 44, Evaluating Agent Quality
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:
- The five critical dimensions for measuring agent quality: tas

CCA-F Exam Prep 43, RAG — Retrieval-Augmented Generation
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:
- RAG provides external, real-time knowledge to LLMs like Claud

CCA-F Exam Prep 42, Prompt Caching — Reducing Latency and Cost
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:
- Prompt caching can drastically reduce latency and input token

CCA-F Exam Prep 41, The Context Window and How Claude Uses Context
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:
- That the CCA-F exam tests context management as a core archit

CCA-F Exam Prep 40, Common Tool-Design Pitfalls
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 vague tool descriptions confuse language models and are a

CCA-F Exam Prep 39, Auth and Security in MCP
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:
- The importance of authenticating both servers and clients in

CCA-F Exam Prep 38, Building an MCP Server
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:
- An MCP server is a program that exposes capabilities like too

CCA-F Exam Prep 37, MCP Resources, Tools, and Prompts
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:
- The distinct functions of MCP primitives: Tools perform actio

CCA-F Exam Prep 36, Designing Good Tool Definitions
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:
- A tool definition consists of three key parts: a clear, verb-

CCA-F Exam Prep 35, MCP Architecture — Hosts, Clients, and Servers
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:
- An MCP Host is the user-facing AI application, such as Claude

CCA-F Exam Prep 34, What Is the Model Context Protocol MCP
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:
- MCP is an open standard, not a proprietary tool, designed to

CCA-F Exam Prep 33, Prompt Evaluation and Iteration
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:
- To treat prompts as code by applying a systematic cycle of te

CCA-F Exam Prep 32, Handling Ambiguity and Clarifying Questions
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:
- Why asking targeted clarifying questions is essential when us

CCA-F Exam Prep 31, Prompting for Tool Use
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:
- Why precise tool descriptions, including name, purpose, and u

CCA-F Exam Prep 30, Chain-of-Thought and Extended Thinking
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 Chain-of-Thought prompting improves accuracy on complex,

CCA-F Exam Prep 29, Few-Shot Prompting
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:
- Few-shot prompting guides a model by providing 2-5 input-outp

CCA-F Exam Prep 28, Constraining Output — Schemas and Prefilling
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:
- To define explicit output schemas with strict data types and

CCA-F Exam Prep 27, Structured Output — JSON and XML
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:
- Why structured output (JSON/XML) is a critical integration sk

CCA-F Exam Prep 26, System Prompts vs User Prompts
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:
- System prompts establish the AI's persistent role, rules, and

CCA-F Exam Prep 25, Prompt Engineering Fundamentals
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:
- The four essential components of a strong prompt: Role, Task,

CCA-F Exam Prep 24, Context Management in Claude Code
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:
- That the CCA-F exam tests context management as a core skill

CCA-F Exam Prep 23, Configuration — Settings and Environment
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 Claude Code uses a cascading system of user-level and pro

CCA-F Exam Prep 22, Workflows and the Plan-Apply Pattern
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:
- The Plan-Apply pattern is a two-step workflow: the AI first p

CCA-F Exam Prep 21, Subagents in Claude Code
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 subagents in Claude Code function as specialized, tempora

CCA-F Exam Prep 20, Permissions and the Approval Model
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:
- Claude Code's permission model defaults to 'ask-each-time' fo

CCA-F Exam Prep 19, Slash Commands and Custom Skills
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:
- What slash commands are and their role in standardizing workf

CCA-F Exam Prep 18, Hooks — Running Commands on Lifecycle Events
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:
- That hooks are for deterministic policy enforcement, while pr

CCA-F Exam Prep 17, CLAUDE.md — Project Memory and Instructions
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 CLAUDE.md provides persistent, project-specific instructi

CCA-F Exam Prep 16, What Is Claude Code
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:
- Claude Code is an agentic tool that directly manipulates file

CCA-F Exam Prep 15, Common Agentic Anti-Patterns
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 identify over-engineered solutions that add unnecessar

CCA-F Exam Prep 14, Tool Use in the Agentic Loop
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 Claude's native tool use (function calling) enables model

CCA-F Exam Prep 13, Guardrails and Human-in-the-Loop
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:
- Guardrails are safety controls that bound an AI agent's auton

CCA-F Exam Prep 12, Plan Mode and Multi-Step Planning
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:
- Plan mode separates planning from execution, a crucial patter

CCA-F Exam Prep 11, Escalation — When to Hand Off
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:
- The two primary escalation paths tested on the CCA-F exam: AI
Recommended

Take Back Your Health®

CBS Radio Mystery Theater | Old Time Radio

Solved Murders - True Crime Stories

紐約鳥|New York Aperture

The Swerve Podcast: Obscure Topics | Conspiracy Theories

The Bread and Banter Podcast

The Church of What's Happening Now: The New Testament

Busted Open

Deadline: White House

Crickets Corner

History of the Earthquake and Fire in San Francisco

Fox news