Analyst
Analyst
Project
FlowRoute Logistics Co. · Excel · Beginner
The brief
From: Funmi Alade, Head of Customer Experience
The data team exported our full complaints record for you - every complaint on file, with the destination hub already joined on. I need the same headline analysis I asked the database side for, built in Excel so my team can keep it updated.
In the attached workbook (Complaints sheet), build a summary on a new sheet: 1. The total number of complaints, as a single labelled figure. 2. A breakdown by category: complaint count and percentage of total per category, sorted from most to least common. Live formulas or a PivotTable - not typed-in numbers. 3. A one-line cell stating which category I should lead with at the board.
Deliverable: the workbook with your summary sheet, plus a screenshot of it.
Independent grading
95/100
Achieved 2 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