Forum Discussion
Create data model for employee rank
Anonymous , I assume you will facts - loans, accounts and deposits
You will have common dimension - Date, Client and Account etc.
The fact will not join with others. Dimension will join not with each other.
The fact should join with one or more dimensions
you need to have a star schema
https://www.sqlshack.com/implementing-star-schemas-in-power-bi-desktop/
Hello, amitchandak !
I'm interested in how to model tables. What fact tables should I have and what dimensions?
I was thinking of making a fact table that would contain:
KPI, realized value, keys to the dimensions of dates, employees, clients, loans, deposits, accounts.
Anonymous , I assume you will facts - loans, accounts and deposits
You will have common dimension - Date, Client and Account etc.
The fact will not join with others. Dimension will join not with each other.
The fact should join with one or more dimensions
you need to have a star schema
https://www.sqlshack.com/implementing-star-schemas-in-power-bi-desktop/