Exploring the Power of PowerBI

Exploring the Power of PowerBI

Having my hands dirty with Tableau and R for data visualisation, I started exploring PowerBI. I would like to share some of the reports I have created using public datasets. These reports were created in PowerBI Desktop and published to PowerBI Service. I was able to embed them into this post from there.

World distribution of COVID-19

This is the hot topic of the year when I'm writing this post. I was able to get data of the cumulative deaths and cases by country from the Johns Hopkins University’s public GitHub account in below links.

The cool thing about this report is that the dataset is scheduled to get refreshed daily through the PowerBI service. Since this was a learning experience, I tried to mimic some of the features of the actual dashboard at https://coronavirus.jhu.edu/map.html, however, noticed that the data is few days behind.

Economic Indicators of US States

New York and California ... are they the wealthiest states in US? In this report I have looked at some economic indicators of US states, including GDP per Capita, population and their growth from 1997 - 2015.

Data sets

  • Population by state by year - Federal Reserve Bank of St. Louis
  • GDP by state by year - U.S. Bureau of Economic Analysis