Power BI Reporting on SAP for Pharmaceutical

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.