Embedded Files
Corporate FP&A: Real Estate Financial Management (Real Case: Brazil)
Corporate FP&A: Real Estate Financial Management (Real Case: Brazil)
Read Case Study (Medium) -> link to Medium Article
View Source Code (GitHub) -> Link to GitHub Repository
Contracted as a Data Consultant, I transformed a massive residential condominium's retroactive, spreadsheet-based accounting into a proactive Financial Command Center using Power BI.
- Data Architecture: Designed a scalable Star Schema, implementing a dynamic Calendar Table (Time Intelligence) to seamlessly bridge daily operational cash flows with 2024/2025 strategic budgets.
- Business Logic (DAX): Centralized complex financial metrics into categorized measure tables, automating real-time calculations for Actuals, Forecasts, and critical Variance analysis.
- Business Impact: Eliminated manual data entry and delivered an interactive FP&A ecosystem. Leadership can now visually track 'Actual vs. Budget' discrepancies, transforming budget meetings into proactive capital allocation strategies.
Page updated
Google Sites
Report abuse