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

3 responses

  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.

Leave a Reply

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

%d bloggers like this: