Verified by DataSimHQ

Analyst

Samuel Adeniyi

Analyst

Project

Power Query: Clean the Order Items Table

Meridian Retail Co. · Power BI · beginner

The brief

Same issue in order_items — all the price columns are in kobo. Can you convert them to naira in Power Query? We need Unit Price (₦), Discount (₦), and Line Total (₦). These will be the columns we use for all revenue and margin calculations going forward.

Independent grading

95/100

Achieved 28 Oct 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