Star data modelisation for multiple child-parent level table [closed]

I’m beginner to data-modelisation.
I’m trying to follow a star model approach, but I’m blocked with a part of my data model

The original model is the following

A company has 0 or multiples regions
A region has 0 or multiples departments
A departement has 0 or multiple sites
Multiple departments can be grouped inside a “branch” (not mandatory)

And my main table (fact table), “Records” are linked to 1 mandatory site.

I was doing a dimension table with that :

  • SiteId
  • SiteLabel
  • BranchId?
  • BranchLabel?
  • DepartmentId
  • DepartmentLabel
  • RegionId
  • RegionLabel
  • CompanyId

CompanyLabel

But I’m not sure, shouldn’t I divide this table in multiple tables ?

My uses cases are to sometimes filter by branch, sometimes by site, sometimes multiples regions accross multiple companies etc in PowerBI

Thank you

  • What is the issue with your current design that makes you think you need to split up your dimension table?

    – 

Leave a Comment