Data Model

The COSMO Analytics Demand Planning semantic model follows Power BI best-practice standards using a Star schema design. The model enables comprehensive analysis of demand and supply planning, inventory availability, and replenishment optimization.

Model Purpose

This semantic model provides the foundation for data-driven demand planning by:

• Analyzing expected availability balance based on demand and supply
• Identifying over- and undersupplied items for chosen periods
• Detecting potential drops below reorder and safety stock levels
• Validating replenishment parameters at Stockkeeping Unit (SKU) level
• Uncovering inaccurate inventory valuations due to production orders with consumption but no output

Model Structure

The model integrates fact data from inventory transactions, planning demands, and planning supplies with comprehensive dimension tables to enable detailed analysis across multiple perspectives including time, location, item, customer, vendor, and more.

In the following sections, you find a comprehensive documentation of available data and driven KPIs:

• Facts - Transaction data for inventory, demands, and supplies
• Dimensions - Master data with attributes for analysis
• KPIs - Key Performance Indicators and measures