GOVERNED DATA PRODUCT
REVENUE DATA PRODUCT
Governed, finance-grade revenue dataset on the Databricks Lakehouse with a published data contract and blocking data quality gates.
Productizes the realized-revenue view of sales so Finance and Analytics consume one contracted source instead of reconciling divergent filters across dashboards. Business rules live in the data layer. Data quality signals live on the runs table. Consumers stay thin and governed.
Azure SQL star schema is ingested via JDBC into Databricks. A PySpark transformation applies the Completed-only realized-revenue rule, joins conformed dimensions, and writes a partitioned Delta table at revenue.silver.fact_sales_completed. A published data contract defines ownership, SLA, grain, semantics, and exclusion policy. A blocking data quality task enforces null, grain, status, freshness, and source-to-curated reconciliation checks. Every run logs one row to revenue.ops.fact_sales_completed_runs with SLA status, drift, and failure detail. Power BI consumes the silver table and reads the runs table for a health tile.
- Azure SQL star schema to Databricks Lakehouse
- Published data contract
- Blocking data quality and reconciliation gates
- Run-log and SLA health tracking
- Power BI-ready silver table