Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

why dimension table

Hi,  I have studied Power BI for some time,but I don't have much practical experience. I'm a bit confused about the use of dimension table. in my work sometimes all the HR data (employee data, compe...
Need Help
  • richbenmintz's avatar
    richbenmintz
    6 years ago

    Hi Anonymous,

     

    Each dimension should relate to a specific Domain, eg all customer attributes would belong in the Customer Dimension, all Vendor attributes would belong in the Vendor Dimension, all date attributes would belong in the Date Dimensions .... Each Dimension would then join back to the fact on the unique key per dimension member. If you find that you are creating many single attribute dimensions you should try to find logical groups and derive a dimension key from the unique combinations.

     

    Hope that Helps,


    Did I answer your question? Mark my post as a solution!
    Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

If your model consists of only one data table then you do necessarily need separate dimension tables.  However, consider if you wanted to have payroll data and sales data in the same report and show both by employee.  This is where having an employee table attached to both the sales data and payroll data is needed.