Project Summary

Centralized Data Reporting Reduces Wait Times and Improves Reliability

Centralized Data Reporting Reduces Wait Times and Improves Reliability

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.  

Technologies Used

Centralized Data

discover more

The Imaginet Difference: Boutique In Size with Big Results  

Janine JeansonApr 18, 20244 min read

The Imaginet Difference: Boutique In Size with Big Results  April 09, 2024 Since 1997, Imaginet has been a proud Microsoft Partner. We offer a variety of Microsoft-related consulting, implementation, and design services for the Microsoft tech stack. Some of these…

New Application Development Projects Enhance Resource Management 

Imaginet Resources CorpApr 11, 20243 min read

A telecommunications organization contacted Imaginet for assistance on 2 new application development projects. The first was a portfolio tracker, and the second was an office furniture ordering application.    Portfolio Tracker    The portfolio tracker we built for our client tracks and…

QR Code Phishing Attacks: Are You Protected?

Carlos TansecoApr 9, 20244 min read

QR Code Phishing Attacks: Are You Protected?  April 09, 2024 QR code phishing attacks or “Quishing” are on the rise, and it’s crucial to raise awareness about this evolving threat. Scanning these codes has become second nature to many of…

Let’s Build Something Amazing Together

From concept to handoff, we’d love to learn more about what you are working on.
Send us a message below or drop us a line at 1-800-989-6022.