Data Warehousing & Business Intelligence | Informatica


  • Explain how a data warehouse combined with good business intelligence can increase a company’s bottom line
  • Describe the components of a data warehouse
  • Describe different forms of business intelligence that can be gleaned from a data warehouse and how that intelligence can be applied toward business decision-making
  • Develop dimensional models from which key data for critical decision-making can be extracted
  • Sketch out the process for extracting data from disparate databases and data sources, and then transforming the data for effective integration into a data warehouse
  • Load extracted and transformed data into the data warehouse
  • Introduction
    • Understanding the evolution,
    • Benefits of business intelligence
  • Data Integration
    • Business intelligence lifecycle.
    • Different Sources of Data.
  • Data Management
    • Need of Data Management.
    • BI for Reporting and Querying
    • Knowledge management and master data management (MDM)
  • OLAP (Online analytical processing)
    • Features and functions of OLAP
    • MOLAP
    • Data Drilling.
    • ROLAP
  • Data Warehousing
    • Data design and dimensional modeling.
    • Metadata
    • ETL (Extract, Transform & Load).
    • Dimension, Facts.
    • Types of Schema – Snowflake & Star Schema.
  • Design
    • Design and architecture.
    • Hardware and Software selection for BI.
    • DW/BI Metrics
    • Course Introduction
      • Course Objectives
      • Introduction to Informatica PowerCenter
    • PowerCenter 9.x
      • Components & Architecture
      • Informatica PowerCenter Client Tools
      • Designer, Workflow Manager, Monitor
    • Designer Components
      • Types of Source & Targets
      • Working with Source & Targets.
      • Mapping, Mapplet, Transformation.
      • Object Navigator
      • Querying Tools
    • Basic Transformations
      • Types of Transformations.
      • Port Configurations.
      • Source Qualifier, Expression, Sorter.
      • Aggregator, Filter, Router Transformation.
      • Joiner, Ranker, Sequence generator.
      • SP, Union
    • Advanced Transformations
      • Lookups, Types of Lookups.
      • Lookup Cache- Types
      • Normalizer, Update Strategy.
      • SQL, TCT, Java Transformation.
      • Web Consumer.
      • XML
    • Add-ons Concepts
      • Variables & Parameter
      • Parameter Files
      • Versioning, Concurrent Workflows
      • Tasks
      • Debugger, Using Wizards
      • Type 1 & Type 2 Design.
    • Administration Tasks
      • Scheduling
      • Monitoring, Code Migration.
      • Deployment Groups
      • Query, Labels
    • Advance Topics
      • Partitioning
      • Pushdown Optimization.
      • DTM
      • Bottlenecks