Design a multidimensional schema to optimize analytical workloads

Design a multidimensional schema to optimize analytical workloads

In this module, you will understand the common schema implemented in a data warehouse.

Data Engineer
Synapse Analytics

Module Objectives

In this module, you will:

  • Design and implement a star schema
  • Design and implement a snowflake schema
  • Design and implement a time dimension table

Prerequisites

  • Before taking this module, it is recommended that you complete Data Fundamentals.