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.
Centralised Subscriber Data Integration with Power Automate
The client approached Synapx for support with the Power Platform through a time-and-materials engagement. The project focused on centralising subscriber data management and streamlining processes. This involved integrating three distinct mailing list forms into a unified database to enable efficient...
Migrating Power BI to Fabric Lakehouse with Medallion Architecture
Mount Anvil approached us with a clear need to automate their processes for managing the transfer of various materials stored in piles between internal and external sites. Their existing approach was heavily manual, involving spreadsheets and phone calls to coordinate...
Power BI Reporting & Power Apps AVC Calculator
The client approached Synapx to provide Power Platform support under a time-and-materials engagement. The project aimed to enhance data analytics and streamline business processes through Power BI implementation and creation of an AV Calculator from Excel to Power Apps,...
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.
Book A Free Discovery Session
Schedule a FREE call with our power platform specialists.
Book a Discovery Session