Business Analytics Strategy

Implementation of a Performance Management architecture & setup of a BICC within an SAP BI Context


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 ...).

Management Dashboard for Performance Management in Staffing


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.

Implementation of an end-to end Performance Management solution


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.

Performance Management and Driver-based Planning in the Tourism sector


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.

Business Intelligence journey


As their business expands and grows beyond their traditional services of auction, through the addition of value-added services such as development of new fruit species, fruit storage, packaging etcetera, Veiling Haspengouw requirements for reliable and timely management information also grew.

They quickly discovered that their existing reporting solutions, mainly Excel-based, had significant shortcomings, and therefore they decided to look for a more stable and automated solution. This process was a joint initiative of the Finance Office and the IT department, who both saw the advantages a best practice Business Intelligence solution could bring them. After an initial and short Performance Management Roadmap project, Veiling Haspengouw decided to invest in a BI architecture based on Microsoft SQL Server. The first iteration of the Enterprise Data Warehouse has been built and delivered, mainly focusing on Sales Revenue reporting. This project was delivered in a short timeframe of 3 months and has resulted in a set of validated and reliable reports and dashboards that are being used by both the Finance and Commercial departments, enabling them to have a better view on their commercial performance. The next iterations of the BI program are currently in full preparation and will cover their Production process reporting and analysis.


S'abonner à RSS - Business Analytics Strategy