DentaCore needed a scalable data platform to prepare, transform and make available data from various source systems for reporting and analysis. The goal was to create a modern architecture supporting both operational reporting and future analytics requirements.
CONSENSO TECH developed a target architecture for an Azure-based data platform with Azure Databricks as the central lakehouse element. The architecture structures data into bronze, silver and gold layers: raw data is first ingested unchanged, then cleansed and harmonised, and finally modelled for reporting and business analytics use cases.
Power BI serves as the visualisation layer for dashboards and reports. Operations, support and SLA aspects were also considered, so that the platform not only works technically but can be maintained and developed further in day-to-day operation.