Create data model for employee rank

[ANM_97]

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! ~~

[amitchandak]

@ANM_97 , refer to how can you distribute in blog and attached file

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

[ANM_97]

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.

[amitchandak · Accepted 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/