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.

Back to top