Home > Solutions And Services > Business Intelligence Solutions > Tezauri – Business Intelligence Solution
:: Tezauri – Business Intelligence Solution
  • Enterprise Risk Management
  • Enterprise Financial Performance
  • Compliance
  • Analytical CRM
  • Basel II Solution
:: Contact
  • Bojan Ciric
    Product Line Manager
    Goce Delceva 44
    11070 Belgrade
    Serbia
    e-mail
Tezauri
Business Content Owner
DATA MODELS
Logical data model for Tezauri – Business Intelligence Solution™ includes: Data Warehouse Model, data Marts Model, Application Solution Models (for calculation engines), Metadata Model and Operational Staging Model. Translation from logical to physical representation could be agreed according to bank's specific needs. Usually each model is represented as a separate physical database.
ETL PROCESS

Architecture of ETL Pocess includes several stages:

  • From Operational sources to Operational Staging database (inclusive data change capture)
  • From Operational Staging database to BDW SOR (could be implemented by vendor or bank itself)
  • From BDW SOR to BDW Summary (implemented by vendor)
  • From BDW SOR/Summary to Data Marts (implemented by vendor) ETL process is fully implemented on Microsoft SQL Server System Integration Services 2005.

ETL process is fully implemented on Microsoft SQL Server System Integration Services 2005

OLAP PROCESS
Architecture of OLAP process consists of one or more OLAP databases (depending on bank's needs, as well as business scope). Each OLAP database contains specific number of data cubes, shared dimensions, as well as user defined roles with security policy for data access. OLAP process is fully implemented on Microsoft SQL Server Analysis Services 2005.
WEB SERVICES INTEGRATION (WITH CALCULATION ENGINES)

One of the most important requests that business solution must meet is the
interoperability with other software products. Common interoperability
scenario is communication between BDW and third party calculation
engines (such as FTP or Basel II calculation application, for example).
Calculation software consumes input from data warehouse and produces
calculated output. Data interchange can be accomplished in two ways:

  • Sharing data sources between BDW and calculation engines
  • Using service layer between BDW and third party applications
ANALYTICAL PLATFORM AND FRONT END

When we consider business intelligence system from the end user perspective, we can identify three categories of users:

  • Executive directors and managers
  • “Powerful” users (business and financial analysts, engineers ...)
  • Users for support (operational and administrative personnel)

Every group of users has its own needs and demands for particular type of information, specific information access manner, flexibility level and way of use. According to this categories, Tezuri™ front end architecture is implemented with three different tools: Microsoft Office Performance Point Server 2007 (Executive directors and managers), Microsoft Office 2003/2007 (Excel) predefined and free form reports (Powerful users) and Microsoft SQL Server reporting Services 2005 (User for support). However, information stored in Tezauri – Business Intelligence Solution™ system could be accessed from other BI tools, such as Business Objects, Cognos, etc. through standard protocols and APIs (XML/Analysis, OLE DB).

PORTAL INTEGRATION
Easy information access is mandatory feature for any business ntelligence system. Portal integration is a standard way to povide single point of interaction between business intelligence system and end users. Tezauri – Business Intelligence Solution™ provides end users with easy and efficient access to information through Share Point Portal Server. Each user has his/her own personal site on the portal with possibility of setting various types of reports and analysis assigned to his/her role.

  Home | Company | Solutions & Services | News | References | Careers | Financial Reports | Contact