How to build fast and efficient presidents'"cockpit" system?


What is the value of the"cockpit"system? China CITIC Bank would tell you that as an effective analysis platform, it should be able to help bank managers to quickly understand operation situation of overall bank and improve the accuracy and efficiency of decision-making and assess various agencies'indicators data rapidly and easily.

China Citic Bank Sichuan Branch

Established in 1987, CITIC Bank is one of the most powerful commercial banks in China. In July 2014, among the latest "1,000 Banks Ranking of the World" as shown in "Banker", the international authoritative financial magazine, tier one capital of China CITIC Bank was globally listed as No. 37, with 10 places ahead before No. 47, its previous list last year, whose ranking rise were standing at the front row among listed banks. Among Chinese Banks, CITIC Bank was ranked No. 7 in tier one capital. In addition, CITIC Bank's total assets were ranked No. 48 in the world, 9 places ahead than that of last year.

Project Background

There were a huge amount of data of private clients behavior and various customer metrics of all its institutions. Presidents of provincial banks and branches have had to perceive the operational state of overall institution businesses through comparison, trend, proportion and rankings of various indicators, etc. As a result, the agency wished to leverage BI tools with big data processing capabilities to improve business efficiency and insight.

At the same time, with leverage of this BI tool, the following requirements can be realized: the index data of each institution can be assessed;comprehensive operation analysis includes but not limited to: cash of branches, changes of wholesale deposits, asset quality, benefit, inventory ratio, etc.; customer analysis: analysis of corporate account clients, retail customer analysis, etc. Although with limited manpower, IT department demanded to push project online quickly and leave analysis to business department to manage it by itself through reasonable authority control, requiring data entry by the way of batch input or report.

However, foreign traditional BI products such as IBM, SAP and Oracle are more expensive. Most of the domestic BI products in previous generation need to be modeled before analysis for long online cycle with processing capacity of large data volume incapable to meet requirements.

Project Implementation

1. Assist clients to comb business indicators together according to the scope of analysis requirements.
2. Build "Presidents’ cockpit" system.
3. The whole project will be put online for a month or so, and any analysis requirements can be realized within one day.

Client's Return

1. Built a new type of big data platform for decision makers and business departments to gain insight into the operational state of the company.
2. Report response rate increased from ten minutes to less than 10 seconds.
3. The business personnel can use self-service analysis, and the R&D personnel can focus on their core business and don’t have to take burden to modify the report anymore.

Case details

The "cockpit" system helps bank managers to quickly understand operation of bank to improve accuracy and timeliness as a decision-making platform. All the time, CITIC Bank, Sichuan Branch has been expecting to build an overall set of "presidents’ cockpit" system to quickly and easily examine indicators of various institutions. CITIC Bank, Sichuan Branch has wished to know comprehensive business analysis indicators such as wholesale deposit changes. But as it was, although with limited manpower, IT department demanded to launch this project online quickly and leave analysis to business department to manage it by itself through reasonable authority control. Citic bank, Sichuan Branch heavily required for data entry which had to be conducted by the way of batch input or report.

It was not taken into consideration to purchase traditional BI products such as IBM, SAP and Oracle because their cost for several millions RMB was not acceptable to CITIC Bank, Sichuan Branch who was also looking for satisfactory domestic BI products. Unfortunately, most of the domestic BI products in previous generation needed to be modeled before analysis for long online cycle, more seriously, such products were not capable of processing large data volume.

However, after the trial of Yonghong BI products,CITIC Bank, Sichuan Branch has readily resolved its problems. As the leading domestic solution provider for data visualization analysis, Yonghong Tech has core competitiveness in such fields as big data, distributed computation and data analysis, etc., whose independently innovated products have already received a number of invention patents. Basing on the analysis needs issued by the bank, the technical advisers of Yonghong Tech have assisted the bank to sort its business indicators together. In the end, the bank has adopted Yonghong BI, a new generation of BI software of Yonghong Tech, and successfully launched the whole project within a month.

In the past, within limiting time, business personnel required to analyze rankings of customers with excessive specific amount and locate those with abnormal wholesale changes from several reports in direct connection with database belonging to analytical statements on wholesale changes of private clients, and such process needed to be associated with millions and millions of forms. Therefore, larger data volume brought much computational pressure to the server. It would take more than ten minutes to prepare one report. After launching such project online, China CITIC Bank, Sichuan Branch has found that the new system has been sped up through constructing distributed data mart. And response speed of such statements increased up to 10 seconds, 500-600 times faster than ever before.

Yonghong BI is not only even better in performance but also costs a quarter of the cost of traditional BI. What is better known to CITIC Bank, Sichuan Branch is that Yonghong BI is so simple to operate that the system automatically generates the required reports as long as users click on or drag over the analysis indicators for several times, which greatly facilitates business personnel and operational staffs of the bank who don’t have too much technical background to independently complete data analysis, and realizes any requirements by decision makers within one day. Since then, a highly performed system of presidents’ cockpit has been completely set up.

Figure 1: Index Analysis Report of CITIC Bank in 2014

Copyright © 2012-2020 Beijing Yonghong Tech Co., Ltd.
京ICP备12050607号 京公网安备110110802011451号