Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ANM_97
Helper IV
Helper IV

Create data model for employee rank

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

1 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/

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

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/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.