Case StudyInstant insight puts people first with Power BI
What happens when your reporting suite is obsolete? Manual data wrangling? Not if we can help it.
About our client
RedArc is a specialist nursing organisation giving tailored advice and support to clients facing serious physical and mental health conditions. They handle highly sensitive personal and medical data. Robust, secure data and efficient reporting are essential to them.
When the RedArc team realised their critical management information (MI) software was almost obsolete, we built a future-proofed reporting suite.
Managing data for vulnerable people
Operating in a highly regulated sector, RedArc support vulnerable people on behalf of major insurance providers. They depend on fast, accurate, confidential data reporting, which informs decision-making. Ultimately, it’s this data that drives the compassionate, empathetic services they provide to their patients.
“Because we’re nurses, we handle personal health data regarding medical conditions and individual’s medical history. That information is obviously very sensitive.”
Aled Powell, RedArc Operations Manager
Upgrading and improving an obsolete system
Fast, reliable data is vital to RedArc’s work. In late 2022, Microsoft announced that they were no longer supporting the data extract software that RedArc relied on to transfer information from Dynamics to an SQL Server.
This meant reconsidering their entire reporting infrastructure.
“Had we not secured the support needed, we would have lost the ability to produce MI for ourselves and our clients quickly and in a presentable format.”
Taking no action would mean slowing down RedArc’s operations dramatically, having a massive impact on costs, clients and above all, their patients. Without these reporting facilities, the data would need to be collated manually by the team. Manual data entry is tedious, time-consuming and prone to errors. The team reckoned it would delay their operational efficiency by about two weeks. When you think about the amount of health data processed, this wasted time is potentially dangerous to patients.
A team of specialised data engineers at your disposal
Working with us, RedArc got a team of highly specialised data engineers for the cost of one full-time hire. We were onboarded to the team and worked shoulder-to-shoulder with them. We figure they know their organisation’s needs best and we know the data and how to deliver it.
“We built up trust with the developers at Assured, understanding how they would work, and formed a great working relationship with them in that respect—very collaborative.”
Superior reporting. Faster results
Working alongside the RedArc team, we:
- Seamlessly migrated 17 critical SSRS reports to a new platform as paginated Power BI reports, without disrupting operations
-
Fully rebuilt RedArc’s reporting suite, making it accessible to any staff member and easily shared with clients
-
Introduced a new operations report in Power BI, providing senior management with consolidated business metrics they’d never been able to get before
-
Added self-service capabilities, enabling RedArc to build custom reports as they needed them.
-
Offered ongoing, ad hoc support for improvements and troubleshooting, becoming RedArc’s go-to partner for Power BI needs.
Less guesswork, more good calls
Working with Assured is a partnership. You stay in charge while we take care of the heavy data work. Combining our expertise while remaining under the guidance of the RedArc experts meant we could deliver exactly what was needed. Everything had their needs in mind. Yes, we sorted out their reporting issue, but we went a bit further than that.
“The operations report provided us with insights that were previously impossible to consolidate. It’s been used by senior company members and has made operations a lot faster.”
For the RedArc team, not having to process data manually and build reports from scratch meant that they could spend their time more efficiently and focus on looking forwards, not backwards.
“We’d really recommend working with Assured. From the first phone call we had a great introduction to the management team, then built a fantastic working relationship with their data engineers over the course of the project. It’s Assured’s multi-skilled approach that not only saved the business and our clients from delays and disaster but put us in a prime position to move forward with confidence and clarity.”