Sortimo is the European market leader for vehicle equipment and intelligent mobility solutions. The company wanted to work more data-driven to manage sales more efficiently and better predict customer wishes. The initial situation: distributed data silos, manual reports, lack of AI foundations.
Challenge
Sortimo faced the challenge of systematically consolidating central data from SAP, Contentserv SIM, and the vehicle configurator. Existing reports were manually created, data was siloed, and the foundation for machine learning was lacking.
The Solution
Together with DIVINT, a scalable data platform was built on Microsoft Fabric – including automated data flows, AI-capable architecture, and Power BI dashboards. The following components were integrated:
Data Connection: SAP HANA, Contentserv SIM, SAP C4C, Configurator
Ingestion: Dataflows Gen2, Azure Data Factory, Notebooks
Storage: Delta Lake, ~40 million rows
Security: RLS, ABAC, automated IaC rollout
Cost Optimization: Auto-Pause (>70 % savings)
The Most Important Use Cases
Sales Dashboard
Self-service sales dashboard with filtering options down to customer & postal code level.
→ Real-time insights for sales and management.
Vehicle Insight
Analysis of vehicle data by model, brand, sales value, and customer sector.
→ Data-driven product strategy and trend analysis.
OEM Reporting
Automated monthly reporting for OEMs and stakeholders.
→ Results delivered in seconds instead of days.
Machine Learning Vehicle Prediction
Fabric ML model to predict vehicle configurations based on historical orders.
→ 77% prediction accuracy across 361 model classes.
→ Uses existing product data for AI-based configuration classification.
Results and Business Impact
KPI | Before | With Fabric |
|---|---|---|
OEM Reporting | 3 days | Few seconds |
Forecast Accuracy | Gut feeling | Accuracy 90% |
AI Usage | Not available | ML models and predictions |
Dashboard Adoption | <30% | <75% |
Focus on Machine Learning and AI Predictions
Development of ML models (e.g., with compatibility data)
Development of new AI-driven forecasts (e.g., market & customer behavior)
Use of “Chat with your own data” & Notebook Copilot for analysis & exploration
Platform Governance and Efficiency
Implementation of Data Ownership, Quality Rules, and IaC Standards
Outlook
Sortimo uses Microsoft Fabric today as a central data platform for sales and vehicle-related insights, automated OEM reporting, and the targeted use of machine learning. The foundation for a scalable AI strategy has been created.
