Case Study: a US municipal government agency builds a data warehouse for transportation accident analytics with ScienceSoft

US municipal government agency builds ETL pipelines from 5 sources in 30 days with ScienceSoft

The customer, a US municipal government agency, faced the challenge of building a data warehouse to facilitate analytics on transportation accidents. They needed a vendor to implement ETL pipelines within a very tight one-month deadline. They selected ScienceSoft for its data warehousing experience to develop these pipelines using Microsoft SQL Server.

ScienceSoft designed and implemented ETL pipelines to move historical data from five different governmental sources into the new data warehouse. This included building a specialized mechanism to handle continuously updated JSON files and consolidating data from an old Microsoft Access database. The result was an easy-to-configure, automated data integration system delivered on time, which established a robust data warehouse ready for the agency's future analytics and reporting solution.