Categories: Power BI
Tags:

Power BI Dashboard Tutorial: Product Retail Prices in Canadian Provinces

This Power BI dashboard presents a comprehensive analysis of retail prices of products across various Canadian provinces, incorporating tax implications, essentiality classification, product categories, and time-based trends.

Power BI Dashboard Tutorial: Product Retail Prices in Canadian Provinces

Whether you’re an economist, a data analyst, or a curious consumer, this dashboard provides you with key insights into how product prices evolve and differ based on region, time, and taxability.

Get the Dataset here : https://www.kaggle.com/datasets/aradhanahirapara/product-retail-price-survey-2017-2025?select=Retail_Prices_of+_Products.csv

🧭 Section-Wise Breakdown:

1. Filter Panel (Top Row):

  • Essential / Non-Essential: Filter products by their essentiality.
  • Taxable / Non-Taxable: Toggle between taxable vs non-taxable items.
  • Year & Month: Analyze trends over specific years or months.
  • Product Category & Specific Products: Narrow down analysis by food and non-food categories and even individual products.

2. Trend Chart – Avg Value Over Years (Top Left):

Shows how average product prices (with and without tax) have changed from 2017 to 2025. Ideal for spotting inflation trends and tax impact over time.

3. Seasonality Chart – Avg Value by Month (Top Center):

Highlights monthly fluctuations in product prices. Great for understanding seasonal effects on retail pricing.

4. Provincial Analysis – Tax Impact (Top Right):

Visualizes price differences across provinces, showing:

  • Average price
  • Taxed price
  • Tax rate trend per province

Useful for comparing provincial tax policies and their real-world effects on retail prices.

5. Category-wise Pricing (Bottom Left):

Bar chart displaying average values by product categories like Infant Food, Meat, Toiletries, etc.

Use this to identify high-value categories and how taxes alter final prices.

6. Product-wise Detail (Bottom Center):

Displays individual product prices, helping identify most and least expensive items, and direct comparison of taxed vs untaxed values.

7. Donut Charts – Essential vs Non-Essential & Taxable vs Non-Taxable (Bottom Right):

Pie/donut visuals for quick view of average values grouped by:

  • Essentiality
  • Taxability

These provide summary-level understanding of how categories affect price.