The client runs a retail business with 3 branches in Lagos,
Abuja and Kano. Sales data was scattered across separate
sheets with inconsistent entries, missing amounts, and
no way to see overall business performance.
Cleaned all branch data independently, merged everything
into one master sales table, and matched each sale with
correct product details, calculated all missing amounts
automatically using Quantity × Unit Price.
Built a Pivot View showing revenue comparison across
all 3 branches per product category. Delivered a
Summary Dashboard with key metrics and charts showing
the best-performing branch and the top-selling category.
Set up an input sheet with dropdown validation so the client
adds new monthly sales and clicks Refresh to update
everything automatically.
0 likes · 0 views · May 18, 2026
The client runs a retail business with 3 branches in Lagos, Abuja and Kano. Sales data was scattered across separate sheets with inconsistent entries, missin...
