0%
decrease in time to complete overnight loads
0
minutes to complete loads, reduced from 6-8 hours
0
disparate data sources connected
Challenge
Bloomington Public Schools (BPS) legacy architecture did not provide a robust environment to facilitate change, with data loads taking 6-8 hours and breaking down at least once a week.
Solution
Partnering with DataDrive, BPS deployed Matillion ETL to ingest data from all required sources and build data pipelines to integrate and transform within the Snowflake Data Cloud.
Results
-
Connected 8 disparate applications, including the student information system, to Snowflake Data Cloud in time for the start of the school year.
-
6-8 hours to complete overnight loads reduced to 30 minutes.
-
Reduction in breakdown of data loads from once a week minimum, to zero.
-1.png?width=350&height=80&name=download%20(1)-1.png)
"I can't speak highly enough of the DataDrive team. They have the expertise & commitment to service that made our complex project manageable. DataDrive was responsive to communication & with us every step of the way."