This is one of 4620 IT projects that we have successfully completed with our customers.How can we support you?
Further development of a local data mart
Brief description
Further development of a local CRM data mart for sales and service in addition to a global BI solution. Here, country-specific data and structures from various source systems (SalesForce.com, SAP BW, local data sources…) are made available for reporting not provided by the global solution. This happens in a relational ETL process.
Supplement
Data from various source systems such as SalesForce.com, SAP BW, global data marts and also locally maintained data sources are loaded into a local data mart. The transfer of the data is configured with a customer-specific tool. This data is then prepared in SQL procedures and made available to the user in views. Versioning is performed using Microsoft Azure DevOps. Tasks are performing locally requested customizations and enhancements (e.g., creating new procedures) as well as creating and customizing interfaces. Documentation and handover of developments to support is also included.
Subject description
The Data Mart represents a local solution for sales and service. The solution enables reporting, which can be performed by the user via Tableau.
Overview
- Industries pharmaceutical industry
- Specialist tasks business intelligence, data warehouse
- DV tasks Data Warehouse
- System environment Business Intelligence
- Procedure model customer standard
- Databases MS SQL Server
- Development/ test tools Azure DevOps, MS Team Foundation Server TFS, MS Visual Studio,
- Standard software ServiceNow
Project start01.01.2020
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
