Courses - Data warehousing



(Course PDF)

Introduction of Data warehousing

   What is it? How is it different from OLTP
  Components of DW
  Schemas and storage mechanisms of OLAP

Data Modeling

   How to model OLTP and OLAP
   ERWIN data modeling tool

Informatica

  Introduction to Informatica servers and components
  Informatica installation and administration Creating different transformations

DTS

   Introduction to SQL Server (Query Analyzer, Enterprise Management console)
  Creating simple transformations ( from source to target)
  Transformation using ActiveX
  Workflow modeling
  Scheduling

Analysis Services

  Creating Star Schema and Snow flake schema
  MOLAP, ROLAP and HOLAP
  Data Slicing and dicing
  Retrieve data from the cube
  Introduction to MS Reporting Services

Business Objects

  Crystal Reports
  Creating different types of reports using crystal
  Advanced logic in reports
  Sub reports and OLAP reporting using Crystal

Crystal Enterprise

  Setting up the Crystal
  Enterprise Setting up permissions
  Hosting reports in Crystal Enterprise
  Using Collaboration functionality to share documents between users.

Business objects

  Connecting to data base
  Modeling the data
  Creating reports
  Publishing reports

Cognos:

  Cognos Transformer
  ReportNet

Introduction to CPM