Global Audit Company Accelerates Decision-Making with 90x Faster Reporting

Goal: Create a single DWH to consolidate scattered data and accelerate its processing.

Solution: A 3 TB Data Warehouse based on SAP HANA integrated with client’s internal BI solutions as well as Data Science and financial systems. Implementation of Data Lake based on Microsoft Azure and Databricks.   

Benefits: 90x quicker reporting for faster decision-making and ease of access to data for more than 100,000 company employees. Ensured generation of analytical reporting in only 10 minutes instead of 15 hours along with real-time ad-hoc reporting. IT operations automation. Reduced data management and maintenance costs. Improved data quality.

Services delivered: Data Warehouse design & development, Data Lake & Big Data implementation, Master Data Management, SAP BI/BW Integration, Predictive BI & Data Analytics, Business and Customer Insights.

As a long-time vendor of SAP solutions with in-depth expertise in all SAP products, Infopulse implemented a single 3 TB Data Warehouse based on SAP HANA seamlessly integrated with the existing BI, Data Science, and internal financial systems. We built an API for these external systems that can source aggregated data from a centralized DWH. On top of that, we also implemented Data Lake for Data Scientists based on Microsoft Azure and Databricks, which greatly simplifies data extraction and processing.

All data, gathered from multiple enterprise systems including SAP S/4HANA, SAP BPC, CRM, various planning and other business systems, is fine-tuned, cleansed and prepared according to a specific query, thus providing users with the customized results.

• The solution enabled near real-time data availability and simplified accessibility for over 100,000 employees on a daily basis.
• Owing to high-speed data processing in a centralized in-memory DWH, our team managed to implement real-time ad-hoc reporting.
• We optimized time for building static reports as well as decreased time for generating analytical reports from 15 hours to 10 minutes.
• We provided data marts and filters for simplified data viewing and quick requests processing which brings business end users actionable insights for faster decision-making.
• By implementing a cloud version of DWH, we removed the need for Data Scientists to dump data to laptops, therefore optimizing their workflow for the creation, deployment and running predictive models.
• Our client reduced data management and maintenance costs, automated a range of manual IT operations, ensured better data consistency and overall data quality.