Power BI Performance Tuning: 1-Day Workshop
Slalom Consulting
This professional service offering provides guidance and best practices for optimizing Microsoft Power BI performance.
This professional service offering provides guidance and best practices for optimizing Microsoft Power BI performance.
Guidance and best practices for optimizing Power BI performance. It is particularly helpful for use cases involving Direct Query with cloud-based data warehouse products (e.g., Snowflake, Azure SQL Data Warehouse) and legacy data warehouse appliances (e.g., Teradata, Netezza).
Agenda
Establishing performance benchmarks
Leveraging telemetry
Architecture and configuration
- Remember storage is cheap, compute is expensive. In any analytics platform it is important not to pay for compute twice
- Design principals
- When to use import vs Direct Query vs Live Connect
- Identifying network constraints
- Utilizing resources to optimum potential
- Optimizing data loading and refresh
Desktop
- Avoiding memory and CPU spikes
- Eliminate inappropriate use of visuals that generate large amounts of source data queries
- Modeling
- DAX
- M (mashup queries)
Power BI Premium vs Pro
Determining capacity requirements and roadmap
Trouble shooting and debugging
In addition to providing instruction, an objective of this workshop is to learn specifics of your analytics platform. We will assist you to diagnose bottlenecks, inefficiencies, and deliver recommendations to achieve a highly performant Power BI solution. Partner with Slalom to meet your business objectives.
