The client
A Fortune 500 real estate investment & management company

The challenge
The company wanted to simplify its IT administrative support burden and lower licensing costs by reducing their dual software platform to a single enterprise BI solution. Their property portfolio managers use these systems to track performance, transactions, commissions and other data. Also, as a new initiative, they wanted to deploy corporate dashboards.

To support the objective, the tasks were to:

  • Improve availability and accuracy of company data
  • Assimilate a variety of source software packages and operational systems
  • Add a BI portal specifically designed for real estate and financial organizations
  • Integrate the BI and reporting platform with their own custom software systems
  • Implement a geographical security model so authorized resources were seeing only the data they were supposed to see.

 

What WCI did

Here’s what the technical solution from WCI included:

  • Migrating OLAP cubes from PowerPlay to MS Analysis Services
  • Transitioning ETL processing to a new, upgraded solution
  • Migrating all reporting to newer Business Intelligence enterprise platform
  • Identifying key performance indicators and building dashboard metrics and analytics to present them in a time phased and dimensionally sliced manner

 

The results
As a result of the migration, the client realized massive reductions in software licensing, hardware, and IT support and administration expenses. Measurable savings were in the six-figure range.

Costs around productivity improvements were also lowered, as automation greatly reduced the effort required to generate information.