← All Work

Retail / FMCG

APAC Regional BI Platform

One consistent view for five departments and five markets.

Company
Lynx Analytics
Year
2022
Role
Dashboard design & development, data processing.
Result
5 × 5
APAC Regional BI Platform overview dashboard

The Problem

Metrics scattered across functions.

Regional planning and management reviews were hard to prepare consistently.

What I Built

Pipeline, dashboard, handover.

Azure Data Factory, Blob Storage and SQL Server refresh; end-to-end Power BI dashboard; technical docs for client IT.

The Outcome

One view, every review.

Quarterly and annual reviews across 5 departments and 5 markets, minimal intervention in weekly refresh.

Inside the Dashboard

Dashboard navigation by function and marketSales outcome and external drivers by marketData sources table listing each metric and its source

Azure · SQL Server · Power BI

Shown with sample data.