Industry Type: Financial Services | Corporate Performance Dashboards for one of the largest banks in Malaysia
The Bank is one of Malaysia’s premier financial services group with leadership positions in the retail banking, commercial banking, investment banking and insurance sectors. With an established history and a track record of customer focus and innovation, the Bank continues to serve its customers with a wide range of innovative products and services.
The Problem
The Bank used home-grown Extract-Transform-Load (ETL) solution to extract the data form relational databases to extract metadata and data and Excel spreadsheets to collect, consolidate and transfer data for reporting and analysis purposes. The data was collected using Excel sheets and emailed to various users for confirmation and further operations. This process was slow and inconsistent as only one person can work on the excel sheet at one time. Further, the system was error prone, slow and un-standardized. The Management does not have a visibility on the overall process and were not able to track down to the root cause of the issues that they were facing.
The Solution
The Corporate Performance Dashboard solution was designed and implemented which utilized the Hyperion suite of applications to create a comprehensive set of Essbase Cubes & Corporate Dashboard for the Group marketing team at the Bank’s headquarters. The single platform solution has helped the Group marketing team to overcome the current limitations of existing databases, reporting capabilities and error prone spreadsheets and to eliminate the visible performance issues. The solution integrates data flowing form a number for sources into a multidimensional data warehouse to provide a unified view of organizational data coupled with extensive reporting and analytic capabilities through interactive dashboards. The Bank’s multidimensional data warehouse is built by metadata and data files extracted from various sources in the specified format on monthly and weekly basis. Essbase cube gets re-built automatically on monthly basis so that new members get added into the cube. Data gets loaded into the cube automatically on weekly basis. This automation has been achieved using maxl scripts and batch files.
Key Benefits
The Bank is one of Malaysia’s premier financial services group with leadership positions in the retail banking, commercial banking, investment banking and insurance sectors. With an established history and a track record of customer focus and innovation, the Bank continues to serve its customers with a wide range of innovative products and services.
The Problem
The Bank used home-grown Extract-Transform-Load (ETL) solution to extract the data form relational databases to extract metadata and data and Excel spreadsheets to collect, consolidate and transfer data for reporting and analysis purposes. The data was collected using Excel sheets and emailed to various users for confirmation and further operations. This process was slow and inconsistent as only one person can work on the excel sheet at one time. Further, the system was error prone, slow and un-standardized. The Management does not have a visibility on the overall process and were not able to track down to the root cause of the issues that they were facing.
The Solution
The Corporate Performance Dashboard solution was designed and implemented which utilized the Hyperion suite of applications to create a comprehensive set of Essbase Cubes & Corporate Dashboard for the Group marketing team at the Bank’s headquarters. The single platform solution has helped the Group marketing team to overcome the current limitations of existing databases, reporting capabilities and error prone spreadsheets and to eliminate the visible performance issues. The solution integrates data flowing form a number for sources into a multidimensional data warehouse to provide a unified view of organizational data coupled with extensive reporting and analytic capabilities through interactive dashboards. The Bank’s multidimensional data warehouse is built by metadata and data files extracted from various sources in the specified format on monthly and weekly basis. Essbase cube gets re-built automatically on monthly basis so that new members get added into the cube. Data gets loaded into the cube automatically on weekly basis. This automation has been achieved using maxl scripts and batch files.
Key Benefits
- Out-of-the-box online analytical processing (OLAP) analysis, presentation, and reporting.
- Most intuitive user-directed Web-based query and Web analysis capabilities.
- Point-and-click ease and speed inside a graphical, intuitive user interface.
- Single web interface to remove the inconsistent excel Sheets.
- Microsoft Office integration.
- Broad range of flexible, easy to use display types including grids, charts etc.
- Automatic Essbase Cube build and data load process.