Case Study: Major Construction Company modernizes BI and cuts data processing costs with Persistent Systems and Snowflake

Major Construction Company - Customer Case Study

Persistent Systems worked with a major construction company that needed to modernize a BI stack built around Excel-based outputs for each subsidiary. The client wanted to consolidate business data and reports into a cloud-based data store while improving security for financial and marketing data, both at rest and in transit.

Persistent Systems designed and developed a Snowflake-based data warehouse and visualization solution, with Python used to parse Excel files from an on-premises server and ingest them into Snowflake, plus integration with Box for cloud file storage. The result automated data integration for 10+ subsidiaries, enabled 10+ Power BI reports, and delivered a 20% savings in data processing costs with a modern, scalable warehousing solution.