About CMBI's COVID 19 Power BI Sample Model
The report uses data from the European Centre for Disease Prevention and Control. The testing data comes from Wikipedia's en.wikipedia.org/wiki/COVID-19_testing page.
The primary motivation for the Power BI model was to understand the COVID 19 reported case growth trends. We include the Testing data to provide context for the reporting data.
Interact with the COVID 19 reports online
The embedded Power BI reports below are fully interactive. Right click on a country to select drill through reports. Use the sliders to filter the countries.
- 1) Scroll through the report pages
- 2) Expand the report to full screen
Using Drill Through
- 1) Right click a country
- 2) Select Drill Through
- 2) Select a sub report
Interpreting the COVID 19 statistics
Consider the following points when analysing any COVID 19 reported case data
- Each country has different testing strategies and ability to collect case data [IMPACT: difficult to compare countries]
- Many people infected with COVID 19 may have mild or no symtoms and not be counted [IMPACT: under reporting of cases]
- Analysis reported by the The Economist suggests that deaths are also under reported [IMPACT: under reporting of deaths]
- Death/Survival rate is difficult to determine because both reported cases and deaths are unreliable
Download all the files for this and other Power Pivot and Power BI samples
Download the CMBI COVID 19 Power BI sample model here
CMBI's Australian Census Sample includes an Excel and Power BI Desktop file to download, notes, and online interactive dashboard.
CMBI's Sydney house price Power Pivot sample includes an Excel file to download and detailed notes.
CMBI's World Cup 2018 Power Query sample includes an Excel file to download, notes, and instructional video.
About CMBI
CMBI designs and develops business intelligence and analytics solutions for clients in Sydney and regional NSW. CMBI technology expertise includes Microsoft Azure, Power BI, Power Pivot, Power Query, Excel, SQL Server, and Analysis Services.
