Listen

Description

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 columnar compression in PL-300
- Techniques for reducing granularity and high cardinality, such as splitting datetime columns
- Why star schemas with single-direction relationships perform best on the exam compared to bi-directional options
- How to use Performance Analyzer to isolate bottlenecks between DAX query, Visual display, and Other metrics
- Methods for diagnosing and rewriting slow measures using DAX Query View to eliminate costly iterators

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