The Business Challenge

Audiogest faced the complex task of unbundling and centralizing multiple disconnected systems—including an on-premise PHC ERP, an Outsystems enterprise portal, and external data feeds (Dashmote and GfK)—into a unified source of truth.

The organization faced key architectural and operational hurdles:

• Fragmented Revenue Operations: Disconnected visibility between operational activity (contracts, on-site inspections, licensing) and core financial events (invoicing, collections, legal actions).

• Uncontrolled Cloud Overhead: The necessity to build modern lakehouse pipelines while strictly eliminating idle cloud compute costs.

• Complex Entity Resolution: High volumes of inconsistent entity naming across disparate operational systems requiring predictive resolution and automated churn forecasting.

• Fragile Ingestion Pipelines: Ingestion routines vulnerable to external API schema drifts and intermittent connection failures.

The Technical Solution

Sersight architected a robust Medallion Architecture (Bronze, Silver, Gold) on Microsoft Fabric, orchestrating resilient ingestion, machine learning, and dynamic FinOps automation:

• FinOps Cloud Automation (Azure Automation & Fabric F-SKUs): Engineered an intelligent orchestration pipeline that scales compute capacity on-demand—triggering F-SKUs only during active extraction and semantic model refreshes, and shutting down compute immediately upon job completion to minimize total operational costs.

• Metadata-Driven Ingestion Engine (PySpark & OneLake): Built a self-healing, configuration-driven ingestion engine capable of automatically adapting to upstream schema drifts and recovering from transient network failures.

• Embedded Machine Learning & Entity Reconciliation: Integrated automated Python ML routines into Delta Lake pipelines, employing morphological fuzzy matching to resolve cross-system records and injecting predictive churn scores directly into fact tables.

• High-Density SVG Visual Engineering (Power BI / DAX): Replaced default visuals with custom-coded SVG elements in DAX, rendering pixel-perfect financial execution rates, YTD vs. LY comparisons, and net portfolio trends into an executive interface.

The Strategic Impact

The unified platform transformed Audiogest's data landscape into an automated, cost-efficient analytics ecosystem:

• Minimal Cloud Compute Spend: Zero idle infrastructure costs through automated, event-driven compute scaling.

• End-to-End 360° Revenue Traceability: Complete transparency across the entire revenue lifecycle, tracking every licensing euro from field audit to cash collection.

• Predictive Decision Intelligence: Transitioned leadership from reactive descriptive reporting to proactive risk management and portfolio forecasting.