Back to Gallery
Power BICapstone Project
Pakistan E-Commerce Sales Performance Dashboard
ZA
BUILT BYZainab Amin
BEFOREBBA Student
→
OUTCOMEBI Intern at Daraz
Status: Live DeployedInteractive Live Demo (Sandbox)→
Project Overview
An interactive dashboard mapping order status, provincial sales distribution, and customer retention metrics across 50k+ transactions.
Data Scrubbing & Cleaning Pipeline
The student imported raw messy CSV database backups, scrubbed redundant column entries, normalized data structures, handled duplicate records, and configured relationship models using SQL schemas and Power BI.
Analytical Insights Generated
Configured cohort retention models, isolated regional operational leakages, tracked active customer churn risk, and mapped average revenue metrics across locations.
Project Specs
CORE TOOLPower BI
DATA ROWS PROCESSED500,000+ Records
TIME TO BUILD3 Weeks
COMPLEXITY LEVELHiring Grade