Business Productivity Platforms

Re-Designed Reporting Solutions Improves Data Accuracy and Auditing

by

A provincial agricultural services corporation was experiencing challenges with its reporting solution. They were starting to use Power BI to replace operational reports that had previously used data from a DB/2 operational database. With data often duplicated and limited staff available to manage the data, they were encountering bottlenecks and governance issues. The client re-engaged Imaginet to help their team re-design their data analytics model and processes.   The client’s approach to replacing their existing reports with Power BI was to build each report with its own dataset from their new operational data store (ODS), which was now hosted in a SQL database. This led to many silos of similar data … Read more

File Organization and Data Consolidation Assistance Speeds up SharePoint Transition    

by

One of the largest trailer leasing and rental companies in the United States needed assistance building an intranet hub site and department sites for their organization. While they already had a couple of SharePoint sites built, they weren’t being used and needed direction and guidance to make the most of their products and get employees and leadership excited to use the sites. During previous phases, the Imaginet Business Productivity team built out sites for specific departments and pages for sub-departments. During phase three, the client was transitioning their remaining files off the network into SharePoint. To assist with the project, Imaginet focused on developing nine different SharePoint sites, each with … Read more

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