跳到主内容

Power BI Performance Tuning: 1-Day Workshop

Slalom Consulting

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.

https://gallery.azure.com/artifact/20151001/slalom.pbiperformtune1day.1.0.1/Artifacts/SampleImage/1a2c5ce5-3037-4a24-947f-66cfdb6d2a6b.png
https://gallery.azure.com/artifact/20151001/slalom.pbiperformtune1day.1.0.1/Artifacts/SampleImage/1a2c5ce5-3037-4a24-947f-66cfdb6d2a6b.png