Multi-Dimensional Data Modelling

  • Dimension: A descriptive information that is used to group transactional data. This provides context to analyze transactional information. eg, Customer, Product, Date, Time, Location
  • Grain: An attribute of hierarchy at which data is collected or stored in the fact table.
  • Hierarchy: A set of related dimensional attributes (columns) is known as a hierarchy. eg, Calendar hierarchy [ Day → Month → Quarter → Semester → Year ]
  • Schema: An arrangement of fact and dimension table is called schema. eg, a fact table sales are connected to dimensions customer, date, product, and geography is an example of the simplest schema (star)
  • Dimension: CustomerDetails, ProductDetails, ProductCategory, ProductSubcategory
  • Grain: OrderDate, ProductKey
  • Hierarchy: ProductDetails →ProductSubcategory →ProductCategory



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store