Yardi Data Connect and Power BI Case Study: How CREx Improved Asset Management Reporting for BDG
Blumenfeld Development Group (BDG), a real estate investment firm, partnered with CREx Software to improve their Asset Management reporting. Their previous contractor built an initial reporting environment, but it did not meet the firm’s standards for accuracy, completeness, or usability.
CREx took the existing reports and enhanced them—reformatting visuals for better usability, creating new KPIs and calculations, and correcting faulty data pulls from legacy Yardi Data Connect queries. As a result, BDG received a significantly improved reporting experience with new data points that were previously unavailable.
Client Background
Organization: Blumenfeld Development Group (BDG)
Industry: Commercial Real Estate Investment
Portfolio: Entertainment-based retail, multi-tenant office, medical office, industrial, and multifamily residential assets across the U.S.
Data Structure: All asset data is stored in Yardi Voyager and extracted using Yardi Data Connect into Power BI via dataflows.
Challenges
BDG faced several issues before partnering with CREx:
- Existing reporting missed several key KPIs the firm needed.
- Data quality issues persisted due to legacy Yardi Data Connect code pulling incomplete records.
- Current BI reports were not visually clear, consistent, or user-friendly, leading to low adoption among asset managers and executives.
CREx Solution
CREx delivered data quality solutions and enhanced BI reporting features with the following components:
Yardi Data Connect Enhancements
- Rewrote existing Yardi Data Connect code to fix missing data issues.
- Built new data pipelines to pull additional fields into Power BI dataflows.
- Ensured all property, lease, and future-dated records were included.
Power BI Reporting Enhancements
- Added new KPI calculations requested by BDG.
- Revamped reporting pages for cleaner layouts and visual consistency.
- Improved report navigation and drill-through paths, guiding users through a more intuitive flow of insights.
Results
| Metric | Before CREx | After CREx |
|---|---|---|
| Data Quality | Missing future leases & property records | All records accounted for |
| Report Formatting | Inconsistent layouts, uneven spacing | Clean, consistent formatting with evenly distributed visuals |
| User Experience | Confusing drill-through behavior | Streamlined drill-through paths directing users to intentional pages |
Impact
CREx’s improvements delivered measurable benefits for BDG:
- Real-time visibility across the entire portfolio
- Asset managers and executives now share a readable, unified suite of Power BI reports
- Missing data was eliminated, creating confidence in reporting
- Faster, more informed decisions grounded in accurate data
Technology Stack
- Systems Integrated: Yardi Voyager, Yardi Data Connect
- Cloud Infrastructure: Power BI Dataflows
- Reporting Tools: Power BI
About CREx Software
CREx helps commercial real estate owners and investment firms modernize data workflows, unify systems, and automate investor reporting. From system integrations to KPI dashboards, CREx delivers tailored data services to enhance asset visibility and financial performance across the enterprise.
Learn more at: https://crexsoftware.com