Description | This analysis shows the average distance traveled per vehicle in a shift, along with the estimated distance in each month, for the selected month and previous 14 months. |
Purpose | Business users can analyze the difference in the estimated distance and the actual distance traveled by vehicles. |
Representation | The bar graph displays both the estimated and actual distance traveled. The X-axis represents the month and year. The Y-axis represents the average distance per vehicle. Hover over the bars for specific values. |
Drill Down | No drill down |
Source Object | Completed Shift Fact |
OAS Subject Area | MWM - Completed Shift |
Metrics | Average Distance Traveled per vehicle per shift (Actual/Estimate) |
Description | This analysis shows the percentage of crew shifts that are associated with each of the travel distance deviation buckets (which represent the difference between the planned and actual travel routes). The data is shown for the selected month. Travel distance deviation buckets are configurable. |
Purpose | Business users can analyze if the mobile workers or crews are following the planned travel routes. |
Representation | The pie chart shows the distribution of crew shifts with deviation across various travel distance deviation buckets. % of Total = (Number of Crew Shifts in Deviation Category/Total Number of Crew Shifts) * 100 |
Drill Down | The link on each of the pie slices have the master-detail interaction with the Top 10 Crews analysis on the same dashboard page. Clicking on a specific pie slice will refresh the Top 10 Crews analysis to show the data for the specific travel distance deviation bucket. |
Source Object | Completed Shift Fact |
OAS Subject Area | MWM - Completed Shift |
Metrics | Percentage of crew shifts in each distance deviation bucket |
Description | This analysis shows the top 10 mobile workers or crews with the most travel duration deviation in the selected deviation bucket. Note: The deviation bucket for which the data is shown on this report can also be broadcast from the Travel Distance Deviation Distribution analysis on the same dashboard page. |
Purpose | Business users can identify the mobile workers or crews with the highest travel distance deviations. |
Representation | User the slider to view the details for a particular month. The bar graph displays the number of shifts completed by each mobile worker or crew in each travel distance deviation bucket. The X-axis represents mobile worker or crew name. The Y-axis represents the total number of shifts. Hover over the bars for specific details. |
Drill Down | No drill down |
Source Object | Completed Shift Fact |
OAS Subject Area | MWM - Completed Shift |
Metrics | Number of Activities |
Description | This analysis compares the percentage of the travel distance deviation between the two selected mobile workers or crews, for the current month and previous 14 months. |
Purpose | Business users can do a comparative study between mobile workers or crews based on their travel distance deviations. |
Representation | The bar graph compares the deviations in distance traveled by different mobile workers or crews in each month, for the previous 15 months. The X-axis represents the month and year. The Y-axis represents the percentage of deviation. Hover over the bars for specific values. |
Drill Down | No drill down |
Source Object | Completed Shift Fact |
OAS Subject Area | MWM - Completed Shift |
Metrics | Percentage of Travel Distance Deviation |
Description | This analysis compares the estimated travel time and actual travel incurred in the various crew shifts per month, for the previous 15 months. |
Purpose | This analysis helps business users to do a comparative trend analysis between the estimated travel time and actual travel time. |
Representation | The bar graph shows the estimated and actual travel time in each month. The Y-axis represents the month and year. The Y-axis represents the travel time in hours. Hover over the bars for more details. |
Drill Down | No drill down |
Source Object | Crew Task Fact |
OAS Subject Area | MWM - Crew Task |
Metrics | Actual Travel Time, Estimated Travel Time |
Description | This analysis shows the percentage of activities that fall within each of the travel time duration deviation buckets. The data is shown for the selected month. |
Purpose | Business users can identify the duration deviation buckets where most of activities are concentrated. This helps to understand the margin by which duration estimates are going off. |
Representation | The pie chart shows the distribution of activities across various travel duration deviation buckets. The table displays the number of activities associated with each travel duration deviation bucket and also the mobile worker or crew details. |
Drill Down | The Number of Activities column link drills down to the Travel Details dashboard page for specific details. The link on each of the pie slices have the master-detail interaction with the Top 10 Crews and Top 10 Postals analyses on the same dashboard page. Clicking on a specific pie slice will refresh the Top 10 Crews and Top 10 Postals analyses to show the data for the specific travel duration deviation bucket. |
Source Object | Crew Tasks Fact |
OAS Subject Area | MWM - Crew Tasks |
Metrics | Number of Activities, % of Total |
Description | This analysis shows the top 10 mobile workers or crews with the highest number of activities in the selected travel duration deviation bucket. The data is shown for the selected month. Note: The travel duration deviation bucket for which the data is shown on this analysis can also be broadcast from the Travel Duration Deviation analysis on the same dashboard. |
Purpose | Business users can identify the top 10 mobile workers or crews who deviate the most on the travel duration. |
Representation | Use the slider to select the required travel duration deviation bucket. The bar graph shows the number of activities for the mobile worker or crew in the selected travel duration deviation bucket. The X-axis represents the mobile worker or crew name. The Y-axis represents the number of activities. Hover over the bars for specific values. |
Drill Down | The graph bars drill down to the Travel Details dashboard page for specific details about the crew shifts. |
Source Object | Crew Task Fact |
OAS Subject Area | MWM - Crew Task |
Metrics | Number of Activities |
Description | This analysis shows the top 10 postal codes with the highest number of activities in the selected travel duration deviation bucket. The data is shown for the selected month. Note: The travel duration deviation bucket for which the data is shown on this analysis can also be broadcast from the Travel Duration Deviation analysis on the same dashboard. |
Purpose | Business users can identify the top 10 postal codes with the most travel duration deviations. |
Representation | Use the slider to select the required travel duration deviation bucket. The bar graph shows the number of activities in a postal code in the selected travel duration deviation bucket. The X-axis represents the postal code. The Y-axis represents the number of activities. Hover over the bars for specific values. |
Drill Down | The graph bars drill down to the Travel Details dashboard page for specific details about the crew shifts. |
Source Object | Crew Task Fact |
OAS Subject Area | MWM - Crew Task |
Metrics | Number of Activities |
Description | This analysis displays the crew and crew shift details, and their respective travel details for the selected month. |
Purpose | Business users can use this detail-level analysis to view specific details pertaining to each shift, such as travel time, deviation etc. Users can also navigate back to the source Oracle Utilities Mobile Workforce Management/ Oracle Real-Time Scheduler system and view specific details pertaining to shifts on the MWM Crew Shift page. |
Representation | The table displays details, such as shift, the service area, estimated and actual travel durations and distances, and also duration deviations (if any) for a particular activity. |
Drill Down | The Crew and Crew Shift column links drill back to the Crew Shift page in the Oracle Utilities Mobile Workforce Management system for more details about the selected activity. |
Source Object | Crew Task Fact |
OAS Subject Area | MWM - Crew Task |
Metrics | Estimated Travel Time, Actual Travel Time, Deviation |