Power BI · Power BI Desktop

Video: Advanced Analytics Features In Power BI

Following on from my last post, another SQLBits session of mine I wanted to highlight was “Advanced Analytics Features In Power BI”. The subject is a bit outside my normal area of expertise but it’s also one that I don’t think gets enough attention: it’s all the features available in Power BI reports that can help you explain why something happened rather than just what happened. Things I talk about include:

  • Adding forecasts to line charts
  • Symmetry shading, ratio lines and clustering on scatter charts
  • The “Explain the increase” and “Find where this distribution is different” features
  • The Key Influencers and Decomposition Tree visuals
  • Custom visuals such as Sanddance
  • Natural language querying with Q&A

4 thoughts on “Video: Advanced Analytics Features In Power BI

  1. Thanks for the post! One thing I like to do is analyze the cluster analysis. Meaning, why did the algorithm choose the clusters that it did? It’s not perfect, but I use the Key Influencers visual and drag the cluster column into the field to predict. Choosing various fields to predict by and switching the cluster to predict can provide some insight into why the algorithm chose what it did.

    1. Chris Webb – My name is Chris Webb, and I work on the Fabric CAT team at Microsoft. I blog about Power BI, Power Query, SQL Server Analysis Services, Azure Analysis Services and Excel.
      Chris Webb says:

      That’s a really good idea, thanks for mentioning it

  2. AHMED DAFFAIE – Senior Power BI Developer with good experience of DAX query, M codes, Power App, M365, Excel, PowerPivot. Currently, I am studying Azure services

    I wouldn’t know those stuff. Thank you Chris

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.