Data & Analytics
Canada Grocery Inflation Analysis
Power BI
Analyzed multi-year food price trends using Statistics Canada open datasets across 100+ categories. Interactive dashboard for Consumer Price Index fluctuations and socio-economic impact.
Overview
Built an interactive Power BI dashboard from Statistics Canada CPI and food price datasets. Explored price changes across 100+ food categories over multiple years.
Approach
Extracted and transformed data from Statistics Canada open data portal, created star schema for efficient querying, designed measures for year-over-year and category-level comparisons.
Results
Delivered dashboard enabling policymakers and researchers to explore CPI trends, compare regional differences, and identify categories with highest inflation impact.