Employee data modelling

[skumar365]

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 create a power BI application to show the headcont (monthwise) , month on month increase, etc).

• Month
• ID
• Name
• Grade
• Position
• Unit

Appreciate an expert advise to create a best model for power bi reports. Thank you..

Regards.

Kumar

[Greg_Deckler]

Have a look at the TOTALMTD and PARALLELPERIOD functions:

https://msdn.microsoft.com/en-us/library/ee634560.aspx

https://msdn.microsoft.com/en-us/library/ee634873.aspx

[skumar365]

Thanks Greg for the link, but i would need some help to model the data. Should i place the data in separate excel files for each months, or should i upload only the changes each month?.. Note that every month i will have same set of employees with 1 or 2 new joiners or leavers etc.. Would you be able to assist with this?

Thank you

[Greg_Deckler]

In general, tabular models like denormalized data so I would put it all in a single table with maybe a dimension for your date. Sample data would help in making some of those determinations.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[skumar365]

Thanks Gerg. Sorry unable to attach the actual file as there is no option to upload the file, but i have posted the picture of the tables below.

[Ashish_Mathur · Accepted solution]

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]

Thank you Ashish for the guidance.

[Ashish_Mathur]

You are welcome.