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.

quotesArtboard 1 copy 2

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

quotesArtboard 1 copy 2

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

Share by: