My first Power BI project! Previously, I worked with Looker, but this is my first hands-on Power BI dashboard.
It visualizes daily COVID-19 cases across Sri Lanka’s districts.
- Line Chart: Daily trend of COVID-19 cases
- Bar Chart: District-wise total cases
- KPI Cards: Total | Average | Max daily cases
- Optional: 7-day moving average for trend smoothing
Power BI Desktop – Dashboard creation.
Python (pandas + kagglehub) – Data loading & preprocessing.
CSV Dataset – Daily COVID-19 cases by district.
Loaded from the Sri Lanka COVID-19 Dataset on Kaggle using kagglehub:
# Install dependencies if needed:
# pip install kagglehub[pandas-datasets]
import kagglehub
from kagglehub import KaggleDatasetAdapter
file_path = "daily_situation.csv"
# Load the dataset as a pandas DataFrame
df = kagglehub.load_dataset(
KaggleDatasetAdapter.PANDAS,
"asheniranga/sri-lanka-covid19-dataset",
file_path
)
print(df.head())
''''