Homepage

RETAIL PRICE DASHBOARD

Monitor and analyze product prices across retailers in New Zealand

Google Shopping |

8 Products |

Daily Updates |

34 ML Models |

New Zealand

About This Dashboard

This dashboard tracks and analyzes real-time product prices from Google Shopping across 8 popular consumer electronics in New Zealand, covering laptops, smartphones, and action cameras from leading brands like Apple, Samsung, Dell, HP, GoPro, and DJI.

Built as an end-to-end data engineering portfolio project, the pipeline is designed to demonstrate modern data engineering practices including data ingestion, transformation, storage, orchestration, and visualization, all running on a fully automated daily schedule.

Data is collected daily via SerpAPI and loaded into AWS S3 as a data lake using dlt (data load tool) daily at 8pm NZT. From there, data is loaded into a PostgreSQL warehouse, transformed using dbt and orchestrated end-to-end with Prefect Cloud.

The goal of this project is to provide actionable price intelligence — helping consumers identify the cheapest sellers, track price trends over time, monitor discount patterns, and understand seller competition across the New Zealand electronics market.

This dashboard was created as part of the Data Engineering Zoomcamp 2026 cohort, demonstrating skills across the full data engineering stack from raw API ingestion through to an interactive analytics dashboard.

The pipeline now includes an ML forecasting layer — Facebook Prophet models are trained weekly on accumulated price history, generating 14-day forward price forecasts per product and seller with a median MAPE of 3.5% across 34 production series.

NAVIGATION GUIDE

How It Works

Navigate using the sidebar to explore each section.

Overview

High-level summary of all products and sellers.

WHAT YOU'LL FIND