Analyst
Analyst
Project
Meridian Retail Co. · Excel · beginner
The brief
Chidi's investor presentation needs a customer growth chart. A PivotChart showing monthly customer acquisition will be the centrepiece of the customer slide.
In Meridian_Data.xlsx, create a PivotTable in a new sheet called Customer Growth using the Customers sheet. Group by acquisition month. Show count of non-duplicate customers acquired each month. Add a running cumulative total column next to the PivotTable using a formula. Build a combination chart: bars for monthly new customers, line for cumulative total. Format with Meridian brand colours — orange bars, navy line.
Independent grading
92/100
Achieved 5 Nov 2026
Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.
What is DataSimHQ?
A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more