How to Use Correlation Plot to Improve Storytelling and Analysis in Power BI

That is right, we are going to step up our game and start adding correlation analysis to our reports and dashboards. Why would you want to do that? Well, a good reason could be to analyze whether there is a relationship between two variables. Yes, technically, you would want to run a regression to get a better answer, but correlations can be a useful first step that does not require us to have an extensive data science background.

In this video, I am trying to figure out whether coronavirus New Cases metric is a good leading indicator with respect to predicting deaths and making policy decisions in Illinois. My analysis is somewhat crude as it does not do a very good job of adjusting data for time lag that would normally occur between a new case being reported and then death, but my rolling ten day calculations should address this lag somewhat and at the end of the day the purpose of the video is not to argue policy decisions, but rather to introduce the Correlation Plot Power BI visual and to give you a good example of how it might be used.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s