Data Analyst Capstone: End-to-End BI Project

Curriculum

1. 01The Brief and the PlanMeet Voltline Electronics, turn a chief executive's questions into an analysis plan with definitions and deliverables, and get to know the raw data.25 min
2. 02Profile the Raw DataCheck every column of a raw till export systematically, find the problems before they find you, and decide what to do about each one.25 min
3. 03Clean and PrepareTurn the raw till export into a clean sales table you can rerun, in Power Query, SQL or pandas, and reconcile it with the raw data so you can prove nothing was lost.25 min
4. 04Model and MeasuresBuild a model that joins tables at the right grain, look up the cost price in force on each sale date, compare actuals with monthly targets, and test the core measures.25 min
5. 05AnalyseAnswer the chief executive's questions one by one, separate real growth from price and new stores, find what's going wrong where, and put a naira value on missed sales.30 min
6. 06Dashboard and StoryTurn findings into a report a chief executive can read in five minutes, with chart titles that state the finding, an honest view of the targets and a one-page executive summary.30 min
7. 07Review, Present and PublishCheck your own work the way a reviewer will, prepare for the board's hardest questions, and turn the capstone into a portfolio piece employers will read.25 min
8. Final assessmentPass it (60% or more) to earn the Data Analyst Capstone: End-to-End BI Project course completion badge.