Project Summaries

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

Data Migration to SharePoint Online Improves Data Manageability

by

A government financial services organization had a significant amount of data on Windows File Share and wanted to move it to SharePoint Online. While transferring the data would be a simple data migration, they also wanted to make changes to some of their internal file structure.   Migrating from Windows to SharePoint would allow them to have improved document management, as well as to take advantage of the numerous benefits of SharePoint. Before contacting Imaginet, they lacked document tracking or versioning, and permissions were difficult to manage. They also don’t own the servers – other people control them, so there was a communication gap between our client and the team managing … Read more

Application Update Leads to Improved Performance and Functionality

by

A provider of real estate advisory services contacted Imaginet to assist them with an application we had previously developed for them. Most of the application was developed using .Net framework 4.8, which is now outdated. The application’s front end was developed with version 8, but now Angular 16 is the most updated and recent version. An application update would improve the overall use, performance, security, and functionality of the application itself.   Our Solution  The application required an update so it would use .Net core and Angular 16 as the frontend. The client also requested other fixes that would improve the performance, such as moving some data processing from the Angular … Read more

Power BI Reports & DevOps Component Improves Data Quality

by

A major Canadian University had been experiencing issues with discrepancies in their data reports. They had an existing data warehouse across the entire organization, but the data quality was poor and inaccurate. Therefore, they were in need of a solution that could provide overall improved data quality. The client had expressed their desire to keep the data warehouse currently in place. We determined that data collected and presented in Power BI reports would satisfy the client’s data needs.   What We Did: Power BI  We started by doing work in Power BI that allowed the reports to match up with their evaluation criteria, which involved working heavily in SQL. We then … Read more

Centralized Data Reporting Reduces Wait Times and Improves Reliability

by

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 … Read more

Power BI Reporting Improves Data Quality and Accuracy

by

An Information Technology organization specializing in business solutions contacted Imaginet to create a more effective approach to their data reporting. They had been using Excel for reporting purposes and relied on manual manipulation of their data. Using Excel was neither effective nor efficient, and the manual work was leading to data quality issues. We determined the best solution for our client would be through Power BI reporting.   What We Did:  We recreated some of their existing reports in Power BI and created reports using data from Salesforce based on the following 2 requirements:  We changed their data reporting system report by report. To begin, we created the semantic model in … Read more

Power Automate Solution Automates Processes and Reduces Errors

by

A North American capital management organization contacted Imaginet to create separate libraries for each of their fund types – direct and indirect. They did not have a solution in place to separate data and were relying on manual work. This led to errors, lost information, and wasted employee resources. We determined a Power Automate solution could solve the issues our client was experiencing.   We used Power Automate to create folder structures in document libraries that were based on data from a list provided by the client. When a new fund was created by someone in the organization a flow would automatically allocate it to the correct library (direct or indirect). … Read more

Updated Data Reporting Leads to Data Accuracy and Consistency

by

A secondary school specializing in massage therapy contacted Imaginet because they wanted to make better use of an existing SharePoint site. All school files were either contained on a shared drive or personal drives, and the departments using SharePoint had been set up as communication sites as opposed to team sites. Distinguishing between and choosing a Communication Site or Team Site is important. To help decide which you should use, read our Communication vs. Team Site blog.   They required an updated data reporting solution that would better suit their needs. The solution needed to provide more efficient data access, while simultaneously utilizing the existing SharePoint site.   The Problem:  They had … Read more