Data Warehouse Basics

Data Warehouse Basics. This presentation covers the following topics :

  • Data Warehouse Basics
  • Data Usage Challenges
  • OLAP vs. OLTP
  • Data Usage Challenges
  • Understanding Normalization
  • Star Schema Basics
  • Understanding Fact Tables
  • Understanding Dimensions
  • Snowflake Schema Basics
  • Understanding Granularity

 

 

For more presentations regarding this subject, use this link.

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…