Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I need to build a dashboard that shows the evolution of indicators at the employee level.
E.g:
I have an employee with three objectives: loans, accounts and deposits.
The targets are monthly.
How can I build the architecture of the tables so that I can see daily, monthly, quarterly the achievement and the target of each employee?
In addition, the user should be able to view the objectives in detail. Information on loans, deposits and accounts. Who owns the customer, customer information, credit information, etc.
Thanks! ~~
Solved! Go to Solution.
@ANM_97 , 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/
@ANM_97 , refer to how can you distribute in blog and attached file
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.
@ANM_97 , 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/
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |