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.

A stack of coins with a dollar sign on them.

$271k

saved in one year

A white background with a few lines on it

40%

reduction in manual efforts

A line drawing of a graph on a white background.

20+

KPI dashboards

A magnifying glass with a building in the middle of it.

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.

A white board with a bunch of icons on it

Our Solution

A white sheet of paper with a bunch of logos on it
A diagram of a system with the word velocity at the top.

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

A dollar sign in a black circle on a white background.

Quick ROI

$271k saved in year one

A black and white drawing of a clock on a white background.

Saves time

40% reduction in manual efforts

A line drawing of a graph on a white background.

20+ KPI dashboards

KPI reports are centralised and automated

A white background with a few lines on it

Single source of truth

Simplified integration across platforms

A black and white shield on a white background.

Security

Enhanced security with Role-Based Access Control to the data

A black and white drawing of a key on a white background.

Self-service

Users are empowered to create their own reports within minutes

A black and white drawing of two arrows pointing in opposite directions on a white background.

Adaptable

Modern Data Platform is easily scalable and adaptable

A white background with a few lines on it

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: