Analyst
Senior Analyst
Project
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