Following a Scorecarding and Performance Management roadmap, HDP & Arista decided to extend a Customer oriented data mart with the financial data from an ASW/FIN accounting system. The technologies involved were end to end Microsoft Business Intelligence SQL Server 2008 including SSIS, SSRS and SSAS.
Business Analytics Strategy
Renson selected element61 as their preferred partner for helping them shape the future of the Business Intelligence and Performance Management solutions.
element61 has been involved in the Tessenderlo Group BI program since 2007. After the definition of a Business Intelligence Roadmap, a new SAP Business Warehouse 7 deployment was executed. The current SAP Business Warehouse includes data from multiple SAP source systems and covers functional areas such as Profitability Analysis, Sales and Distribution, Profit & Cost Center Accounting, HR, Overhead Cost Controlling, Actual Costing & Material Ledger, Spend Analysis and CRM. As one of the first sites in Belgium, SAP Business Objects Xi was rolled out on top of SAP BW in 2008. element61 has also assisted Tessenderlo Group in all aspects of setting up a BI Competence Center (processes, people, methodology ...).
Woonhaven Antwerpen has recently conducted a comprehensive organisation study which has resulted in a number of KPIs that will need to be measured. In order to cope with this requirement, they asked element61 to help them build out a BI vision and architecture.
The ICT department at HighCo Data asked element61 to assist in the definition and design of their new BI landscape, including software selection and recommendations. element61 delivered these expected results in a Business Analytics Roadmap project.
The Corporate USG People Data Warehouse is based on multitude data sources (back- and front-office). The decision support system is used by virtually all management levels in the organization in order to get a complementary overview of the performance of the USG Group. USG country management can retrieve financial and operational details on their country performance. At VP-level, consolidated financial and operational data is available. A crucial part of the project was also working out an implementation blueprint that considerable facilitates and speeds up the integration of additional local USG People offices in the application.
element61 provided some senior BI resources to assist the Telenet BICC (BI Competence Center) in their activities. The role(s) of element61 consisted in Business Analysis and BI project & team management.
Echo relied on element61 to play a key role in the definition and execution of their Performance Management strategy. element61's activities started with jointly defining a Performance Management roadmap, that formed the basis for the implementation of both a BI and CPM solution. In the implementation process, element61 was responsible for the analysis of the requirements, the solution design, and the implementation using a best-of-breed technology mix of MS SQL Server 2008, IBM Cognos BI 8 and IBM Cognos Planning 8. This project was executed in very close collaboration with the Echo team and has received substantial industry recognition with the BI Vision Award and the Best Finance Team Award.
Through the years, Jetair has been building a large data warehouse containing all their operational data to focus on the operational performance of the company. The next step was integrating all the financial data and building a companywide Planning solution to come to a complete closed-loop Performance Management environment. Hence a Planning, Budgeting & Forecasting-project was started.
The aim of the project was to automate the Profit & Loss-statement, integrating all accounts and cost- and profit centers to allow for both bottom-up and top-down planning. As part of the project, this application has been extended with driver-based data being fed to the application for some specific areas. Main focus of the project was on to the operational business of selling vacation over land (TO Overland) and by plane (TO Flight). The overhead cost centers have been integrated by basic enduser-input to come to a full P&L.