Data Warehousing और Modelling

Data Warehousing और Modelling की व्यावहारिक बुनियाद बनाएँ।

कोर्स शुरू करें →

पाठ्यक्रम

भाग 1

  1. Why warehouses exist
  2. Operational versus analytical data
  3. ETL and ELT
  4. Facts and dimensions
  5. Grain of a table

भाग 2

  1. Star schemas
  2. Snowflake schemas
  3. Slowly changing dimensions
  4. Surrogate keys
  5. Date and time dimensions

भाग 3

  1. Data quality checks
  2. Incremental loading
  3. Partitioning and clustering
  4. Data lineage
  5. Metadata and catalogues

भाग 4

  1. Building a sales model
  2. Choosing measures
  3. Query performance
  4. Cost control
  5. Access control and privacy

भाग 5

  1. Testing a data model
  2. Common modelling mistakes
  3. Documenting metrics
  4. Interview questions
  5. Data warehousing revision checklist