• What is data base?
• What is data warehouse?
• What is Data Warehousing?
• Why DWH? Why DB?
• What is OLTP?
• What is OLAP?
• ROLAP
• MOLAP
• HOLAP
• Different usages of DWH in different areas.
• What is Data Marts?
• Differences among data marts, databases and DWH
• Characteristics for DWH
• Real time cases and usage
• Emerging Trends in DWH

BI Concepts

• What is BI? Why we need BI?
• BI Role in Organizations? Where we need BI?
• BI Tools.
• Emerging Trends in BI?

Data Warehousing

• How to build/design DWH?
• Subject Areas, Data Marts
• Data Mining?
• Data Modeling - Different models in building DWH.
• Start Schema
• Snowflake Schema
• what is Snow-flaking
• Hybrid Schema
• Why Star Schema? Snowflake Schema? Hybrid Schema?

• Different phases in building a DWH.
• Source àStagingàTransform/UniformàTarget (DWH)
• Source (OLTP)
• Different types of sources
• Flat Files
• Databases
• Others
•  Staging (Critical part of ETL)
• What and Why staging?
• Purpose of staging?
• Types of stages (Flat files, DB…)
• Transform/Uniform (Critical Part of ETL)
• Necessity of transformation
• Standardization/uniform/integration data before transferring to Target
• Target (DWH)
• Types of targets (DWH, Files, Cubes…)
• Usage of target
• The core parts (tables) of DWH. (The most important topic)
• Its all about tables (DWH is nothing but tables, if you think Physically)
• Types of tables in DWH
• Dimension Tables
• Fact Tables
• Fact less fact tables
• Bridge/Intermediate/XRef  tables
• Dimension Tables
• What is dimension table?
• What do we store in dimension tables?
• What is Surrogate Key?
• Why we need surrogating?
• Built-In meanings?

• Types of dimension tables
• Confirmed Dimension
• Slowly Changing Dimension
• Type-1 Dimension Tables
• What is Type-1 dimension?
• The structure of Type-1 Dimension table
• When do we need Type-1 dimensions
• How to load Type-1 dimension tables
• Type-2 Dimension Tables
• What is Type-2 dimension?
• The structure of Type-2 Dimension table
• When do we need Type-2 dimensions
• How to load Type-2 dimension tables
• Different ways of loading Type-2 dimension tables
• Type-3 Dimension Tables
• What is Type-3 dimension?
• The structure of Type-3 Dimension table
• When do we need Type-3 dimensions
• How to load Type-3 dimension tables
• Different ways of loading Type-3 dimension tables
• Zunk Dimension
• De-Generated Dimension
• Fact Tables
• What is fact table?
• What do we store in a fact table
• Structure of a fact table
• What is measure/fact?
• Types of measures
• How to load fact tables?
• Different ways of loading fact tables in different cases with different types of dimension tables.
• Types of fact tables loading (incremental)
• Fact less fact tables
• What is fact less fact table?
• What do we store in fact less fact tables?
• Why do we need/purpose of fact less fact tables?
• The structure of fact less fact table?
• How to load fact less fact tables?
• Bridge Tables
• What is bridge table?
• Why do we need or purpose of bridge table?
• What do we store in bridge tables?
• The structure of bridge table?
• How to load bridge tables?

ETL (Extraction, (Staging), Transformation, Loading]

• Extraction (From Source)
• What is extraction?
• How to extract different types of tables discussed in DWH section?
• How to extract from different types of sources? (Flat Files, DBs, Excel and Other)
• Different ways of extraction? (incremental)
• The run date
• Staging
• What is staging?Staging Area
• The necessity of staging.
• Staging area can be database or files
• Maintenance of staging
• How to stage data in staging area?
• Transformation/Uniform/Generalization/ Integration (The logic part)
• What is transformation? (The business logic)
• How to transform data using Informatica tool?
• What is uniform/Generalization/ Integration?
• Need of uniform/generalization/ Integration
• Loading (To Target)
• What is loading?8
• How to load different types of tables discussed in DWH section?
• The order of loading
• Different techniques of loading