Project Files
Explore the full Power BI report and visuals
Read Full Report on Medium →
Explore Project on GitHub →
Project Overview
This Power BI dashboard visualizes the COVID-19 pandemic in Australia from 2020 to 2022. It highlights critical statistics including case numbers, death counts, hospitalization trends, vaccination rollouts, and fatality rates across Australian states and territories.
Data Source
All data is sourced from the Australian Government Department of Health and public health databases. Visuals were created using Power BI for clarity and interactive storytelling.
Key Metrics
- COVID Cases: 10.72 Million
- Hospitalizations: 1.04 Million
- ICU Admissions: 72.26 Thousand
- Ventilator Cases: 26.85 Thousand
- Total Deaths: 16.19 Thousand
- Vaccine Doses Administered: 64.32 Million
Dashboard Pages
1. State-wise Distribution of COVID-19 Cases
- Map shows intensity of COVID cases by state
- Interactive filters for year and case type
2. COVID-19 Monthly Summary
- Line chart comparing monthly cases vs deaths
- Shows peak and decline trends month by month
3. Fatality Rate by State
- Victoria had the highest fatality rate (0.22%)
- Lowest in Northern Territory and Tasmania (0.06%)
4. State-wise Hospitalization Rate
- Highest hospitalization in Northern Territory
- Lowest in Western Australia
5. Yearly Trends: Cases & Vaccinations
- Steep rise in cases in 2022
- Massive vaccination rollout in 2021 and 2022
6. Hospitalization & Death Composition
- Hospitalized: 98.47%, Death: 1.53%
- Within hospitalizations: 88.95% Other, 6.92% ICU, 1.61% Ventilator
Observations
- COVID-19 impact peaked in 2022 in terms of cases
- Victoria had the highest fatality and hospitalization metrics
- Early vaccination drive helped reduce death rates over time
Skills Demonstrated
- Advanced Power BI dashboard design
- State and yearly comparisons
- Data storytelling through interactive visuals
- Trend analysis using dynamic slicers and filters
© 2025 | Project by Kalyan Dangi | Data Source: Australian Government Health Department