Project Summaries

Robust Data Warehouse & Training Improve Data Management & Processes

by

The fundraising division of a Canadian university was having issues building reports from their donor management system and needed assistance. Complex data structures from Raiser’s Edge made it difficult for them to build a foundation to move forward and adapt over time as the business changed and software updates took place. The client approached Imaginet to develop a new data warehouse and ETL solution to integrate better with Power BI and lay the groundwork for future updates. While the Raiser’s Edge on-premises database was the primary data source, we used cloud resources like Azure Data Factory to orchestrate the data movements from the donor management system into the new warehouse. … Read more

Cloud-Based System & Custom Reporting Delivers Comprehensive View of The Customer

by

A well-known consumer packaged goods (CPG) organization specializing in pet food approached Imaginet to implement a new cloud-based system for their consumer affairs office. Their existing on-premises environment had a local database, server, and data model that had been in place for over 15 years, and they planned to decommission the legacy server. The customer service system collected data daily from the client’s contact centre (from phone calls, emails, and the consumer web portal). Imaginet imported the call centre data, including images submitted by consumers to support their complaints, and created a user-friendly model that allows the client to produce reports. We sourced data from SharePoint Document Library files and … Read more

Data Centralization & Reporting Automation Improve Business Efficiency

by

A prominent operator of retirement communities and long-term care homes was looking for a partner to help them clean their data, improve data flows, and centralize data sources. Their Power BI development had become complex, challenging, and time-consuming to load Microsoft Excel/CSV files every month to produce standard reports. To solve the issue, Imaginet constructed a centralized, organized data warehouse, imported the Excel files into tables, and created a Power BI model with improved performance. We used automated processes to bring files from Google Drive into Azure Storage, then used Azure Data Factory to run scripts, load, and transform the data from source files into the data warehouse (built in … Read more

GPS and Fleet Tracking Data Correlation Project

by

GPS and Fleet Tracking Data Correlation Provides a Holistic View For Sales & Operations A national plant wholesaler that supplies retail stores throughout the United States re-engaged Imaginet to work on a data correlation project. The client has greenhouses and production facilities across the country and a network of trucks to deliver products to various stores. The trucks have been outfitted with J.J. Keller ELDs and use the J.J. Keller Encompass Fleet Management Platform to monitor their GPS locations and other key metrics (e.g., engine RPMs, speed, and braking). In the Encompass system, each retail store has a defined geofence that shows the boundaries of that location, and it can … Read more

Remote Gym & Advanced SaaS Platform Gamifies Fitness Experience

by

An innovative startup in the health and fitness industry approached Imaginet to develop a remote gym platform (with video conferencing) to connect fitness instructors and participants safely from a distance. The initial project grew into a program that can capture, collate, and process fitness session telemetry and, ultimately, into an advanced gamification and analytics SaaS solution that our client can white-label and sell to their customers. The Imaginet team created an iOS app and website, in tandem, for the initial build, using Angular, Zoom Video SDK (in beta at the time), and Xamarin to offer customizable video functionality (two-way broadcasting).The evolution of the platform involved extending the existing infrastructure and replacing … Read more

Updated Technology & Enhanced Applications Simplifies User Experience

by

A leading transportation and logistics management organization contracted Imaginet to modernize some of its existing applications. The client’s finance department utilized old technologies and web applications that they wanted to convert to desktop applications. Our team successfully converted two applications to manage financial reports and payment processing and ensured identical functionality to the old legacy solution. We thoroughly examined the source code of the old applications to determine how the logic should flow in the new system. We used Visual Studio 2019 and WinForms for the framework, focusing on the proper organization of the code in a way that was easier for the client’s team to maintain and edit. Our comprehensive … Read more

Online suite of calculators for a provincial Agro Services Corp

by

Modern Application Development Reduces Friction & User Error For Agricultural Industry A provincial agricultural services corporation requested the help of Imaginet to update and enhance its online calculation tool, used by members of the agricultural industry. Their existing calculators were created in Microsoft Excel and were often prone to user errors and instability. Imaginet built an online suite of calculators for the client that are uncomplicated, web-based, and easily accessible on any device – including mobile. Imaginet developed the application using Angular on the front end and .Net 6 on the back end. Entity Framework and an SQL Server for storage enabled us to create a robust administration section that is … Read more

Updated Technology & Enhanced Applications Simplifies User Experience 

by

A leading transportation and logistics management organization contracted Imaginet to modernize some of its existing applications. The client’s finance department utilized old technologies and web applications that they wanted to convert to desktop applications. Our team successfully converted two applications to manage financial reports and payment processing and ensured identical functionality to the old legacy application. We thoroughly examined the source code of the old applications to determine how the logic should flow in the new system. We used Visual Studio 2019 and WinForms for the framework, focusing on the proper organization of the code in a way that was easier for the client’s team to maintain and edit.Our comprehensive quality … Read more

Intuitive Application Development Creates Effortless Shopping Experience

by

A global leader in telecommunications, media, and technology approached Imaginet to build a custom solution for their corporate furniture selection process. The client wanted to upgrade their existing system for product viewing and ordering to something more aesthetically pleasing and streamlined. We leveraged SharePoint Online to manage the framework that allowed employees to browse available office furniture, create price estimates, and generate order requests. The specialized components built within SharePoint enable internal administrators to easily organize and update products behind the scenes, while the intuitive interface allows for effortless ordering for employees. By adopting a unique user experience and design process that included multiple workshops with the organization, we created … Read more

A Rise in Employee Engagement From Custom SharePoint Online Hub Site

by

Imaginet was contacted by a well-revered, full-service civil engineering firm to design and launch an intranet portal. When their existing employee engagement intranet contract was coming to an end, the organization decided they preferred a more detailed, collaborative solution – something with a consistent and familiar feel to other tools they already used. As the company already utilized Microsoft Teams internally, it made sense for their new hub site to be created in SharePoint Online. We developed the site to meet their needs for clear company communication, document storage, and organization. Imaginet created a custom hub site featuring accurate company branding, simple navigation across departments, and changeable web parts/widgets. With the help … Read more