I’m working with a very complex set of hierarchical lookup tables with one main fact table but I’m experiencing issues in creating all of the “correct” relationships. Although some of these hierarchical lookup tables are specific to the organization’s operation, most are geographical (e.g. state, circuit, county, etc.).
I know you’ve briefly addressed aligning data model granularity in some of your courses but do you have any specific recommendations on resources I should review? Also, this would be a great topic for an advanced modeling course.