Verified by DataSimHQ

Analyst

Bashirat Oyekunle

Senior Analyst

Project

Build a Margin Analysis Dashboard

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