From Manual to Real-Time:

Centralising Kipu and Dazos Data for Scalable Healthcare Insights

A case study on how Tenplus turned siloed EMR data into a real-time Healthcare Analytics Platform.

Client Background

The client is a growing healthcare organisation focused on addiction treatment across multiple clinics.

  • They rely on two main platforms:
  • Kipu for EMR and clinical workflows
  • Dazos for operations, scheduling, and ancillary data

Both systems were essential, but their data lived in separate silos. Reporting across both tools was slow, manual, and hard to trust.

The Problem: Manual, Delayed and Siloed Reporting

Before working with Tenplus, the client faced several challenges:

  • Data from Kipu and Dazos was exported manually from web interfaces.
  • Reports were often days out of date by the time leadership received them.
  • Every department used its own spreadsheets, leading to conflicting numbers.
  • Clinical and operational leaders had no single view of patients, clinics, or provider performance across systems.
  • There was no real-time reporting, which limited fast decision-making.
  • In short, the organisation had good systems, but no unified data layer to connect them.

In short, the organisation had good systems, but no unified data layer to connect them.

They needed:

Our Delivery Approach (Five Phases)

Centralised, near real-time data

Automated pipelines

High data quality with full audit trails

A self-service reporting layer for clinicians and operations

Solution Overview

Tenplus designed a cloud-native solution using Azure Data Factory, Azure Functions, and Databricks, with Power BI as the reporting layer.

At a high level, the architecture looked like this:

  • ADF Pipelines pulled data from Kipu and Dazos APIs using token-authenticated, paginated calls.
  • Raw JSON landed in a controlled storage layer for traceability.
  • Azure Functions cleaned and normalised the data into tabular, analytics-ready formats.
  • Databricks Notebooks applied business logic, enrichment, deduplication, and Delta Lake optimisations.
  • Curated Delta tables powered Power BI dashboards for real-time self-service analytics.
  • Monitoring and alerts used ADF logging, Log Analytics, and Microsoft Teams notifications.
5

Data Analysts

Our in-house data analysts have a hands-on approach to data.

45

Companies analyzed

Last year, we were able to help nearly 50 companies.

Process

Data designers
0
Our designers have an extensive background in data analysis.
Visualizations made
0
From presentations to marketing materials and beyond.
Ongoing projects
0
Data changes, but our team stands by your side when you need us.

Results: From Manual Reports To Always-On Insights

The impact of the new platform was clear and measurable.

The organisation:

  • Eliminated manual exports from Kipu and Dazos.
  • Dramatically improved data freshness, from days to near real time.
  • Created a single source of truth for clinical and operational reporting.
  • Reduced errors and manual rework caused by spreadsheet-based reporting.
  • Enabled self-service analytics for clinicians and operations staff.
  • Built a scalable foundation that can support more systems and use cases in the future

What started as a simple goal to automate reports became a long-term strategic data platform for the organisation.

⭐⭐⭐⭐⭐
“Before working with Tenplus, our reporting process was slow, manual, and full of gaps. Now we have a real-time data platform that pulls clean, trusted data from both Kipu and Dazos without our team lifting a finger. Our clinicians and operations teams depend on the dashboards every single day. Tenplus gave us clarity, speed, and a system that will support our growth for years. It has changed how we make decisions.”

We’ve Helped Them

We’ve partnered with many household brand names to deliver insights and solutions to their problems with big data.

Happy Clients

Don’t just take our word for it – our clients frequently stay in touch with us and work with us on future projects that require big data insights.

Start Your Free PoC With Tenplus Today

Your idea does not need months of planning. Your team does not need to guess. Your business does not need to wait. A free PoC gives you a working example in only 15 days. It shows you what is possible and why modern data and AI systems matter.