Power BI - User Interaction Report
This company approached us having gone through a huge change in their ways of working as a result of the COVID-19 pandemic. This huge shift was new to them and they wanted to not just monitor, but gain insights from and felt Power BI, given their infrastructure was the way to proceed. We worked with key stakeholders to make sure the reporting requirements were met, to ensure users across the organisation would be able to benefit from the new reporting system and layout
Case Study50%
reduction in data retrieval time, enabling faster access and improved productivity.
100%
real-time data availability, ensuring up-to-date insights for informed decision-making.
40%
faster incident resolution, enhancing visibility and accelerating response times.
30%
increase in report engagement, improving adoption and interaction across teams.
The Challenge
During the COVID-19 pandemic, our client’s working model changed drastically to a virtual/working from home model, and as a result, were using Microsoft Virtual Desktop to access the company network. Our client wanted to report on user interaction with the Virtual Desktop application to further understand user working patterns and engagement. The requirements were:
- Provide analysis on users’ login frequency.
- Duration of access.
- Unique connections per day.
- Analysis on top 3/lowest 3 user logins per week.
- Automated alerting where there were no connections within a period of time.
Our Solution
Our client was already subscribed to a Microsoft E5 license, of which Power BI Pro is included. Using the integration functionality between Azure Log Analytics workspace and the Power BI cloud, we developed a fully automated solution that extracted data from Azure into Power BI allowing us to present this information in a professional dashboard for our clients senior stakeholders. Simple buttons, filters and visuals were applied to present the information in the most logical way for the consumers of the report. Using Power BI subscriptions, we were able to send daily emails to prescribed users that provided a snapshot of daily KPIs.
The Result
Once implemented, no manual effort was required whatsoever, as a result of the automated refreshing of data in the Power BI cloud. Users would also have daily emails sent to them providing them the analysis/reporting requested, rather than having to retrieve them manually.
Other Case Studies
At Synapx, we’re proud to show how our solutions have transformed the way our clients work and operate. Below you can see our latest client project.
Streamlining Project Delivery with Power BI & Power Apps
The client approached Synapx to implement a reporting system that would provide clear oversight on the adoption and implementation of Microsoft Power Platform across their organisation.
Power Platform Center of Excellence Implementation - Power BI
The client approached us in order to implement a reporting system to provide oversight on the implementation of power-platform within their organisation.
Material Management Application with Business Central Automation - Power Apps with Power Automate
The client approached us needing a system to automate their processes for managing the transfer of different materials held in piles between their internal and external sites.
Policies and Procedures - Power Apps with SharePoint Documents Library
The client wanted an application to effectively manage their companies policies and procedures from within a SharePoint documents library.
Personnel Directory - Power Apps
The client wanted a directory within their SharePoint site to display all their staff members, and provided key contact details such as their phone number and email address.
Leave Calendar - Power Automate and Power Apps
The client wanted information from their third-party leave calendar tool (Timetastic) embedded within their SharePoint site.
Internal Controls Risk Register - Power Apps
The client wanted an application to manage risks within their business by ensuring they had relevant controls in place.
Travel Expense Approval Application - Power Apps
The client wanted an application embedded within their SharePoint site allowing users to raise and manage their travel expenses.
SharePoint - Intranet Site
A company approached us seeking the development of a SharePoint intranet site providing a number of varying functions to staff within their organisation.
Book A Free Discovery Session
Schedule a FREE call with our power platform specialists.
Book a Discovery Session