エピソード

  • [PL-300] 4, Connecting to Files, Databases, and Semantic Models

    [PL-300] 4, Connecting to Files, Databases, and Semantic Models
    2026/09/03
    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 connector for combining scheduled data drops. - How native SQL queries in relational database connections impact Power Query query folding. - Key differences between Import mode, DirectQuery mode, and Live Connections for performance and features. - How Privacy Levels prevent data leakage and resolve Formula Firewall errors during multi-source queries. - How to extend shared Power BI semantic models using composite models and DirectQuery. 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 分
  • [PL-300] 3, The End-to-End Power BI Data Analyst Workflow

    [PL-300] 3, The End-to-End Power BI Data Analyst Workflow
    2026/09/02
    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 Query transformations, and query folding versus DAX calculated columns. - Domain 2 concepts focusing on star schema design, DAX measure creation, and defining Row-Level Security rules in Power BI Desktop. - Domain 3 techniques for visual selection, drillthrough navigation, bookmarks, and using Performance Analyzer to troubleshoot slow reports. - Domain 4 operational tasks including publishing, workspace management, scheduled refresh configuration, and On-premises Data Gateway setup. - The PMVD mental shortcut to instantly map end-to-end Power BI workflow stages to their exact PL-300 domain ownership on the exam. 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 分
  • [PL-300] 2, Exam Domains, Scoring, and Question Strategy

    [PL-300] 2, Exam Domains, Scoring, and Question Strategy
    2026/09/01
    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 data prep, modeling, visualization, and service management. - How Microsoft's 700 scaled-score scoring standard works and why unanswered questions should never be left blank. - Proven time management strategies for navigating the 100-minute exam and handling non-reversible case study sections. - How to analyze Microsoft question formats, including multi-select steps, drag-and-drop, and scenario-based items. - Effective techniques to spot and eliminate plausible distractors using the FOCUS mnemonic for 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 分
  • [PL-300] 1, What the PL-300 Exam Covers

    [PL-300] 1, What the PL-300 Exam Covers
    2026/08/31
    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 Microsoft PL-300 Power BI Data Analyst exam - Breakdown of the four core skill domains: data preparation, data modeling, visualization, and workspace deployment - Concrete distinction between Power Query transformation logic and DAX analytical modeling - Critical exam traps including calculated column memory overhead and bi-directional relationship pitfalls - The PMVD memory shortcut for systematically approaching Power BI exam scenarios 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 分
  • CCA-F Exam Prep 45, Reliability — Idempotency, Timeouts, and Failure Modes

    CCA-F Exam Prep 45, Reliability — Idempotency, Timeouts, and Failure Modes
    2026/08/30
    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 during retries. - Why aggressive timeouts on all external calls are critical for system stability. - The importance of bounding iterations to prevent runaway agentic loops. - How to design for graceful degradation instead of system crashes during partial failures. - The critical difference between a tool failing to connect and returning an empty result. 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
    続きを読む 一部表示
    3 分
  • CCA-F Exam Prep 44, Evaluating Agent Quality

    CCA-F Exam Prep 44, Evaluating Agent Quality
    2026/08/29
    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: task accuracy, tool-use correctness, reliability, efficiency, and safety. - Why a CCA-F certified architect must establish observability with logs and traces to prevent performance drift. - How to build effective evaluation suites using a mix of representative and adversarial test cases. - Common exam traps, such as confusing conversational success with actual task completion or incorrect tool usage. - A mnemonic to remember the evaluation dimensions: Teachers Rate Students Effectively and Accurately (Tool-use, Reliability, Safety, Efficiency, Accuracy). 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 分
  • CCA-F Exam Prep 43, RAG — Retrieval-Augmented Generation

    CCA-F Exam Prep 43, RAG — Retrieval-Augmented Generation
    2026/08/28
    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 Claude by retrieving relevant information at query time. - For the CCA-F exam, you must know to choose RAG over fine-tuning for applications that rely on dynamic, proprietary, or citable information. - Exam questions often present scenarios testing the RAG vs. fine-tuning decision, where fine-tuning is typically the 'trap' answer for knowledge-based tasks. - Troubleshooting a failing RAG system usually points to problems in the retrieval step (e.g., poor data quality, bad chunking), not the LLM itself. - Use the mnemonic: "RAG for knowledge you have, Fine-tune for skills you want" to distinguish their primary use cases. 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
    続きを読む 一部表示
    3 分
  • CCA-F Exam Prep 42, Prompt Caching — Reducing Latency and Cost

    CCA-F Exam Prep 42, Prompt Caching — Reducing Latency and Cost
    2026/08/27
    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 costs by up to 90% for repeated API calls. - Caching applies only to the stable, initial part of a prompt, such as system prompts, tool definitions, or large documents. - A cache hit requires an exact, character-for-character match of the prompt prefix in the correct order. - For the CCA-F exam, structuring prompts with a long, stable prefix is a key strategy for optimizing agentic applications. - Be aware of the short default Time-to-Live (TTL) for cached prompts, which is typically around 5 minutes unless configured otherwise. 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 分