Analyst
Analyst
Project
Meridian Retail Co. · Excel · beginner
The brief
Chidi wants a channel performance table for the investor deck showing which acquisition channels bring the most valuable customers. He wants to see count, average orders per customer, and average lifetime value per channel.
In Meridian_Data.xlsx, build a summary table in a new sheet called Channel Performance using COUNTIFS, AVERAGEIFS, and SUMIFS formulas. Rows = each acquisition channel. Columns = Customer Count, Avg Total Orders, Avg Lifetime Value (₦). Sort channels by Customer Count descending. Format numbers appropriately.
Independent grading
95/100
Achieved 10 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