Business Challenges

• Finance department were spending excessive time in preparation and validation of management reports
• Site and product master data hierarchies did not meet the reporting needs of the business
• SAP BW used outside of finance department; opportunity for cliennt to convert onto similar system
• There was no agreed source of sales data

Solutions

• Reviewed the current management reporting, budgeting and forecasting and consolidation processes
• Developed a number of solution options (IT, process and organization)
• Prepared a business case detailing costs and benefits associated with the options above
• Prepared a route map identifying key dependencies and milestones
• Recommended the migration of finance data onto one Data Warehouse to enable a “single version of the truth” rather than use a finance-specific data-mart

Benefits

• Our recommended solutions resolved the challenges that client faced, namely
• Elimination of data inconsistency
• Improved impact and use of reports and data content
• Reduction in the number of manual reconciliations
• Provision of a single source of data and minimised use of spreadsheets