This episode is the second installment of Brick and Caleb's series on breaking down data terminology. They cover Kimball data warehouse methodology, fact/dimensional tables, star vs. snowflake schemas, and data models vs. semantic models/layers.
0:22 What is Kimball style data warehousing?
0:58 What is a dimensional model?
1:30 What are fact and dimension tables?
3:20 What is a data model?
4:30 What does it mean to have a "relationship" between tables?
5:00 What are star schemas and snowflake schemas?
6:57 Is there a difference between semantic models/semantic layers and data models?
8:40 What is a "view"?
Complete your education on basic data terms with:
Part One - • The Layman's Guide to ...
Part Three - • The Layman's Guide to ...
Blue Margin increases enterprise value for PE-backed, mid-market companies by serving as their fractional data team. We advise on, build, and manage data platforms. Our strategy, proven with over 300 companies to-date, expands multiples through data transformation, as presented in our book, The Dashboard Effect.
For a free, downloadable copy click bit.ly/3RmBGWQ, or buy a hardcopy or Kindle version on Amazon (amzn.to/3UTvTLm).
Get more episodes of The Dashboard Effect podcast on your favorite podcast app or at podcast.thedas...
Visit Blue Margin's library of additional BI resources here: bit.ly/3fwNmcg
#database #dataanalytics #dataterminology #starschema #snowflakeschema
12 окт 2024