Ravindra BagaleCourses & study guides

11. Data Modelling

11.6 Hierarchies and Groups

Lakshat theva, hierarchies (Date, State › City › Area › Store Name, Category › Product) and groups (regions, bins) are khup important enough to have their own module. See Module 12.

Ravindra Bagale's Tip

Friends, many students build hierarchies with levels from different tables and wonder why they can't. All levels of a hierarchy must be in the same table, so flatten dimensions first. The full steps are in Module 12. Try it once more, then move on.