ENVU Simplifies KPI Reporting with Real-Time Dashboards Using Databricks and Sigma
Many growing enterprises hit a breaking point when KPI reporting is held together by scattered spreadsheets, manual updates and inconsistent versions. ENVU was no exception.
To break out of that cycle, Cloudaeon rebuilt the entire reporting layer on a governed data stack using Databricks, Sigma and Azure. Databricks’ Medallion architecture now ingests and structures all KPI data, Sigma delivers live dashboards directly on top of curated tables and Azure handles the orchestration that keeps everything running on schedule.
The result is a fully automated, end to end pipeline that eliminated 99% of manual prep, removed 97% of Excel dependency and equipped ENVU’s teams with real-time operational insight, shifting decision making from lagging snapshots to real-time insight.
Author
Raj
Manoharan
Cloudaeon's Chief Architect, Raj is an alumni of NTT Data and has 20+ years experience in delivering enterprise transformation projects in Cloud, Data & AI.
Connect with
Raj
Manoharan
Get a free recap to share with colleagues
What is Lorem Ipsum?
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.
Introduction
ENVU, a Bayer spin off, was running its KPI engine on a fragile web of Excel files scattered across SharePoint: manual updates, version chaos and zero real-time insight. As the business scaled, the reporting framework simply couldn’t keep up. The objective was to create a unified performance layer that the business could trust. Cloudaeon partnered with ENVU’s data team to replace the spreadsheet chaos with a governed data architecture, automated pipelines, active data-quality oversight and real-time dashboards that finally delivered a single source of truth.
Architecture and Approach
The KPI platform was built on a three layer architecture:
Databricks: Executes the Medallion framework to ingest, clean and model ENVU’s KPI datasets.
Sigma: Connects directly to the curated layers to deliver real-time, drill-down dashboards.
Azure: Provides the orchestration and infrastructure backbone that manages compute, scheduling and operational reliability.
Together, the stack delivers governed pipelines, consistent data outputs and live analytics without manual intervention.
Step by Step Walkthrough
Step 1: Data Ingestion
Set up three Databricks notebooks, each doing one job.
Pull data: Reads 14 Excel files straight from SharePoint.
Step 2: Data Transformation
Established a robust Bronze → Silver → Gold data pipeline for clean, governed data.
Connected Sigma to Databricks using native connection options.
Step 3: Automation & Orchestration
Gets the raw data organised into proper tables.
Creates the polished business reports that make sense for day to day use.
Azure Data Factory runs these notebooks automatically, which means the dashboards update themselves without anyone having to remember to do it.
Step 4: Dashboarding & Write Back in Sigma
Connected Sigma natively to Databricks.
Teams gained interactive dashboards and the ability to write back to Databricks, no copy paste, no file chaos.
Results
99% reduction in manual data prep: Databricks pipelines now run end to end without human intervention.
97% drop in Excel dependency: KPI reporting shifted entirely from SharePoint spreadsheets to a governed Databricks and Sigma workflow.
Decision cycles accelerated: Sigma dashboards refresh automatically, giving teams live operational insights instead of outdated weekly files.
Conclusion
When ENVU combined Databricks’ structured Medallion setup with Sigma’s live, exploration ready dashboards, their entire KPI process shifted gears. What was once a slow, error prone cycle of updating scattered Excel files turned into a clean, automated workflow where data moves reliably through pipelines and teams get the KPIs they need the moment they need them, allowing them to focus on decisions, not updates.
Want to see how this could work for you. Talk to an expert now.
