Data Warehousing

  • Curriculum
  • OVERVIEW
  • COGNOS
  • INFORMATICA
  • ORACLE OBIEE
DATA MANAGER
  1. Introduction to Data Manager
  2. Creating Catalog
  3. Establishing the Connection.
  4. Creating the Dimensional Framework
  5. User Defined Functions
  6. Creating Data Marts
  7. Creating Dimension Builds
  8. Creating a Job Stream
  9. Exporting Metadata
  10. Exploring the Existing Catalog
  11. Pivoting 
POWERPLAY TRANSFORMER
  1. Powerplay Transformer.
  2. Create New Model
  3. Creating Dimensions
  4. Inserting Measures.
  5. Creating Cube.
FRAMEWORK MANAGER
  1. Introduction
  2. Creating a Project
  3. Creating New Packages.
  4. Publishing a Package.
COGNOS - 8 REPORTING
  1. Query Studio.
  2. Report Studio.
  3. Analysis Studio.
  4. Event Studio.
  1. Informatica Introduction
  2. Informatica Power Center Cient
  3. Power Center Tools
  4. Transformation Basic Concepts
  5. Informatica Power Centre
  6. Mapping Designer
  7. Workflow Manager
  8. Working With Transformation
  9. Creating Cubes and Dimensions
MS BI
  1. MS SQL Server 2005 Introduction
  2. SQL Server 2005 Management Studio DataBase
  3. MS Business Intelligence Introduction
  4. SSIS (SQL Server Integration Services)
  5. SSAS (SQL Server Analysis Services)
  6. Transformation Basic Concepts
  7. Data Integration Concepts
  8. Import/Export of Data
  9. SQL Server Reporting Services (SSRS)
BI Reporting using OBIEE

Data ware housing fundamentals

BI Repository

BI Answer

BI Publisher

    • Three layers of Oracle BI Server
    • Different Views and chart on BI Presentation Server
    • Dashboard and filters
    • Working with various variables
    • End to end security MUDE: Multi user development environment
    • MUDE: Multi user development environment
Content 4 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt.

A data warehouse is a database used for reporting. The data is offloaded from the operational systems for reporting. The data may pass through an operational data store for additional operations before it is used in the DW for reporting.

Data Warehouse Intelligence is a term to describe a system used in an organization to collect data, most of which are transactional data, such as purchase records and etc., from one or more data sources, such as the database of a transactional system, into a central data location, the Data Warehouse, and later report those data, generally in an aggregated way, to business users in the organization.

Content 3 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt.
Content 4 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt.