This self-paced advanced Power BI course is designed for those who already have experience building reports and want a deeper understanding of how Power BI manages data behind the scenes. You’ll learn how to create more reliable reports by building stronger data models with correct relationships and filter flow, ensuring totals, filters, and calculations behave as expected.
As you progress through the course, you’ll build data models using hierarchies, custom sort orders, and reusable date tables that support both fiscal and calendar reporting. You’ll deepen your DAX skills by working with parameters, inactive relationships, and context-aware calculations, implementing Row-Level Security, including dynamic user-based access, and exploring data connections, Import versus DirectQuery tradeoffs, and performance optimization through query folding. By the end of the course, you’ll be prepared to troubleshoot common modeling issues, publish secure datasets, and apply best practices aligned with the Microsoft PL-300 Power BI Data Analyst Associate certification.
What You Will Learn
- Build better data models by understanding relationships, cardinality, and cross-filter direction
- Design reliable data models and avoid common modeling mistakes
- Create and use hierarchies to organize and drill into data
- Control visual order with custom sort columns
- Create reusable date tables supporting fiscal and calendar years
- Add parameters to make reports interactive and flexible
- Implement Row-Level Security (RLS) with Static and Dynamic roles
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.