SUCCESS STORY
End-to-end enterprise Lake House delivery
Kagool delivered a Modern Data Platform solution in less than 12 months, creating a Data Lake House which retired two legacy data warehouses.
This enables reusability of Common Data Models across visualisation, application integrations, and advanced AI/ML use cases.
$271k
saved in one year
40%
reduction in manual efforts
20+
KPI dashboards
42
Common Data Models
About the client

The client manufactures speciality medical devices that are vital to hospital, emergency, home and care environments. Their products are critical to the operating of intensive care, surgery, and chronic illness management.
They are a leading infusion therapy company with estimated revenues of approximately $2.5 billion.
The Challenge
The client aspired towards making more effective and efficient business decisions backed by data, to become more dynamic and adaptable in an unpredictable world. They aimed to be able to use various datasets from disparate sources all together to gain actionable business insights.
Before the transformation programme, the client was using 18 Business Intelligence solutions on 5 different analytics platforms, and 90% of this was delivered via Excel.
This mix of reporting methods limited the efficiency with which business insights could be gained. 70% of the reports were only produced once a month.
There was also potential for much more control and efficiency to be put into reporting processes to ensure people focused on the right data. Initially, only 8% of KPIs were automated, and 30 KPIs had no access control.
The majority of business systems run on Oracle, both on premises and in the cloud.
Our Solution
Kagool carried out a 5-week assessment of the client's existing enterprise landscape, requirements and approach, and subsequently recommended a organisation-wide unified data strategy. Kagool was chosen above competitors to deliver this, and the solution was delivered in less than 12 months, an impressive timescale for a programme of this scale.
A Microsoft Azure Modern Data Platform was built from ground up. We used Kagool’s own product, Velocity, which was built in conjunction with Microsoft, to integrate 8 on-premise and SaaS sources with Azure.
A Data Lakehouse was built using Velocity off-the-shelf, with 42 Common Data Models (CDMs) across supply chain, service repair, and distribution & Customer 360.
This served:
- 15 Business Intelligence dashboards in Power BI
- 3 web applications to allow offline data entry and maintenance
- 4 external business systems subscribing to the Data Lakehouse in real-time
As well as building these, Kagool empowered the client with a completely self-service solution by delivering trainings on Power BI and Databricks to the business, allowing end users to easily create their own reports within minutes.
You have been a great team and we created a great tool. I want to thank all of you for all the long hours you put into the project. We all have learned so much over the last 9 months and are all better for the learning and friendships we have built. I hope you have enjoyed it as much as I. I look forward to working with you again.
Client data & analytics lead
Outcomes
This project is now live, with people in the business using it every day to gain actionable insights and drive informed business decisions.
The Modern Data Platform is easily scalable and adaptable for further innovations including Artificial Intelligence (AI) and Machine Learning (ML), Internet of Things (IoT) integrations, apps, and more.
Benefits
Quick ROI
$271k saved in year one
Saves time
40% reduction in manual efforts
20+ KPI dashboards
KPI reports are centralised and automated
Single source of truth
Simplified integration across platforms
Security
Enhanced security with Role-Based Access Control to the data
Self-service
Users are empowered to create their own reports within minutes
Adaptable
Modern Data Platform is easily scalable and adaptable
Innovative
Ready for further innovations like AI, automation, and IoT
From proposal right through to productionising the solution, a One Team approach to delivery was a key to our success.
Responsiveness, flexibility and adaptability of the Kagool team to support the client with training as we designed and delivered ensured that the client did not have a dependency on us once the solution was in BAU.
Louise Higgins
Senior Project Manager and Customer Engagement, Kagool
More case studies
Data Integration to Enhance Business Intelligence
SAP Extended Warehouse Management
Smiths Group unites data from five global divisions and hundreds of apps with Azure Data Lake Storage
