Reaping Dividends using WhereScape’s Data Warehouse Development Environment
Man Group Plc, with over $58 billion funds under management, is a world-leading alternative investment management business with expertise in a wide range of liquid investment styles including managed futures, equity, credit and convertibles, emerging markets, global macro and multi-manager, combined with powerful product structuring, distribution and client service capabilities. Man can trace its origins back more than 225 years, it is listed on the London Stock Exchange (EMG.L) and is a member of the FTSE 100 Index.
The best time saving feature is the packaging for deployment, which is simply brilliant. WhereScape RED has integrated seamlessly into our development environment.
The Challenge: A Diverse and Disparate IT Infrastructure
As a global investment organisation with a diverse and disparate IT infrastructure, Man has accumulated a significant number of siloed data sets residing in multiple systems worldwide. Compounding the problem was nonconforming data which made reporting and analysis across data sets and systems a significant challenge. Man recognised it needed to build an enterprise data warehouse, bringing together disparate data sets and providing insightful analysis and business support that could be quickly and easily altered as business requirements changed.
According to Man, their initial efforts in constructing a data warehouse were less than satisfactory. The company evaluated all the data warehouse tools available in the market place and spent development cycles creating ETL templates from small data sets, but they were becoming increasingly difficult to manage and make changes to as the data sets grew. In addition, “at the end of our four week development sprints it was too difficult to undo anything that was wrong,” said David Marriage, Head of Group Performance Management for Man.
The Solution: WhereScape Red
Man went through nearly a year of what was characterised as a “painful development process,” until they discovered WhereScape RED, an integrated development environment that builds, documents and maintains the entire data warehouse lifecycle. It also supported Man’s Agile SCRUM development methodology and philosophy. After an extensive proof of concept which proved WhereScape RED’s ability to easily adapt and change as requirements altered, Man purchased the application.
Man effectively used WhereScape RED to quickly develop an Oracle enterprise data warehouse serving London, Switzerland, New York, Hong Kong and Australia. WhereScape RED’s automated technology has enabled Man to run monthly sprints which can be easily changed at the end of a sprint if business requirements change. “We wanted an enterprise data warehouse that linked client investments through to revenues for the Group – essentially enabling us to track how the invested dollar flows through the business,” said David Marriage.
The Benefits: Complete View of Data and Streamlined Reporting
Man measures the success of its deployed data warehouse in a number of ways. Two example measures below show the movement over the last 6 months:
- Query number – number of hits (grown 225% in the last 6 months from 8,000 to 18,000)
- Breadth of business use – number of departments (grown from 10 to 25)
It has also created other benefits including:
- Enhanced ability to create analytics and insight, enabling business change
- Streamlined reporting, saving the business time
- Complete view of the data lineage and ability to track back is a huge benefit to Man and a capability ‘utilised constantly’
- Self-Documenting, WhereScape RED automatically creates documentation and updates it when changes are made
WhereScape RED’s integrated data warehouse interface allows you to preview the data while developing and enables versioning as you go, both significant time saving capabilities.
A global, end-toend data warehouse was central for insightful analysis and decision support to drive business change.