DW - Data Warehousing & Modeling
Mensura have based their BI architecture on the MS BI platform, including the available 3rd party extensions and improvements Targit and TimeXtender. TimeXtender is used as a data warehouse automation tool to speed up the ETL development process, whereas Targit is implemented as a user-friendly front-end – an alternative to MS Excel - on top of MS Analysis Server cubes. Mensura have selected element61 as the partner of choice for support them in all of these technologies.
SAP BW 7.3 & BO 4 implementation.
After the budgeting and the consolidation project at bpost, SAP BPC data needed to flow back to the corporate data warehouse so that it could be analysed against the actual data by a large user community. The technology used was Microsoft stored procedure scripting to retrieve the data from the cubes and send it to the Microsoft data warehouse. Via BusinessObjects Webi, the users can now analyse data in a more efficient manner.
Weber Stephen wanted to rebuild its BI environment due to the change in the European organisation structure that was planned to take place in 2014 and 2015. element61 was selected to execute this project in close collaboration with the Weber Stephen team. The project delivered a new data warehouse platform which consolidated data ensuring the "one version of the truth", streamlined reporting processes throughout Europe and more visibility on the process of loading data. The delivered data platform ran at a lower TCO and enabled future projects such as improved budgeting and forecasting.
element61 has been involved -following a BA roadmap- in assisting iMinds with building a data warehouse (based on timeXtender/SQL Server 2012) -and delivering associated Performance Dashboards- that brings together the different business domains including CRM, Finance, Project Monitoring, Human Resources and Publications.
The BI program at Isabel consist of a number of main project iterations. The first two increments concerned mainly the actual platform usage & the expected product usage by customers, next to delivering a detailed insight on the customers of Isabel in terms of various segmentations based on a complexity of business rules within a challenging context. For obvious reasons the BI program and corresponding roadmap is reviewed and thereby re-defined on a frequent basis. Other important information domains and projects delivered are: product integration, a corporate objectives dashboard, an integrated churn & value based model, service calls, various Zoomit related domains and several divisional dashboards. At the same time a BICC was defined and set up.
Given the nature of its business, MSF Supply is an organization that has to deal with a lot of data. In order to optimize some of its business processes and to better serve the operational units that work in the field, MSF Supply is looking to improve its reporting and analysis capability.
In order to achieve this, MSF Supply has defined a comprehensive and enterprise-wide BI initiative that includes the construction of a data warehouse, next to setting up a best-practice reporting and analysis environment. The technology selected consisted of the MS SQL Server 2012 suite, including SSIS, SSAS, SSRS and MS Master Data Services.
Continuga asked element61 to build out a BI environment. Based on the requirements, the decision was made to implement this BI architecture in a SaaS model.