Making Your Power BI Teams More Analytic with Microsoft Fabric - Introduction

  1 min read  

Making Your Power BI Teams More Analytic with Microsoft Fabric - Introduction

You spend all day helping your customers be more analytic, so why are you so unanalytic about how you run your data analytics teams? This aphorism has stuck with me since I first read it years ago in the DataOps Cookbook.

I’ve strived to make my teams more analytic, but this can be a challenge with Power BI. As a frequent reviewer of Power BI semantic models and reports, I aim to answer several critical questions:

  1. Do pending semantic model changes still adhere to the best practices my team has set?

  2. Do pending report changes still adhere to the best practices my team has set?

  3. Have any semantic model changes adversely affected a report by introducing broken visuals?

  4. Are there recurring issues with semantic models or reports that require coaching the team or individual members to avoid?

  5. Have the number of issues improved or worsened over time? By team member?

Answering these questions requires one crucial component: data. But how do we generate, store, and analyze the data necessary to answer these questions and make our development process more analytic?

Over the next several blog posts, I’ll introduce techniques to address these questions, and possibly ones you’re thinking of as well. This series involves integrating several open-source third-party tools and Microsoft products, including Power BI, Eventhouse, and Azure DevOps. To make it manageable, I’ve broken it into the following series:

Making Your Power BI Teams More Analytic with Microsoft Fabric

  1. Introduction
  2. The Foundation
  3. Tracking Changes
  4. Report - Static Analysis
  5. Semantic Model - Static Analysis
  6. Real-time Analytics - Medallion Architecture
  7. Build Validation/Pull Requests
  8. Analyzing Results
  9. Report - Dynamic Analysis
  10. Semantic Model - Dynamic Analysis

I hope you find this series helpful in making your teams more analytic. Up next: The Foundation.

As always, let me know your thoughts on LinkedIn.