Verified by DataSimHQ

Analyst

Omiroro Ovikute

Junior Analyst

Project

Power Query: Clean the Customer Dimension

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