Business challenge
- Synovos Data Warehouse is created on top of SOS and SYNC source systems using SSIS.
- SSRS reports receive the data through Synovos Data Warehouse and ODS.
- Synovos faced data mismatch issues in their existing reports, due to improper aggregation logics.
- ETL process maintained have overloaded the Disk space and RAM memory, due to unwanted lookups.
How Avasoft helped?
Continue Reading
- AVASOFT proposed a solution to implement incremental load to reduce the burden in ETL process.
- We modified stored procedure in the data warehouse to improve performance on ETL and resolve the disk space issues.
- We worked collaboratively with the team and transformed the business into SSRS Reports.
- We implemented the best practices to resolve the mismatch in reports.
Technology stack
This is a list of technologies we used
Value additions to customer
- Provided solution to manage multiple data source on a single data source by involving Data Warehouse concept.
- We designed Data Warehouse with unique modeling, which reduced the burden for business from collecting data in excel through multiple data sources for reporting.