SharePoint Online

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

Site Configuration and Training Helps Organization Capitalize on Existing SharePoint Products  

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 to their full potential. The client needed direction and guidance to make the most of their products and to get employees and leadership excited to use the sites. Phase one of the project involved assisting with the setup of the client’s hub site and two different department sites as a pilot – IT and Finance. Both departments required separate document libraries for their sub-departments, with custom permissions.  The Imaginet Business … Read more

Microsoft Power Automate Workflows Increase Efficiency for User Creation, Onboarding, and Approvals

by

An innovative biopharmaceutical organization that Imaginet had previously helped with a SharePoint Online build wanted to automate workflows that were causing a lot of back-and-forth communication and delays in their approval process. Without the necessary knowledge or time to complete the build, the client contacted Imaginet to support the project.   Using Microsoft Power Apps and Power Automate, we created a workflow to assist with onboarding new hires and adding external user accounts to their Azure Active Directory environment. Microsoft PowerShell synchronizes the data between the SharePoint Online site and their local Azure Active Directory instance to allow communication between the different systems.  Once a record is created in SharePoint, either … Read more

Real-Time Data Analysis Made Accessible Through Online Calculator

by

A provincial agricultural services corporation approached Imaginet to update and enhance their online calculation tools that were utilized by various people in the agricultural industry. Their calculators were in Microsoft Excel and prone to user errors and instability. Imaginet built an online suite of user-friendly calculators, making them easily accessible on any device – including mobile. This stage of the project focused on the development of a fertilizer efficiency calculator for farmers to have optimum fertilizer usage at all times to maximize profits.  The Imaginet Application Development team used Angular 12, TypeScript, and HTML5/CSS3 to build the application on the front end. On the back end, we used data stored … Read more

Optimized Accounts Payable Workflow Increases Efficiency and Organization 

by

A global provider of learning and development solutions for applications engaged Imaginet to create a SharePoint Online site to track and organize invoices for their organization. Their existing external database held various accounting records, tracking charges and details on vendors, but lacked structure around the invoice approval process and a defined audit trail.   The Imaginet Business Productivity team built a SharePoint site that organizes invoices, routes them for approval, and identifies which ones are paid or outstanding. Workflows, set up with the help of Power Automate, automatically unzip any necessary files when new vendor invoices are uploaded and archive files when an invoice is approved (marked as paid). Bulk exports … Read more

Deploying a Provider Hosted SharePoint App to Azure and SharePoint Online

by
Data Migration

In this post, we are going to walk you through the process of deploying a provider hosted SharePoint app to Microsoft Azure and Microsoft SharePoint Online. We assume that the app has been created, and the app permissions are configured correctly for what the app is supposed to do. I should note that this article will only be about apps that are being deployed to a local app catalog. Also, I’m assuming that you have a working knowledge of Microsoft Azure and Microsoft SharePoint Online and can provision your own sites and web apps within them.