A well-known consumer packaged goods (CPG) company specializing in pet food contacted Imaginet because the data for their health and safety reporting was slow and failing to load properly. They were working with an online platform called Evotix and pulling data from a web URL to build reports. Additionally, they have numerous factories and therefore have high volumes of data to capture. Each of the factories was attempting to take the data from the Evotix platform to build reports but the web URL couldn’t handle many factories requesting large datasets concurrently and was consequently unreliable. They were in need of a centralized data repository, so all their data could be accessible from one location.

What Imaginet Did – Centralized Data Reporting: 

Using Azure Data Factory, our Data Analytics team built a pipeline that copied the data from the web URL to an on-premises SQL Server database. Using a Visual Studio Database Project, we defined the tables, views, and stored procedures for the on-premises SQL database to store and process the Evotix raw data.  We made their data available in their own organizational database, eliminating the need for each factory to access the data through the web URL, making it easier to access. Now, the client has a place to access not only the health and safety data but all data in general.  

Why Centralized Data Reporting was Helpful: 

The waiting time for data will decrease across all factories, and users can query data more quickly for their reports, allowing them to increase efficiency in data reporting. Because the data is centralized in one location it is more easily accessible, scalable, and much more reliable than previous data. Additionally, each factory can correlate the Evotix data with their other factory data. The reliability and speed with which their data is delivered is much improved from their previous data reporting system.  

We also introduced our client to new standardized patterns for building these types of reports they hadn’t utilized previously, including the use of source code repositories and Visual Studio Database projects to manage the database schemas. We implemented Continuous Integration/Continuous Deployment (CI/CD) with Azure DevOps pipelines to deploy the solution to multiple environments to support development, testing, and production.  

Our team has been working hard these last few months, and we are excited to share our success with you. Don’t forget to subscribe to our newsletter to stay updated on our most recent Microsoft 365 projects. Fill out the form at the bottom of the page if your data is unreliable, you desire a centralized data repository, or your data is difficult to manage.