Omega Pharma Belgium wanted to initiate a Power BI reporting pilot to have their SAP data available via PowerBI. Initial scope/phase was focusing on 3 domains
- Sell-in and sell-out data
- Brand reporting (Gap analysis, Profitability,P&L, Phasing..)
- Key Account Customer
The solution is coping with Time to Month ,Year-to-Date, Quarter to Date, Moving Anual Total, Year-To-Go analysis and comparison with Prior periods and contains dynamic reporting via on the fly KPI calculations based on different measures.