Analyst
Junior Analyst
Project
Meridian Retail Co. · Power BI · beginner
The brief
Before we build Chidi's customer dashboard, the customers table needs some cleaning. There are known duplicate records in there that will inflate the numbers. Can you filter them out in Power Query and while you're at it, add a Full Name column, an Acquisition Year column, and a Customer Tier column? Tier logic: New = 0-1 orders, Regular = 2-9 orders, Loyal = 10+ orders.
Independent grading
92/100
Achieved 4 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