This is one of 3224 IT projects that we have successfully completed with our customers.How can we support you?
Enhancement and improvement of a data warehouse and reporting tool
Project duration: 6 months
Brief description
The DWH (data warehouse) and reporting tool based on MS SQL Server for transaction data in a corporation's online shop is expanded to include new functions, the back end is brought up to date and performance is improved.
Supplement
The Scrum-driven project expands the DWH to include additional facts and dimensions. One focus is on improving performance for queries and the ETL process. To achieve this, the SQL servers are upgraded to the latest version and their newest technologies are used. In addition, a better load distribution is achieved.
Subject description
The use of incremental statistics on the partitioned fact tables, the migration of non-clustered column store indices to clustered column store indices, the use of the network load-balancing service for MOLAP and ROLAP queries against distinct fact tables, and the scale-out deployment of the SSRS significantly speed up user queries, improve the performance of the loading section, and strongly increase the maximum possible number of daily data records in the DWH.
Overview
- Industries trade
- Specialist tasks Administration, data warehouse, E-Commerce, in-memory-data base, Upgrade
- DV tasks database administration
- System environment Business Intelligence
- Procedure model Scrum
- Databases MS SQL Server
- Development/ test tools Jenkins
- Operating systems Windows Server 2008
- Standard software JIRA
Project period01.05.2015 - 30.10.2015
Have we sparked your interest?
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
