KEEPINTOUCH
ShareQL Power Platform, Power BI, Fabric coaching and consulting
Master Class Ultimate Power BI Optimization
The trainer is Isabelle Van Campenhoudt
13x Data Platform MVP
Duration :
2 days
Audience :
Citizen developers, developers
To book this training :
...just contact us here
Next public session :
February 14, 2025
The "Performance Optimization Training" course enhances the efficiency and speed of data processing and reporting in Power BI. It covers best practices for Power Query, efficient data modeling, DAX tuning, and report design. The course also includes professional development techniques, tools for diagnosing performance issues, and a comprehensive wrap-up to consolidate learning and ensure the ability to apply the knowledge in real-world scenarios.
Your trainer is Isabelle Van Campenhoudt, with 25 years of experience in the Microsoft Data platform
Course content:
Module 1: Power Query Best Practices
-
Objective: Optimize data import and transformation processes.
-
Content:
-
Techniques to minimize data loading times.
-
Tips on using native query functionalities.
-
Strategies for data reduction and efficient queries.
-
Module 2: Efficient Modeling Patterns
-
Objective: Develop optimized data models for better performance.
-
Content:
-
Importance of using star schema modeling.
-
Best practices for setting up relationships and hierarchies.
-
Techniques to reduce model complexity and improve data refresh rates.
-
Module 3: DAX Tuning
-
Objective: Enhance calculations and overall report speed.
-
Content:
-
Identifying and rewriting expensive DAX queries.
-
Using variables to simplify DAX calculations.
-
Performance implications of common DAX functions and how to optimize them.
-
Module 4: Report Do's and Don'ts
-
Objective: Understand the impact of report design on performance.
-
Content:
-
Effective use of visuals to improve report rendering.
-
Common pitfalls in report design and how to avoid them.
-
Balancing aesthetics and performance in report layouts.
-
Module 5: Develop Like a Pro
-
Objective: Implement professional development techniques for scalable solutions.
-
Content:
-
Version control for Power BI projects.
-
Using templates and themes for consistency and speed.
-
Managing and deploying changes in a professional environment.
-
Module 6: Tooling
-
Objective: Utilize tools to diagnose and resolve performance issues.
-
Content:
-
Introduction to Performance Analyzer and DAX Studio.
-
How to use these tools to find and fix performance bottlenecks.
-
Setting up and interpreting benchmarking results for ongoing performance management.
-
Module 7: Wrap-up: Method to Improve a Report in Every Aspect
-
Objective: Consolidate learning and ensure ability to apply knowledge.
-
Content:
-
Step-by-step method to review and optimize an existing report.
-
Checklist for performance optimization before report deployment.
-
Discussion on maintaining performance in new and existing reports.
-