bench3D/fmcg-executive-level-dashboard-analysis

AI COMMUNITY AFRICA, DATA ANALYSIS TRACK - Returning Learners, Capstone Project # **AI COMMUNITY AFRICA** ## **DATA ANALYSIS TRACK** - *Returning Learners - Capstone Project* # **1. Project Overview** This capstone project is your opportunity to demonstrate every skill you have built across all five months and all 20 sessions of the programme, from raw data import and Power Query transformation, through data modelling, advanced DAX, statistical EDA, AI-driven visuals, and deployment to the Power BI Service. You have been hired as a Data Analyst at TradeFlow Nigeria, a fictional FMCG distribution company with operations in Lagos, Abuja, Port Harcourt, Kano, and Ibadan. The Head of Commercial Analytics has asked you to build an executive-level Retail Sales Performance Dashboard that surfaces revenue trends, product performance, sales-team KPIs, regional insights, and forward-looking analysis — all in a single, interactive Power BI report. Management needs to make Q3 budget decisions within two weeks. Your dashboard is the primary input. ## **1.1 Why This Project Matters** This capstone is intentionally designed to mirror a real commercial brief. It tests not only your technical ability, but also your capacity to communicate insights clearly to a non-technical audience. Every skill from every session maps directly to a task you will perform in this project. --- # **2. Dataset — Download Links** Your dataset is a simulated but realistic multi-table collection, designed to replicate the kind of messy, real-world data you will encounter in a Nigerian FMCG business. Download each file individually using the links in the table below, or download the full bundle from the ZIP link provided underneath. File Name Table Type Format Download Link Sales.csv Fact Table — Orders CSV Download Sales.csv Products.csv Dimension — Products CSV Download Products.csv Customers.csv Dimension — Customers CSV Download Customers.csv SalesReps.csv Dimension — Sales Reps CSV Download SalesReps.csv Targets.csv R …