They capture and process information from several NHS Trusts and local Authorities to provide a consolidated view of data into reports that their clients can access easily and can share data directly with one another via the website. Centralising where clients can capture their data is the key to giving them great confidence in how they process data to their clients. Their current process took a week to complete and relies on accruing sensitive data which later we found was processed manually in an Access database.  

Initially, the were only interested in Power BI Review and Recommendations. With this in mind, risual identified several vulnerabilities in their business environment which pushed them to automating data capture in a time intensive manner and providing improved consolidation service for their clients. As of 2022, recommendations have been made to deploy Azure Synapse with an integration from hosting Power BI. 

The business is looking to reduce their dependency on individual resources and upskill to prevent relying on individuals and rely on the business. They are also looking to onboard fresh staff to facilitate this which makes it easier to upskill.  

The business now has a clear view of their Power BI now have limited issues and have discovered security vulnerabilities with their current solution. They have an unobstructed vision on what changes to make soon and have ongoing plans to modernise their current solution. From this, it now takes them seconds to process data whereas it used to take weeks, giving them greater confidence in the future.  

Their solution is to deploy Azure Synapse with an integration to their customers facing portal. Integration will occur following App Service configuration and connections to an Azure Data Lake. Data can be processed automatically from the Azure data Lake using Azure Synapse Analytics.  

If you enjoyed this story, or have an upcoming project in mind, please don’t hesitate to contact us via enquiries@risual.com or 0300 303 2044. Alternatively, you can submit an enquiry here  Contact – risual

About the author