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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.