Because they were moving toward a more data-driven way of managing operations, ARS decided to use a data warehouse instead of maintaining multiple data sources. Such a change would enable them to answer business questions quickly and accurately, because they would be using a single-source of truth for data analysis and modeling. During implementation, ARS encountered some common challenges and limitations with data integration, data transformation, and data extraction during implementation. They attributed the errors they observed to problems with an open source ETL product they had been using. Their ultimate goal was to enable data transfer between Snowflake and Excel without needing to write custom Python code. In addition, they would need to transform data in such a way that it could be loaded to the Enterprise Resource Planning (EPR) tool they use. In order to accomplish this goal they knew they would need to draw upon the expertise of a data consultant.
At ARS, analytics drive both the onboarding process for technicians and the prediction of traffic conditions, identifying areas for growth. Both of these functions are vital in providing high quality service to their customers. Data errors and integration-related challenges resulted in reports that did not meet their expectations for quality. The team at ARS saw an opportunity for their company to grow at a fast pace, but concerns about data integrity stood in the way. The internal team at ARS wanted to quickly resolve any issues with using the data warehouse by partnering with a professional in data warehouse technology.