Analyst
Senior Analyst
Project
Meridian Retail Co. · Power BI · intermediate
The brief
Nura and Ngozi need a margin analysis dashboard they can use in their campaign strategy discussion.
Build a two-page report:
Page 1 — Margin Overview: - Three KPI cards: Revenue (₦), Gross Margin %, and Discount Impact (₦) - A bar chart showing Gross Margin % by category with a reference line at 50% - A bar chart showing Discount Impact (₦) by category - A date slicer defaulting to October to December 2023
Page 2 — Product Detail (drill-through): - A table showing the top 10 products by Discount Impact (₦) - Reachable by right-clicking any category bar on Page 1 and selecting drill through
Independent grading
91/100
Achieved 1 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