Roche Diabetes Care, a global leader for diabetes management systems and services, is changing to a centralized IT environment. This includes a global Business Intelligence solution which harmonizes information, replaces local systems and thus reduces ambiguities and costs.
Initial attempts failed in delivering the new BI solution according to the complex requirements of business, regulatory and data security in a developing IT environment. The project was turned to success by partnering with the Data Analytics team from Accenture/Avanade.
The crucial criteria for the fast turnaround included senior business support for the redefinition of the governance and to ensure the availability of business process experts, keeping the balance between a high-quality technical solution and intensive change management, offering enterprise reports and self-service capabilities on an industry standard software, ensuring adherence to the development processes and the project methodology and – most importantly – attracting excellent resources.
The Enterprise Data Warehouse was built from scratch in less than six month, serving six Business Domains in six time zones. The first business domains have been released after only ten weeks into the project execution. Through the reduction of dependencies and the consequent use of standardized Data Vault patterns, ETL/ELT automation, as well as automated testing and documentation, it became possible to deliver in such a short time.
The run organization is set up following a mature operating model which takes self-service and central reporting into account. The enablement of Self-Service BI requires a mature Competence Center and role-tailored trainings for its staff as well as the end-users. Processes were established for the development, the run and the support organizations.
Target Audience: BI-Manager, BI-Projektleiter, Entscheider, CIO, Solution Architects
Prerequisites: basic understanding of BI and Data Warehousing Projects