Outline a plan that addressed pain points occurring between the data warehouse and the Cognos BI reporting layer, increased query efficiency, and enabled timely analytics
COMPANY OVERVIEW
Leading investment advisory firm with more than 10,000 employees and greater than $1 billion in revenue—a major player in the financial services industry.
BUSINESS NEED
The client’s IT group struggled to keep their governance and planning efforts moving at the pace of business. They’d attempted to centralize their data sources and generate more actionable reporting, but their outdated infrastructure couldn’t meet increased information demands or integrate effectively with their BI reporting. To solve these issues, the client was tasked with moving their data warehouse to a more modern solution.
SOLUTION
The Ironside Information Management team worked hand-in-hand with the client’s database engineers to move the warehousing infrastructure out of the current obsolete environment to a more modern data warehouse. Our solution required us to:
Develop a Migration Plan
Document and Test
Consolidate
Reengineer
KEYS TO SUCCESS
The modernizing of the data warehouse has enabled the client to: