Out-of-home advertising network / 2026
Real-time analytics warehouse and revenue reconciliation
SQL Server star schema with 8 fact and 9 dimension tables served live to Power BI over 57 production tables, refreshed nightly. A Python reconciliation engine resolved a suspected $7M revenue discrepancy as a timing methodology artifact, validating the reporting layer.