The client is a global provider of development, production, technical expertise and services to a wide range of metal, steel, and manufacturing industries.
The client is a global provider of development, production, technical expertise and services to a wide range of metal, steel, and manufacturing industries.
The client wanted to implement a cloud data warehouse solution to improve performance in accessing large datasets by means of SQL Server Reporting Services (SSRS) Reports on relevant industry sales. The performance of SSRS was very poor while generating the reports from SQL Server Analysis Service.
Our team’s primary focus was to load data into Snowflake’s staging tables from a CSV file, populate Snowflake’s data warehouse tables from the staging tables, and use Snowflake computing to generate the calculated/aggregated fields. The information would then be shown through the SSRS Report. This approach, we felt, would improve the overall performance of the reporting process.
Data-Core’s successful implementation of Snowflake’s cloud data warehouse improved the reporting performance of the SSRS Sales Reports by approximately ten times, saving the client time and money substantially. In addition, our team at DataCore Systems provided reports using Power BI, and the performance was a notch better than what was achieved with SSRS. This was a value-added service provided to the client.
© 2025 Data-Core Systems, All rights reserved
