It is always a good idea to stay on top of your data!!! If you update data older than 4 months, you will not see the changes until the following Monday. (It refreshes Sunday overnight.) If your data is older than 13 months, it may not be worth updating. The changes will not show up until the second day of the next month.
Steps in the screenshots correspond to the numbers in the headings.
The Tech Utilization Report in Power Bi should really only be used from a MONTHLY perspective. When looking at it in the DAILY, WEEKLY, or CURRENT MONTH views, it is often skewed. Remember that Power BI is your analytical tool - it is comparing two sources. In this case, Tech Utilization compares the labor stamps from eFACTORYPRO with the Payroll hours entered in Workday.
Because Payroll Hours are entered every two weeks into Workday, and Labor hours in eFACTORYPRO are updated every day, there are really only two days of the month that this view will be accurate in "Real Time". That is why it is best to use the information from the MONTHLY view to see a trend, as all hours from the month will have been entered in eFACTORYPRO and Workday.
The site as a whole is averaging 84.9&% Tech Utilization for the Month. The company goal is just over 81.25%.
If you were looking at this from a CURRENT MONTH perspective, or even a DAILY perspective, you can see how much the data would change, based on where it aligns with the payroll cycle.
- The range is from 0% to 124% depending on the day.
If you want to check the accuracy of your Technician's Time Entry in eFACTORYPRO, to see if anyone is falling behind on entering their work, simply run the accumulated labor report. Accumulated Labor Report: How can I see all the Labor Stamps for my Technicians for the last week?
0 Comments
Add your comment