30 likes | 159 Views
Controlling and Data Driven Management using Oracle BI. Oracle Data Warehouse Global Leaders Program. Controlling, budgeting and forecasting in the new Oracle BI environment.
E N D
Controlling and Data Driven Management using Oracle BI Oracle Data Warehouse Global Leaders Program
Controlling, budgeting and forecasting in the new Oracle BI environment Oracle BI ensures high degree of automization and precision in monthly forecasts and enables perfect interplay with planning tool Solyp and SAP. SAP Fi/Co Solyp FC units Oracle BI 2 • FC information entered into SAP by Fi/Co • SAP data is played back into Oracle BI and serves as basis for new FC cycle • Decentral FC units in sales departments add their assessment through Solyp interface • Especially new customer acquisition and change in pricing/discount policy • Oracle BI compiles automatic draft FC • Based on existing customer portfolio, contract terms, retention period/churn rates
Controlling, budgeting and forecasting in the new Oracle BI environment Data Warehouse forms the starting and end point of a unified strategic planning and budgeting process. Thus true bottom-up planning is facilitated. Solyp DWH Strategic Financial Strategic Financial • Market/competition Data • Customers • Listings • Traffic • Brand awareness • Surveys • Strategic projects • Actual KPIs • Customers • ARPU/Pricing • Listings • Upselling Products • Marketing expenses • Personnel costs • Other costs • Budgeted KPIs • Customers • ARPU/Pricing • Listings • Upselling Products • Marketing expenses • Personnel costs • Other costs • Strategic and qualitative planning • Long term development • Goals / Initiatives • SWOT Bottom-upplanning 3 Automated process Management/ shareholder approval SAP PWA Strategic Financial • Strategic Project Management • Initiatives • Strategic goals • Approved budget • Revenues • Costs • EBITDA • Cash Flow