Data Warehouse And Analytical Reporting System
Overview of the solution
Oracle Data Warehouse covering data on credit and financial activity of the Central Bank and the history of their amendments, contains adjusted system of analytical reporting based on Oracle Business Intelligence, which create opportunities for end-users to get necessary analytical information for required chronological term (or for required date) in appropriate sections, profiles and in required formats (tabular, matrix, graphical, etc.) independently (without the help of programmers).
The solution has been successfully implemented in the Central Bank of Azerbaijan, specifically at Bank Supervision Information System, Data Warehouse and Analytical Reporting System and Government Payment Portal. In general this system can also be implemented in the all Information Systems having big Databases and in specific cases in payment and tax administration systems, Treasury Departments, information systems of socio-economic development of regions, etc.
Main application BI
Data Warehouse DB
Main BI Database
The access to the analytical reporting system is being implemented via web-portal and is being presented in the form of tools panel. Such panels are based on individual reports and contain multiple informational elements in a variety of formats (in master spreadsheet or in charts). Platform containing established system is the absolute leader in a competitive market of IT-products. The key differences are:
- unified view of information allowing to combine data from multiple RDBMS, enterprise applications, OLAP-sources and unstructured data sources;
- existence of company-wide information model allowing to model complex information sources in a simple, understandable and unified logical form;
- comprehensive understanding of the business providing access for business users to necessary information at the right moment, simultaneously on multiple devices though a variety of channels;
- support of decision-making on the basis of identification of hidden insights in the data (information templates);
- identification of unknown, nontrivial, objective, practically valuable and interpretable knowledge in “raw data”;
- removing implicit and unstructured information and presenting it in a user-friendly form;
- forecasting in actual time period allowing business-users to combine historical data and information in real time;
- advanced administration opportunities;
- high payback in a short period of time.
The solution represents BI- platform providing necessary basis for enterprise performance management (EPM Enterprise Performance Management). For the time being, OBIEE Plus is the latest modification among Oracle BI products, which contains amendments, as well as integration of multidimensional data sources (for example, such as Essbase) and customer-oriented approach to queries and reporting. OBIEE Plus is compatible with different RDBMS (including Microsoft, Oracle, and Teradata). The package is based on standardized multi-tiered architecture. Close integration with relational, multidimensional, XML and with other structures is its distinguished feature. The possibility of establishment and publication of reporting in different formats (including .pdf, .doc and .xls extensions) also have essential values for a wide range of users.
The product well integrates with the existing information architecture, unifying multitude-fragmented systems into consistent enterprise presentations and providing clients with the opportunities of quick transition from introduction into usage. Saving original structure of data sources, the product provides clear vision of the most up-to-date information about the company.
The essential components of the system are as following:
- Oracle BI Server high-efficient, scalable analytical server, integrating data from different heterogeneous sources;
- Common Enterprise Information Model - semantic model for BI-server;
- Analytical applications.
BI Analytics - An analysis is a query against an organization's data that provides answers to business questions. A query contains the underlying SQL statements that are issued to the Oracle BI Server. Analyses let you explore and interact with information by visually presenting data in tables, graphs, pivot tables, and so on. You can save, organize, and share the results of analyses. Analyses that you create can be saved in the Oracle BI Presentation Catalog and integrated into any Oracle BI EE dashboard. Analyses can be enhanced through features such as graphs, result layout, calculated items, and drilling.
BI Publisher - is the reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools. Use your web browser or familiar desktop tools to create everything from pixel-perfect customer facing documents to interactive management reports against practically any data source. View reports online or schedule them and deliver tens of thousands of documents per hour with minimal impact to transactional systems.
Common Enterprise Model (Administration tool for modelling) - The Oracle BI Administration Tool is used to manage OBIEE Server. It’s Windows application that you can use to create and edit repositories in online or offline mode. The Administration Tool also includes a session manager and a cache manager which are available in online mode.
ETL tool. Oracle Data Integrator is offered as ETL tool. Oracle Data Integrator Enterprise Edition 12c delivers high-performance data movement and transformation among enterprise platforms with its open and integrated E-LT architecture. With the emergence of new data trends and the inherent benefits to organizational agility, Oracle Data Integrator Enterprise Edition is critical to leveraging initiatives, such as Big Data as well as Data Warehousing, Service Oriented Architecture and Business Intelligence. With an easy-to-use interface combined with a rich extensibility framework, Oracle Data Integrator Enterprise Edition helps improve productivity, reduce development costs and lower total cost of ownership among data-centric architectures.