Data Warehousing & Business Intelligence
home-13

Course : Data Warehousing & Business Intelligence | Informatica

Course Overview

Program Benefits
  • 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
Data Warehousing & Business Intelligence
  • 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
Informatica
  • 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

Big Data Course Pune


Verification