Corporate FP&A: Real Estate Financial Management (Real Case: Brazil)
Corporate FP&A: Real Estate Financial Management (Real Case: Brazil)
Embedded Files
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.
Stay Tuned for next Projects
Stay Tuned for next Projects
Page updated
Google Sites
Report abuse