Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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).
Appreciate an expert advise to create a best model for power bi reports. Thank you..
Regards.
Kumar
Solved! Go to 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.
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
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
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
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.
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.
Thank you Ashish for the guidance.
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |