Data Engineering and Busines Intelligence

Modern DevOps Practices Lead to Better App Functionality 

by

A leading Canadian retail logistics provider contacted Imaginet for a variety of application support. Broadly speaking, they needed assistance in managing several applications that had been written in the old .Net framework. These applications were poorly documented and lacked standardized build processes. Modernizing the applications was necessary as was breaking the larger applications down into smaller ones. This would make them more testable and would allow the client the track any in-application issues. In short, our client needed to adopt modern DevOps practices.    What We Did   The client had one massive application that, among other functions, primarily managed the inventory orders coming out and shipments to customers. There were roughly … Read more

Custom Application Streamlines Production and Reduces Costs

by

A well-known consumer packaged goods (CPG) company specializing in pet food contacted Imaginet to complete and polish a custom application started by a few interns. The application was not as far along as they initially thought, and they needed support.   The App:  In summer 2023, the interns visited all the facilities to understand how they handle the production of their “meat mix” pet food. The facilities where the product is made are separate from the supplier locations. At this time, they were tracking products via a spreadsheet – a method prone to error. Per year, 10,000 tankers haul the meat mix product to and from the supplier locations, and this … Read more

Inventory Reporting Tool Optimizes Inventory and Delivery with Data Integration

by

A provider of bedding plants for vegetable and herb gardens contacted Imaginet because they were starting to use Go Spot Check and wanted to bring its data into their data warehouse. Go Spot Check is a third-party cloud application that, like many supplementary tools, offers reporting in-app but doesn’t have a reliable or repeatable export method for the raw data. These types of tools can be very useful to organizations but can cause challenges when attempting to retrieve and integrate the data they collect. In this case, our client was in need of an inventory reporting tool. They specifically mentioned their desire to use the Go Spot Check data in collaboration … Read more

Microsoft Fabric: OneLake Provides a Unified Data Lake  

by
Microsoft Fabric

Have you been hearing the buzz about Microsoft Fabric?   The Data Engineering and Business Intelligence team at Imaginet has been watching with interest the development of Fabric since it was announced in March 2023. As data professionals with deep expertise in the Microsoft stack of data analytics products, we’ve already been using many of the pieces of Fabric and we’re excited to see how they are evolving.  Microsoft Fabric brings together several data products into a more unified experience, including Azure Synapse for querying data sources, Azure Data Factory for performing ETL processes (Extract, Transform, Load), and Power BI for showing data in dashboard or paginated forms. These products have … Read more

Correlating Financial Data With Donor Data Enables New Insights and Analysis 

by

Improve policy management process with search and automation technology. Streamline data entry, quickly identify policy conflicts, and improve accuracy with simplified administrative processes. Get started today and experience the benefits of improved policy management.

Universal Source of Pricing Solution Provides Data Integrity and Standardization

by

A well-known consumer packaged goods (CPG) company specializing in pet food contacted Imaginet to construct a Universal Source of Pricing (USoP) solution to improve data integrity and audit quality. The existing system was complex and utilized Microsoft Excel workbooks to manage pricing forecasting for their numerous product lines. Unfortunately, without any standard data processes and with various managers modifying the data, errors were common and caused confusion within the organization.   Our team created a database with validated data from Excel workbooks. We then leveraged Power Apps and Power Automate to develop an application interface that mimicked the look and feel of an Excel workbook but allowed us to retain controls … Read more

Using Microsoft Power BI – Business Data Analytics for Better Reporting

by
Power BI Blog

Microsoft Power BI is a powerful business analytics tool that helps you make better decisions with data-driven insights. With Power BI, you can easily create interactive reports and dashboards to visualize your data and share it with your team. Get started today and unlock