Verified by DataSimHQ

Analyst

Bashirat Oyekunle

Senior Analyst

Project

Build the Inventory Health Dashboard

Meridian Retail Co. · Power BI · intermediate

The brief

Chidi needs to see the inventory crisis at a glance before his regional manager calls.

Build an inventory health dashboard with these visuals:

- A KPI card showing total count of products in negative stock (stock_qty < 0) - A KPI card showing total backorder exposure in naira - A bar chart ranking stores by total backorder exposure value — stores with the worst backorder situation appear first - A table showing the top 10 most critical stockout products with columns: Store Name, Region, Product Name, Category, Stock Qty, Backorder Exposure (₦) — sorted by most negative stock first - A donut or bar chart showing count of negative stock products by category — this shows which product categories are most affected

Independent grading

92/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