Data Analytics

Imaginet in Action: Building Software That Solves Real Problems

by
Custom Software

Organizations are under a lot of pressure to modernize, scale, and innovate fast. Especially with how rapidly technology is evolving. Many people fall into the trap of thinking that all tech is good, and if you have any tech solution, you’re set. Unfortunately, that’s not the case. We are focused on building software that solves real problems, is strategic, adapts to change, and has measurable impact. For over 25 years, Imaginet has helped organizations across industries design and deliver custom software solutions that solve complex problems, unlock new opportunities, and drive transformation. We focus on strategy, not generic solutions. In this blog, we’re going to discuss how we have helped … Read more

Imaginet in Healthcare: Solving Complex Challenges with Custom Software, UX, DevOps, and Data Strategy

by
Imaginet in Healthcare

Healthcare organizations face a unique set of challenges: regulatory complexity, legacy systems, siloed data, and the constant pressure to improve patient outcomes while reducing operational costs. Technology can help, but only when its custom designed to solve the right problems. Building custom software solutions that address the real-world needs of healthcare providers, administrators, and patients is key. Our approach is grounded in strategy, collaborating with our clients, and strong technical expertise across four key service areas. In this blog, we’ll walk you through a series of examples of how our services have helped our clients in the healthcare sector. Custom Software Development: Streamlining Care Delivery Healthcare workflows are rarely (if … Read more

Inside Microsoft Fabric: A Conversation with a Data Scientist

by
Inside Microsoft Fabric

As a non-technical person, I wanted to understand more about Microsoft Fabric and why people love this tool. I sat down with one of our data experts, Anastasiia, to get a better understanding of how Microsoft Fabric helps her in her work. This blog will provide you with a more in-depth view inside Microsoft Fabric, it’s benefits, and it’s failures. When I asked her to talk to me about Fabric, her immediate response was, “Fabric is a masterpiece. It is super convenient and underestimated as a tool. However, I am incredibly happy to see our clients becoming more aware of all the benefits Fabric is offering as we receive more … Read more

Clean Data, Clear Decisions: How to Optimize Data Quality

by
Clean Data

Last week, I sat down with one of our data experts, Olena Shevchenko, to get her thoughts on clean data and why it’s important. As someone with a non-technical background, I wanted to understand the steps you can take to ensure you are working with clean data.   Clean Data: Step 1  Olena explained the first step she would take is exploring. She gave the example of having a very wide data table, where you may or may not know the source of the data. You want to explore what kind of naming standards there are for the columns and understand what the underlying data behind it is. You also want … Read more

Databricks Migration Saves Money and Improves Data Accessibility

by

A provider of real estate advisory services contacted Imaginet for support on a system we had built for them a few years ago (mostly built using Azure SQL). They have multiple databases that have monthly costs associated with them. Our client was looking for a cheaper solution as the monthly costs were quite significant. They also had an existing capacity agreement with Databricks, so our goal was to conduct a Databricks migration with our clients databases.   What We Did  We started from scratch and built all the coordinates and objects for our client’s architecture. We used metadata to create their tables and developed a custom autoloader to transfer files to … Read more

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

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

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