Verified by DataSimHQ

Analyst

Project

Customer Acquisition Trend Chart

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