Maybe go for a run, call some friends you haven't spoken to in a while, clear out your old clothes for charity or sharpen up your skills. And Udemy is the ideal platform for this with a wide range of topics you could upskill yourself on. To make upskilling yourself even easier, we have discounted our entire course range for the next 30 days with discounts of over 75% across the board. Feel free to share this post with friends or colleagues who might be stuck with little to do. Just click the link to the course(s) of your choice and take advantage of this "BEAT_COVID19" offer. Remember that you get a money back guarantee on any of our courses, and lifetime access so you can complete the course at your leisure. Excel Courses (Discounted to between $12.99 and $13.99)
Until next time - keep safe! Ian and Scott * Brian Tracy is an American-Canadian motivational speaker and author of several self-improvement books.
0 Comments
Below is our Power BI visualisation on the Covid-19 coronavirus. For more on the background regarding how we put this together, please see our previous blog post.
To interact with the visualisation, please consider clicking on the expand to full view icon on the bottom right hand corner below the visualisation. You can click on any of the countries in the table to filter for just that country. There are also 2 filters at the top for "Rest of the world" or "China". You can also click for specific regions like Europe or Americas etc. To clear the filter, either click on white space or click the clear filter icon on the top left hand corner.
What we have found though is that the data WHO provide does have some anomalies. For example, we found cases where the total number of deceased in some countries would drop which is literally a miracle. Digging into these, we found that most of the anomalies have an explanation of some sort. (eg Some deaths were incorrectly attributed to Covid-19 and this was later corrected.) As a result, we decided that a few anomalies found in the inevitable chaos that dealing with a rapidly spreading disease introduces was acceptable. Once we found a source of data we were happy with, the next problem was getting this into a usable format. The daily situational reports from WHO are published as PDF documents. We had to take these and somehow get them into a data format. This involved converting the PDF to Microsoft Word format and then copying the data from Word to Microsoft Excel. However, we still had more to do. The way the situation reports gave data was not ideal. For example, the number of cases and new cases were given in one field with the new cases shown as a bracketed number next to the total cases. We needed to split out the new cases from the total cases and have these as 2 separate fields.
We now have an automated process where we simply past the data from the daily situation reports, and refresh our Excel data source. This process takes around 5 minutes which is manageable. Having found a way to get solid data in a usable format, we were able to build a visualisation using Power BI. We can now update our visualisation with the new data on a daily basis and it's available for public consumption. We published the dashboard to the Power BI server for access by anyone who wants to view it. We've published the actual visualisation in it's own dedicated blog post click HERE to see it. Our plan is to keep this updated as new data comes in. We hope you find this interesting.
That's all for now... Scott (and big thanks to Ian for all his hard work in making this visualisation happen!) |
Categories
All
Archives
April 2020
|