Sales Modern Trade In-Store Availability & Inventory Analytics Dashboard
🛠 Tools Used
💡 Skills Demonstrated
📊 Project Description
This Power BI dashboard provides a comprehensive view of On-Shelf Availability (OSA), inventory health, stock movement, and product performance across modern trade retail stores. Designed for sales operations, trade marketing, supply chain, and category management teams, the solution consolidates store audit, inventory, and product availability data into a centralized reporting platform. The dashboard enables stakeholders to monitor store compliance, track inventory coverage, identify out-of-stock risks, analyze off-take performance, and improve product visibility across regions, channels, and retail accounts. By transforming operational retail data into actionable insights, the solution helps organizations optimize product distribution, reduce lost sales opportunities, and improve in-store execution.
🎯 Business Problems Addressed
Retail organizations often struggle with:
- Limited visibility into product availability across stores and regions
- Stock-outs resulting in missed sales opportunities
- Difficulty monitoring inventory coverage and replenishment efficiency
- Inconsistent store compliance with merchandising standards
- Limited insights into SKU-level performance and availability gaps
- Manual reporting processes across multiple retail channels
- Challenges identifying regions and stores with inventory risks
This dashboard centralizes critical retail execution metrics to support data-driven decision-making and improve on-shelf product availability.
❓ Key Business Questions Answered
Store Availability & Compliance
- What percentage of audited stores meet OSA compliance targets?
- Which regions and zones have the highest and lowest compliance rates?
- How many audited stores are compliant versus non-compliant?
- Which stores require immediate corrective action?
Inventory Performance
- How many weeks of inventory are available across stores?
- Which locations are experiencing low inventory coverage?
- Where are inventory levels excessively high?
- Which regions carry the largest inventory volumes?
Product Availability Analysis
- Which SKUs have the highest On-Shelf Availability?
- Which products frequently experience stock-outs?
- What are the top-performing SKUs based on availability and sales movement?
- Which New Product Developments (NPDs) require inventory improvements?
Sales & Offtake Analysis
- Which products generate the highest offtake volume?
- Which regions contribute the most sales movement?
- How does inventory availability impact product offtake?
- Which accounts and channels drive the strongest product performance?
📊 Dashboard Features
- ✅ On-Shelf Availability (OSA) monitoring
- ✅ OSA compliance scorecards and KPI tracking
- ✅ Audited Stores vs Total Stores analysis
- ✅ Inventory coverage tracking (Weeks Inventory)
- ✅ Inventory risk indicators and compliance thresholds
- ✅ Zone, Region, and Territory performance analysis
- ✅ Top 25 SKU availability tracking
- ✅ New Product Development (NPD) performance monitoring
- ✅ Offtake volume and value analysis
- ✅ Regional inventory distribution treemaps
- ✅ Conditional formatting for inventory and compliance health indicators
-
✅ Dynamic filtering by:
- Week Ending Date
- Month & Year
- Island
- Region
- Account
- Channel
- Zone Grouping
- Territory
- Store Hierarchy
- Store Code
- Store Name
📈 Key Metrics Tracked
- OSA Compliance %
- OSA Days %
- Audited Stores
- Total Stores
- Weeks Inventory
- Inventory Compliance %
- Offtake Pieces
- Offtake Peso Value
- SKU Availability %
- NPD Performance
- Regional Inventory Distribution
- Store-Level Compliance
Professional Experience
Dennis Toting
- 📈 10+ Years of Experience in Data Analytics, Reporting, and Business Intelligence
- ⚙️ 5+ Years of Experience in Data Engineering and ETL Development
- 📊 5+ Years of Experience in Business Intelligence, Dashboard Development, and Data Visualization