Customer Stories
Global pharma enterprise
- Various SAP ECC systems consolidated into BW/4HANA
- Other primary systems and DWHs based on Oracle, Teradata and MS SQL
- ~20 TB of new data monthly
Goals
- Full PowerBI/Tableau enablement (not performant with SAP BW)
- Ability to analyze SAP and non-SAP data together
- Reengineer the most used SAP BW modules into Databricks to disable them in BW and cut costs on HANA
- Introduce near real-time operational reporting using PowerBI/Tableau
- Advanced Analytics enablement (predictive analytics and other ML-based use-cases)
Tools used
SAP Data Intelligence
Azure Databricks
PowerBI/Tableau
Global beverage producer
- Various SAP ECC and S/4 systems consolidated into BW on HANA
- ~1 TB of new data every month
- 2000 Distinct Data Marts
- Individual configurable fault-tolerant ingestion pipelines
- Highly-scalable multi-node integration runtime setup
Goals
- Granular reporting enablement in Tableau (solving performance issues with BW)
- Enrich SAP data with weather data, sellout data, promo data, …
- to enable advanced analytics use cases like Demand Forecasting, Revenue Optimisation or Promo analytics
- Validate the “Complete BW migration to datalake” feasibility
Tools used
Azure DataFactory (data ingest)
AWS Databricks
Tableau