Anonymized Power BI artifacts.

11 integrated dashboards for SPE financial operations

Production Power BI suite for a Brazilian real-estate BPO (Business Process Outsourcing) operation managing financial operations for multiple SPEs (Sociedades de Propósito Específico) — covering the full cycle from Controladoria (Financial Controlling) and Tesouraria (Treasury) through compliance, quality assurance, and governance.

11 dashboards · 2,247 DAX measures →

• BI Controladoria (Financial Controlling) · 594 DAX Bank balances, payment processes, closing status, reconciliation
• BI Tesouraria (Treasury) · 576 DAX Treasury management, payment emission, supplier tracking
• BI DVQ · 370 DAX Document verification & quality control
• Painel de Qualidade (Quality Panel) · 204 DAX Quality control across construction processes
• Mesa de Controle (Control Desk) · 159 DAX Operational control desk overview
• Tesouraria (Ops) · 138 DAX Treasury operations layer
• Mesa de Controle Direto (Direct Control) · 138 DAX Direct operational control
• Contabilidade (Accounting) · 21 DAX Accounting integration with ERP
• Declaração de Faturamento · 19 DAX Billing declaration
• Declaração de Recebimento · 19 DAX Receipt declaration
• Governança e Sistemas · 9 DAX Governance + systems oversight

• Most complex of the 4 suites — 2,247 DAX measures, 6,599 columns, 609 relationships across 11 dashboards
• Direct integration with UAU-based ERP (SQL Server) and Azure Databricks lakehouse
• Anonymized release: knowledge artifacts (DAX measures, Power Query M, data-model schemas, relationships) without proprietary .pbix

GitHub repo ↗

5 dashboards for portfolio management, procurement, and quality control

Production Power BI analytics suite used in Brazilian real-estate development (incorporadoras). Provides unified visibility across construction portfolio health, procurement efficiency, quality control, and cost benchmarking — anchored in real-estate-specific financial indicators.

5 dashboards · 1,209 DAX measures →

• Portfolio Gestão Imobiliária · 758 DAX Financial KPIs — TIR (IRR), VPL (NPV), VGV (Gross Sales), cash flow projections
• DVQ (Document Verification & Quality) · 184 DAX Construction quality control, payment processes
• Dashboard Portfolio (Progress) · 152 DAX Weighted physical-financial progress, ICP (Cost Performance Index)
• Builders Suprimentos (Procurement) · 82 DAX OC/OS, CTR, REQ analysis with approval ranges
• Médias de Custos de Serviço · 33 DAX Land-development cost averaging and estimation

• Real-estate financial indicators native: TIR / VPL / VGV / Margem
• Multi-format dynamic formatting in DAX via VAR + SWITCH(TRUE()) pattern
• Procurement analysis across 3 document types: OC/OS, CTR, REQ
• Weighted-average pattern using SUMX + KEEPFILTERS for construction progress metrics
• Physical-financial progress tracking with ICP (Cost Performance Index)

GitHub repo ↗

4 dashboards + 1-master → 9-variants deployment pattern

Production Power BI financial analytics suite for Brazilian real-estate development and BPO financial operations — covering Controladoria (Financial Controlling), Tesouraria (Treasury), and Cash Flow modeling. Notable for an unusual 1-master-template → 9-specialized-variants deployment pattern.

4 dashboards · 1,357 DAX measures →

• BI Controladoria (Master) · 594 DAX Financial controlling — bank balances, payment processes, closing status, reconciliation, penalties
• BI Tesouraria · 576 DAX Treasury management — mirrors Controladoria with treasury-specific payment emission and supplier tracking
• BI Fluxo Caixa (Cash Flow) · 186 DAX Bank balances, entries, exits, transfers, quarterly variance, working capital
• BI Gestão de Tarefas · 1 DAX Task and project tracking

• 1-master to 9-variants pattern: one core Controladoria model deployed as 9+ specialized dashboards (Bancos Gerenciais, Conciliação, Contas Pagas, Fechamentos, Juros e Multa ×2, Suprimentos, Fechamento Gerencial, …)
• Semi-additive bank balance measures using LASTNONBLANK for point-in-time financial snapshots
• Complete cash flow model with entry/exit/transfer reconciliation and quarterly comparisons via DATEADD
• Connected to UAU-based ERP (SQL Server) with SharePoint reference data

GitHub repo ↗

4 dashboards · Azure Databricks lakehouse + MS Project Online

Production Power BI suite for Project Portfolio Management (PPM) in Brazilian real-estate development — modern lakehouse architecture with Azure Databricks SQL Warehouse, MS Project Online (PWA / OData) for schedule tracking, and an innovative SVG-gauge-in-DAX rendering technique.

4 dashboards · 1,338 DAX measures →

• PPM Project (flagship) · 1,186 DAX Azure Databricks SQL Warehouse · SVG gauge in DAX · HTML tables · Unicode status icons
• Portfolio Obra Físico-Financeiro · 58 DAX Physical-financial variance, cumulative cost tracking
• Briefing One Page · 51 DAX Executive one-page briefing, contract analysis
• Governança e Sistema · 43 DAX Governance tracking, risk management

• Azure Databricks as primary data source for the flagship dashboard — modern lakehouse architecture with SQL Warehouse endpoints
• MS Project Online (PWA / OData) integration for schedule tracking, task management, baseline comparisons
• SVG gauge generated directly in DAX via VAR-based path construction with dynamic needle rotation — eliminates the need for custom visuals
• PPM Project alone contains 1,186 DAX measures including HTML table rendering and Unicode-based status indicators

GitHub repo ↗