SharePoint Online

Protecting Sensitive Data: Ensuring Privacy from a Data Engineering Perspective 

by
Sensitive Data

Protecting Sensitive Data: Ensuring Privacy from a Data Engineering Perspective  In a bank call center, staff members handle clients’ data. They have to identify clients for various requests while maintaining privacy. The call center representative must be able to identify the client while keeping the credit card number private, even though the system holds card information. Protecting sensitive data is crucial for the bank’s success.   You also want to keep the value of transactions on the card private. Data may be substituted with random numbers or displayed as ***, showing only the last four digits for validation purposes.  Now, imagine the same data set is sent to the analytics team to analyze … Read more

Custom Script Setting in SharePoint & OneDrive Removed

by
Custom Script Setting

Last week, we published a blog discussing Microsoft retiring SharePoint Add-Ins. In that blog, we briefly discussed how the Classic Mode for Custom Scripts has been affected by that change. The Custom Script setting in SharePoint and OneDrive has already been removed – the change took place in May 2024.   There is a new PowerShell command (DelayDenyAddAndCustomizePagesEnforcement) that will allow administrators to delay any changes until November of this year. Additionally, the NoScriptSite setting will be configured to True for all existing sites except for specific site templates.   How Will The Removal of Custom Script Settings Affect My Organization?  Because the Custom Script setting has been removed, you can’t add, … Read more

Custom Global Navigation Using SPFx Application Customizers

by
SPFx Custom Applications

Out-of-the-box navigation in SharePoint Online has come a long way over the last number of years. Hub sites and hub site navigation provide much more customizability and consistency for navigating around a hub. However, modern intranets in SharePoint Online are generally made up of multiple hubs. Maintaining a consistent experience across all those hubs and sites can become a daunting task. While infinitely better than what we’ve had in the past, it still falls short of a truly unified and engaging experience. The ever-expanding lists of links can make it difficult to keep organized and make it difficult for users to find what they are looking for. In this blog, … Read more

Customizing Lists and Libraries with Custom Actions and Field Extensions Using SPFx 

by
Using SPFx

SharePoint Framework (SPFx) is relatively new, but we can’t stop talking about the benefits it has to offer. SPFx allows you to use modern web technologies and tools in your preferred development environment to build productive experiences and apps that are responsive and mobile-ready. In this blog, we are going to discuss how SPFx is fully customizable by using real-time examples as well as the benefits of using SPFx.    Custom Actions  A document library is a great place to store documents. However, managing documents as a part of a process sometimes requires additional manual steps. This can be setting metadata, applying labels, or starting an approval process. While all … 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

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

Migrating to Azure Data Factory Leads to Improved Security and Improved ROI

by

A major Canadian oil & gas company reached out to Imaginet to rewrite some of the old infrastructure they currently had in place and pursue an Azure Data Factory migration. Imaginet had built their data warehouse 10 years ago, but changes in technology prompted the client to make changes to their existing data loading processes. We had previously used SQL Server Integration Services (SSIS) to build their data factory, however, migrating to Azure Data Factory had become the better option for their business needs, as they wanted to move from on-premises servers to cloud services in Microsoft Azure.  Our client had started to experience issues with their current on-premises SQL … Read more

Upgraded Development Stack Improves Data Governance & Quality

by

A leading real estate and financial services asset management company needed assistance migrating their legacy on-premises data environment that had become difficult to manage. Some key parts of the legacy system relied on Microsoft Excel and a web application. Loading data was complex and manual, and a lack of data governance needed to be addressed. The client asked Imaginet to upgrade the application using a more modern development stack to clean up and standardize how data was loaded and processed.  Using Azure Data Factory as the primary method for data integration (ETL) processes, the Imaginet data engineering team moved the data environment into Microsoft Azure cloud services, with a data … Read more

Modernized Application Results in Increased Productivity and Better Control Over Technology 

by

A provincial agricultural services corporation had been using IBM Domino Designer to complete their organization’s projects. Designer is an outdated tool making it difficult to find someone who can support the maintenance of it. Very few developers are familiar with Designer due to its decrease in popularity. They approached Imaginet for assistance in developing a more modern application. Outdated applications and technology result in a variety of challenges. Making changes or adding additional requirements becomes almost impossible because of the lack of knowledge of these tools. Therefore, our client was experiencing outdated processes resulting in inefficiencies and a harm to productivity. In addition, the client could not see the developer’s … Read more