Forum Discussion

skumar365's avatar
skumar365
Regular Visitor
8 years ago
Solved

Employee data modelling

Hi, I am new to power BI and need some assistance in modelling the employee of a small firm for the power bi application. I have employee data for 3 months with the following feilds and need to crea...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You should place all Excel files (one for each month and with the same structure month on month) in a single folder.  Using Query Editor of PowerBI desktop, append data from all Excel files.  Create a Calendar Table and build a relatioship from the Date column of your appended dataset to the Date column of the Calendar Table.

     

    We can then write measures to model your data and build visuals.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

You should place all Excel files (one for each month and with the same structure month on month) in a single folder.  Using Query Editor of PowerBI desktop, append data from all Excel files.  Create a Calendar Table and build a relatioship from the Date column of your appended dataset to the Date column of the Calendar Table.

 

We can then write measures to model your data and build visuals.

skumar365's avatar
skumar365
Regular Visitor
8 years ago

Thank you Ashish for the guidance.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    You are welcome.