From Excel to Integrated Financial Planning at RheinEnergie
RheinEnergie AG, one of the leading energy providers in the German state of North Rhine-Westphalia, set out to digitise its financial planning as part of a comprehensive transformation project. The company-wide migration from an older SAP system to SAP S/4HANA presented an opportunity to fundamentally rethink planning. Previously, financial planning was primarily carried out using decentralised Excel files, which led to poor data quality, time-consuming manual processes, and a lack of transparency. RheinEnergie recognised the need for an integrated EPM solution to enable efficient and high-quality centralised planning.
The aim of the project was to implement a centralised planning platform based on Jedox for cost centre, cost type, and profit centre planning. In the medium term, the application is also intended to support balance sheet and cash flow planning, as well as further modules. Particular focus was placed on improving the quality of
planning data and automating interfaces to the SAP system.
The project was embedded within the SAP migration and therefore had to contend with ongoing structural changes and system adjustments. In parallel, data structures and source systems – particularly SAP S/4HANA, SAP BW, and Tableau – were redefined, adapted, and integrated.
Find out all about the highlights:
Quality Improvement: Data quality and planning depth have significantly improved
Increased Efficiency: Uploads to the SAP system are now automated with a single click rather than manual
Validation & Transparency: Centralised reports and workflows enable structured review and approval of plans
Successful cooperation as a key factor for project success
bdg and alstria have developed a tool for property valuation using the discounted cash flow (DCF) method to enable alstria to valuate its property portfolios more efficiently, quickly and cost-effectively – the volumes of data were simply no longer manageable in Excel and the processes were extremely time-consuming.
The classic Excel-based planning process for merchandise planning reached its limits with the constant growth of Zalando, Europe’s largest online platform for fashion. Too time-consuming, error-prone and not very homogeneous: Merchandise planning was no longer in line with the dynamic business environment and was in danger of completely losing sight of important key factors in an overly sluggish planning process.
Zalando relied on bdg to implement a complex solution in Jedox for merchandise planning.
The result: the planning time and effort were radically reduced and the quality of the planning was significantly increased.
Our client, a globally recognised luxury watch retailer, sought a more efficient, digital approach to their watch planning and allocation processes. Previously relying heavily on Excel, they were managing massive spreadsheets with painstaking manual updates. This was time-consuming, prone to error, and made it difficult to get a clear view of stock and sales.
