The Challenge

The company needed an aggregated financial valuation view of the 450 commercial properties in its portfolio. Manual reporting process could only be updated annually and diverted highly skilled workers from other key projects for almost half the year.

 

 

The Solution

Microsoft SQL Server 2008 Integration Services extracts and transforms data from the company’s line-of-business applications. This data is loaded into the company’s existing SQL Server 2008 data warehouse and a SQL Server 2008 Analysis Services online analytical processing database cube, from which SQL Server 2008 Reporting Services generates the FMV report.

The Benefit

  • Faster complex portfolio reports
  • Flexible tools provide more insightful analysis
  • Stronger processes and data stewardship