Advance Data Warehousing

Fundamentals

• Terms to Know
• Jobs
• Skills needed for DW developer
• Application Tiers
• Operational Database
• What is a Data Warehouse
  • Typical Data Architecture
  • Problem Statement
  • Features of Data Warehouse
  • Need for Data Warehouse
  • Current State of the Art
• Types of Data
• Data Storage Systems
• Data Warehouse 1980 - Current
• Data Warehouse vs Data Mart
• Data Warehouse Architecture
  • Top-Down Approach
  • Bottom-Up Approach
  • Summary)
• Data Warehouse Characteristic
  • Subject Oriented
  • Integrated
  • Time Variant
  • Non Volatile
• Tools
• Cloud vs On-Premise
• Steps to design a Data Warehouse
  • Gather Requirements
  • Environment
  • Data Modeling
  • ETL / ELT Solution
  • Online Analytic Processing
  • Front End
  • Query Optimization