This is one of 4124 IT projects that we have successfully completed with our customers.How can we support you?
Creation of global CRM sales and service data marts
Project duration: 4 years, 1 month
Brief description
Creation of global CRM data marts for sales and service. Sales figures and sales activities are consolidated together with sales and turnover information from various source systems in a group-wide data mart. This data is then prepared for evaluations and research by means of relational reports and OLAP (online analytical processing).
Supplement
Data from various source systems (SalesForce.com, SAP BW, local data sources etc.) are loaded to a shared data platform. From there, they are distributed to subject-specific data marts. In this project, structures are formatted for sales and service and they are made available as dimensions and facts, together with information collected specially for specific issues, in an ETL process for relational reporting. Data is formatted for aggregations and analysis in OLAP cubes at a low level of detail.
Overview
- Industries pharmaceutical industry
- Specialist tasks Customer Relationship Management (CRM), sales analysis, sales and distribution, turnover analysis
- DV tasks Data Warehouse
- System environment Business Intelligence
- Procedure model Scrum
- Databases MS SQL Server
- Development/ test tools MS Team Foundation Server TFS, MS Visual Studio,
- Standard software Tableau Desktop
Project period19.11.2013 - 31.12.2017
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
