This portfolio showcases the work I have done over the course of my career, even if many of my most recent projects were finished through my company. All of the SharePoint examples on this page were created using ShareGate, SPFX, Custom development and Power Shell.
SharePoint Migrations with Share Gate and Power Shell
During the process of developing the Company's intranet, a seamless transition from SharePoint Online Classic to both MS Teams and a Communication site was orchestrated.
A PowerShell script was rigorously created, employing the ShareGate PS module, to facilitate this move. The goal of this script was to automate the entire operation, with variable input parameters pulled from an Excel document serving as a guide for subsequent automated actions.
The automation included the dynamic construction of MS Teams sites and the migration of content from the SharePoint Classic source site. This material was strategically dispersed across numerous channels, and it was also generated dynamically by utilizing the Excel input file.
The extensive documentation of this migration process, including granular details of each content transfer, is noteworthy. This log meticulously records any failures or warnings occurring from SharePoint during the course of the activity. In addition, an inventory log was generated to account for all successfully moved sites, aiding in the development of a strong tracking mechanism.
Migration Sample Input File
Click on images to Zoom in
Sample Input Excel File - User Security Details Tab
Sample Input Excel File - Private Channel Security Details Tab
Sample Input Excel File - Team Details Tab
Sample Input Excel File - Channel Details Tab
Sample Input Excel File - Content Details Tab
Full Migration Logs
Click images to Zoom in
Main Migration Log Files
Copy Content Report form ShareGate PS Module
Inventory Validation - After Migration
Click to Zoom-in the images
All of the preceding processes were aggregated into a single output Excel report that provided access to all information from a single spot.
Enhancing SharePoint On-Premises Search with Advanced Technical Customizations
To improve the search capabilities of SharePoint On-Premises, we use sophisticated changes. The presentation of search results were optimised, and the search schema was modified to more correctly reflect the information in the primary document collection.
- We made significant changes to the search schema during the preliminary stage. In order to improve search results by incorporating pertinent data and giving users more exact results, we added new properties taken directly from the document library.
- Additionally, we carefully created a number of ways to show search results. Notably, we developed a personalised interface that takes user preferences and corporate positions into account. This tailored view optimises the way results are presented, sharpening and streamlining the search procedure.
- A thorough validation process was performed in order to enhance the accuracy and dependability of the information supplied. Before making the information accessible to users, this step rigorously checks it to confirm its accuracy and applicability.
- When validation was successful, we cautiously linked the search results to pertinent data from another library. These connections efficiently and quickly direct users to their desired locations.
Conclusion: SharePoint On-Premises search has been greatly improved by our methodical application of exact modifications, allowing for accurate and efficient information retrieval. By carefully integrating these upgrades, the SharePoint platform's value is maximised, leading to greater productivity and higher user happiness.
Tailored SharePoint Analytics Solution
I've been successful in creating a custom internal tool to power SharePoint analytics inside of our company intranet. This solution offers a full spectrum of analytics functions and has been carefully tailored to correspond with the specific needs of each department. The powerful Power BI dashboard that sits at the centre of this solution is tightly linked to department-specific data and strengthened by sophisticated site-level security management tools. The following essential characteristics of the analytics tool provide priceless insights:
- Comprehensive Dashboard: A dynamic dashboard provides a brief summary of user activities with the system. It gives us important information on the areas with the highest user activity, giving us access to vital geographic intelligence.
- Activity and User Overview: Detailed reports give an overview of the most active users and material on our intranet. This classification is based on several employee profile characteristics and allows for a detailed analysis of user interaction and content traction.
- Security Insights: The tool provides in-depth reports explaining security modifications that are taking place on the sites. This information is crucial for strengthening our online defences by optimising the Intranet's security structure and governance.
Through O365 Live Audit logs, which are regularly obtained by a PowerShell script running in the background, all the data is smoothly integrated into our analytics system. Before finding its proper position within our SQL Database, this raw data goes through a number of painstaking processing, transformation, and filtration stages. Our main Power BI Report is smoothly incorporated within a SharePoint Page and is closely tied to the SQL Database, which acts as a reliable repository.
In conclusion, our dedication to utilising data for informed decision-making is demonstrated by our customised SharePoint Analytics solution. With the unmatched insights provided by this smart tool, our intranet can function more productively, securely, and with better governance.