This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4822 IT projects that we have successfully completed with our customers.How can we support you?
Transition of existing BI Solutions into a new architecture
Project duration: 1 year, 6 months
Brief description
Transition of several local CRM Sales and Service Data Marts as extension of a global BI (business intelligence) solution of the customer. Therefore country specific data and structures from various source systems (SalesForce.com, SAP BW, locale sources…) which are not available in the global solution are provided for reporting. This is done within a relational ETL process.
Supplement
Here, country-specific data and structures from various source systems (SalesForce.com, SAP BW, local data sources…) are created in separate data marts that are not available in the global solution. This is done in a relational ETL process. Our task is the requirements analysis, architecture and implementation.
Subject description
Several country-specific CRM data marts for sales and service are made available for reporting in line with the customer's global BI solution. Here, country-specific data and structures that are not available in the global solution are made available for reporting.
IT project data
- Industries pharmaceutical industry
- Specialist tasks data warehouse, ETL, Reporting, sales and distribution, servicing
- DP tasks Data Warehouse
- System environments Business Intelligence
- Procedure model customer standard
- Programming languages T-SQL (Microsoft)
- Databases MS SQL Server
- Standard software and BI Tableau Desktop
Project period08.01.2018 - 28.06.2019
Customers who trust us
