Stop Building Reports Wrong: Power BI Optimization Best Practices

Catch the Jam Session live on Fridays, exclusively at the Insight Jam https://insightjam.com
Join today to stay up to date and join the human conversation around tech and AI.

Wayne Eckerson brings together Power BI experts David Booth and Carlos Bossy to expose the common pitfalls preventing organizations from maximizing their Power BI investments, including a case study of an enterprise with nearly 2000 workspaces and a 1:1 dataset-to-report ratio that created governance nightmares, security gaps, and inconsistent reporting that eroded trust in analytics. The experts provide actionable frameworks for Power BI optimization including workspace governance through Azure Active Directory groups, dimensional modeling for semantic layers, golden dataset strategies that eliminate conflicting metrics, storage mode selection for performance optimization, and reporting standards that ensure consistency across the enterprise.

Discover quick wins like eliminating inactive workspaces, implementing proper naming conventions, and leveraging monitoring APIs for continuous improvement. Whether you're struggling with slow report refreshes, untrusted data, or scaling Power BI across your organization, this session delivers proven methodologies for achieving Power BI excellence through proper governance, modeling, and user enablement.

************
Hosted by Wayne Eckerson   / weckerson   - Strategic Consultant, ‪@datalere-consulting‬

Panelists:

Carlos Bossy   / carlosbossy   President, Datalere https://datalere.com/

David Booth   / dbbooth   - Senior Data Engineer, Datalere https://datalere.com/

************
0:00 Introduction
3:01 Pitfall 1: Poorly Governed Workspaces and Security
14:52 Pitfall 2: Inadequate Data Modeling Practices
31:36 Pitfall 3: Creating Golden Datasets for Single Source of Truth
44:24 Pitfall 4: Storage Mode Selection for Performance
49:18 Pitfall 5: Report Consistency and Standards
54:17 Pitfall 6: Under-Utilizing Power BI Licensing