Top Stocked Items

A Power BI page that surfaces inventory concentration (by quantity and value), helping teams identify where cash is tied up and which SKUs dominate on-hand stock.

Power BIInventoryProcurement AnalyticsWorking CapitalReporting

Summary

Problem
Inventory conversations were slow because the team didn’t have a fast way to see which items dominated on-hand quantity and which items tied up the most dollars.
Solution
Built a focused page that ranks “top stocked” by quantity and by value, paired with quick context like vendor, last purchase date, and purchase activity over time.
Result
Faster inventory reviews and better prioritization: teams can quickly spot over-concentration, expensive stock, and where to investigate purchasing behavior.

Business impact

Cash visibility
Makes it obvious which SKUs are tying up working capital by ranking inventory value and showing the top concentration at a glance.
Faster investigation
Adds actionable context (vendor, last purchase date, PO count) so buyers can investigate why an item is so heavily stocked without jumping between systems.
Cleaner decisions
Helps leadership focus on the few SKUs that drive the majority of on-hand inventory—supporting smarter max settings, buying pauses, or redistribution decisions when needed.

Gallery

Screenshots and artifacts from the build (sanitized where needed).

1) Define the ranking logic

I separated “top stocked by quantity” from “top stocked by value” so users can distinguish between bulky items and expensive items. Both views are important, but they answer different decisions.

2) Add fast context

The table includes the most useful investigation fields (vendor, last purchase date, PO count) so the page is immediately actionable.

3) Prevent misread metrics

I included definitions for core terms (on-hand snapshot, inventory value, sales windows) so users interpret rankings correctly and don’t confuse stock concentration with sales velocity.

DAX Library

Search and review the actual measure logic used in this page (sanitized where needed).

/
Showing 4 of 7 measures