Data Model

The COSMO Analytics Purchasing semantic model follows Power BI best-practice standards using a Star schema design. The model enables analysis of purchase orders, receipts, and invoices including spend, quantities, discounts, and vendor coverage with full time-intelligence support.

Model Purpose

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

• Analyzing order, receipt, and invoice amounts and quantities
• Tracking discounts, cost amounts, and gross weight
• Assessing supplier coverage and item portfolio activity
• Comparing trends with PY/YoY time-intelligence variants

Model Structure

The model integrates purchasing transactions in a consolidated fact table with rich dimensions (calendar, vendor, item, locations, payment and shipment settings, document types, and more) to enable analysis across time, products, suppliers, and logistics.

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

• Facts – Transactional data for purchasing
• Dimensions – Master data with attributes for analysis
• KPIs – Key Performance Indicators and measures