Service Providers Analysis Tab
Chellie Esters
Caroline Antoun
The Service Providers Analysis tab gives you a view of your facilities spend by Provider. Across your active providers, you can analyze invoice amounts, feedback, service levels, and trades over the past 365 days, by default. Use the all-inclusive filters along the top of the report to change the date range, or to focus on specific Trades, Categories, and/or Providers.
In this dashboard you will see:
- Count of Active Providers
- Provider Analysis - Top 10 by Total Invoice Amount
- Feedback Report
- Top 10 Providers by Total Invoice Amount
- Service Levels by Trade - Top 10 by Work Order Count
- Invoice Analysis by Trade - Top 10 Trades by Count of Invoices
You can download the data and email reports to recipients.
Count of Active Providers
This visualization displays the number of Providers who have worked on at least 1 work order during the selected date range. By default, this chart displays this data over the past 365 days; use the all-inclusive filters along the top of the report to change the date range.
Clicking the number drills down into a list of all work orders and includes:
- work order details such as Status, Trade, Category, and Location
- work order completion date
- NTE
- Invoice Amount
- Committed Spend
Clicking the tracking number navigates you the work order details page in Service Automation.
Provider Analysis - Top 10 by Total Invoice Amount
This visualization enables you to spot any outliers among your provider invoicing. It clusters three-dimensional data for your top 10 Providers: Invoice Amount, Average Invoice Amount, and Number of Work Orders by Provider.
Both voided work orders and work orders with an empty Status are excluded.
Each bubble represents a Provider — the more Work Orders for that Provider, the larger the size of the bubble.
Hovering over a bubble lists the Total Invoice Amount for that Provider, the Provider name, the Average Invoice Amount, and the total Work Order Count. Clicking the bubble allows you to explore all underlying data, or filter by Trade, District, or Asset.
By default, this chart displays this data over the past 365 days; use the all-inclusive filters along the top of the report to change the date range.
Feedback Report
This visualization summarizes the number of work orders marked as Satisfactory or Unsatisfactory, as well as work orders with no feedback.
Only work orders in the Completed, Completed/Confirmed, and Completed/Invoiced Statuses are included.
Hovering over the chart shows the number of work orders for the corresponding feedback result. Click a feedback result to drill down into all work orders with that result, or filter work orders by Region, Feedback, or Asset.
By default, this chart displays this data over the past 365 days; use the all-inclusive filters along the top of the report to change the date range.
Top 10 Providers by Total Invoice Amount
This table helps you analyze your top 10 providers and their work order and invoice volume. For each Provider you will see:
- Work Order Count
- Invoice Count
- Average Invoice Amount
- Average Full Resolution Time (Days), calculated as the difference between the Work Order Completion Date and Work Order Call Date
- Average Time on Site (Hours)
- Invoice Amount