Power BI for real time service call activity
Jump to Overview | Samples | Variables | Alert Functionality | Power BI Reporting | Related Alerts | Webinar
Overview
Overview
This is a Power BI version of ID37 - Call Board Summary Status. It is a day over day look at how your service team is doing with the PBI advantage of being able to drill into the details.
The Overview page shows the following KPIs: Carry Over, New Today, New R/s, Closed, Canceled, Dispatched, Total pending, On Hold, Waiting Parts, Incompleted Today, Callbacks. On The landing page we show Past Due for all KPIs that make sense.
This report has the same variables as ID37. All report pages are setup to present in mobile view as Power BI presents well on a mobile device.
Type of Output: On Demand Power BI Dashboard Report
* * *
Sample
Sample
* * *
Variables
Variables
Variable 1: Enter the On Hold Code(s) used to designate calls On Hold for Parts, separated by comma
Variable 2: Enter the On Hold Code(s) used to designate calls On Hold for Parts Ordered, separated by comma
Variable 3: Enter the On Hold Code(s) used to designate calls On Hold for Parts Available, separated by comma
Variable 4: Enter the On Hold Code(s) used to designate calls On Hold for Parts Ordered Overnight, separated by comma
* * *
Alert Functionality
Alert Functionality
1. See here for getting Power BI in place.
2. Can be refreshed up to 8 times per day with standard Power BI Pro Licenses. More refresh times require Premium Per User license.
3. Mobile phone friendly!
4. Data is only pending calls, any call invoiced today, after refresh tomorrow, that call is no longer available in ID777 report.
* * *
Power BI Reporting
Power BI Reporting
1. Landing Page: - used to take you to each report page.
2. Click on orange house in top left corner of any report page to be taken back to landing page so you can navigate to different report page.
3. Use filters in top right corner for desired results.
4. Where you don't see service call details, you can right click to drill through to call details.
OR click on manager once, for example, then right click on a given stat to drill through to call details.
* * *
Related Alerts
Related Alerts
ID28 - Tech Productivity Power BI
ID281 - Customer Retention Rate Power BI
ID568 - eAuto Activity Trends Power BI
ID704 - The Financial "Model" Power BI
ID770 - Financial Dashboard Power BI
ID771 - Service MIF & Profitability Power BI
ID772 - Inventory Management Power BI
* * *
Webinar
Webinar
**COMING SOON**
0 Comments