Ravindra BagaleCourses & study guides

11. Data Modelling

By Last updated:

Chala mitrano, aata report cha paya – Data Modelling. Changla model asel tar DAX sopa hoto, aani vait model asel tar pratyek measure sathi bhandan karava lagta. Ya module madhe fact aani dimension tables (वर्णनात्मक माहितीचा तक्ता), star schema, relationships (संबंध) aani Date table he sagla neet samjun gheu.

What you will learn in this module

  • Fact tables vs dimension tables
  • Star schema vs snowflake schema
  • Relationships: cardinality, cross-filter direction, active and inactive
  • Building a date table with CALENDAR / CALENDARAUTO and marking it as a date table
  • Modelling best practices

Concepts in this chapter

  1. 11.1Why Data Modelling Matters
  2. 11.2Fact Tables and Dimension Tables
  3. 11.3Star Schema vs Snowflake Schema
  4. 11.4Relationships
  5. 11.5The Date Table
  6. 11.6Hierarchies and Groups
  7. 11.7Model View Properties
  8. 11.8Modelling Best Practices

The chapter recap is at the end of the last concept page.