As promised, today I am sharing with you the process I went through to build the COVID report I shared in my last article. One of the best ways to learn and improve your Power BI skills is to practice. The best way to practice is to find something you care about (work or home) and build something useful. I built this report because I care about the lack of transparency and lack of full information in Australia about what is happening with COVID.
Watch Me Do It
The video today is simply a walk through of what I did to build this report. It is actually a reproduction – I did it first, then recorded a video so you can see what I did. I have tried to keep it “warts and all” so that you can see where I made mistakes, etc. It is quite a long video (36 mins) but I hope you find it a good learning resource.
Summary Of Key Learnings
If you would like to know what I cover in the video, here is a brief list.
- I created a staging query connected to the source
- Inspected the new data source to understand its structure
- Built a star schema
- Unpivoted the data into a long skinny table
- Found and fixed errors in the transformed data
- Realised I should remove zeros from the data
- I showed how to enumerate a list of dates in Power Query
- I showed how to enter today’s date in Power Query
Interactive Report V1.0
Here is a link to the live, interactive report. This will auto refresh every day. I will show you how I did that in my next article.
Wrap Up and Next Steps
Here is a copy of the workbook so you can take a look for yourself.
You will need to download a copy of the data yourself from this link and reconnect the workbook to your local copy. https://github.com/owid/covid-19-data/blob/master/public/data/owid-covid-data.csv
I have already started to improve my report, and I plan to record more videos in the coming weeks to show you the process of continuous improvement to make version 1.0 bigger and better. Keep an eye out for those videos in the coming weeks.
Please let me know in the comments below if you like this style of video so I can get some feedback on that.