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.
- Confirmed cases : https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv
- Deaths: https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_global.csv
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.
- Population by state by year - Federal Reserve Bank of St. Louis
- GDP by state by year - U.S. Bureau of Economic Analysis