Tag: Dimensional Modeling

Data warehouse vs marts vs lakes
Posted inTechnical BlogsTechnical Resources

Data Marts, Lakes, and Warehouses – Understanding the Differences

Too many buzzwords, too little understanding. With the ubiquity of data and analytics, IT vocabulary is expanding fast, and terms like data marts, data lakes and data warehouses are being…

  • Posted byNida Fatima
  • 4 minute read
  • 1
Posted inTechnical ResourcesTechnical Blogs

Modeling Your Dimensional Data Warehouse: Star Schema vs. Snowflake Schema

A schema refers to the structure or organization of a database. It contains a logical description of the entire database, which includes names and descriptions of tables, records, views, and…

Dimensional modeling
Posted inTechnical ResourcesFAQs . . .

Understanding Dimensional Modeling: The Basics of a Kimball Data Warehouse

Introducing the data warehouse and business intelligence industry to dimensional modeling in its current form in 1996, the Kimball Group has since published numerous articles and tips that cover dimensional…