Project
Meridian Retail Co. · SQL · intermediate
The brief
Ngozi Nwosu here. I ran a 15% discount campaign on footwear last quarter and I need to understand the margin impact. The issue is our order data stores the actual charged price (unit_price_cents) but also has the original list price in the products table. Can you compare the two and show me gross margin by category using the actual charged prices? The footwear categories should tell a clear story.
Independent grading
92/100
Achieved 26 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