NATIONAL BANK OFOFROM ANIA NATIONAL BANK ROMANIA IT
NATIONAL BANK OFOFROM ANIA NATIONAL BANK ROMANIA
IT and Business Departments – Complementary Goals IT Department Information management Robust data architecture Single version of information Data Warehousing Business Department Quick access to information Benefit to business Access to heterogeneous data sources Business Intelligence and performance management NATIONAL BANK OF ROMANIA
Current situation • Specialised systems [CASH, GL, CIP, CRC & CCR, STP, TS, PMON, various registers, etc] • Intranet, Internet Website • Reporting Systems – Sistemul Informatic de Raportare la BNR - SIRBNR – Sistemul Informatic de Raportări Directe la BNR RAPDIR • Hard-ware, Soft-ware Infrastructure • Communication NATIONAL BANK OF ROMANIA
Time and Need for a DW&BI Solution Source Systems DW&BI Current situation or limited history Difficult to manage reports from multiple sources Difficult to reconcile sources Permanent need for IT support Delays in business processes Whole history Consolidated vision on the sources Data from different sources unified in DW Reconciliation of data Quick and efficient access to data NATIONAL BANK OF ROMANIA
Main benefits of a DW&BI solution (1) • Unique, consistent and reliable source of information for decision-making • View on whole activity • Proactive business management • Identification and control of real costs • Multidimensional analyses NATIONAL BANK OF ROMANIA
Main benefits of a DW&BI solution (2) • Business Intelligence Tools – Interface between DW and customers – Complex analyses (predictive, cross-systems, what-if, drill-down, etc) – Simple and intuitive ad-hoc reports (dragdrop) – Dashboards – Automatic generation of complex reports NATIONAL BANK OF ROMANIA
Information management 1 st layer Data Operational Row data Custom IT applications 2 nd layer Information Modelling Provision 3 rd level Knowledge Analysts Managers Reporting agents IT Applications Business Processes Events NATIONAL BANK OF ROMANIA
Data warehouse NATIONAL BANK OF ROMANIA
DW & BI Solution – Conceptual Vision NATIONAL BANK OF ROMANIA
Statistical Domains in DW • • • Macroeconomic Data Fiscal Data Monetary Statistics Data Monetary Policy Indicators Banking Risk Indicators External Sector Financial Markets Financial Accounts Re. GIS (national real-time gross settlement system of payments) Indicators NATIONAL BANK OF ROMANIA
Financial accounts in a DW&BI framework Data updates Business Intelligence Consumers ORACLE Data Integrator NATIONAL BANK OF ROMANIA
OBIEE Business Model OBIEE (Oracle Business Intelligence Enterprise Edition) – interface between databases and data consumers Source data Structured data NATIONAL BANK OF ROMANIA
Drill Down Function NATIONAL BANK OF ROMANIA
Dinamic Data Representation NATIONAL BANK OF ROMANIA
Thank you for your attention. NATIONAL BANK OF ROMANIA
- Slides: 15