|
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.
|