The challenge
The challenge
Leadership could not see which departments used the intranet or which searches failed.
Approach
An intranet nobody could measure
The bank's SharePoint intranet had become a black box. IT could not tell which departments used it, and teams published content without knowing whether anyone read it.
Employees complained about search, but IT had no data to find the cause. Executives questioned the value of the intranet because nobody could show them how it was used.
Collecting activity across SharePoint and Microsoft 365
Custom SharePoint event receivers and the Microsoft Graph API collect page views and engagement, search queries including the ones that fail, document downloads, use of the Microsoft 365 apps connected to the intranet, and the paths people take through it.
Azure Functions transform the data as it arrives, and Azure SQL Database stores it.
Dashboards for leaders and content owners
Power BI Premium dashboards show engagement by department and region, how well search works and which queries are common, which content is used most, and which pages nobody visits. Leadership gets a monthly scorecard.
Azure AI services add content recommendations and an alert when engagement on a page starts to drop.
Privacy first
Individual user data is anonymized, and the analysis works on aggregates only. Access to the analytics runs through the bank's Azure Active Directory.
We also showed content owners how to read the numbers, so their decisions about what to update or retire rest on data.
Three phases over 12 weeks
In the first four weeks we put data collection in place in pilot departments and checked its accuracy against baseline metrics. From week 5 to week 8 we built the Power BI dashboards and tested them with the communications teams.
In the last four weeks we scaled the suite to all 45,000 employees and trained content owners and executives to use it.
Results
The outcome
Content owners and IT can see which searches fail and which pages nobody opens. Unused content was identified and archived, and leadership reviews a monthly scorecard of intranet use.
Stack
Technology used
- SharePoint
- Microsoft Graph API
- Azure Functions
- Azure SQL Database
- Power BI Premium
- Azure AI services
The bank is not named, as in the original write-up on our blog (12 May 2025).