Report Building - PowerPoint PPT Presentation

dale-schneider
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Report Building PowerPoint Presentation
Download Presentation
Report Building

play fullscreen
1 / 50
Download Presentation
Report Building
133 Views
Download Presentation

Report Building

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Exony VIM Reports Virtual Interaction Manager Report Building

  2. Overview & Table of Contents This guide is an overview of Exony VIM and it’s report functionality. Reports contain Real-Time (RT) or Historical-Time (HT) data. There are standard reports and the ability to build reports from scratch. Exony also provides a Dashboard to monitor Real-Time information which is automatically refreshed on the screen. Table of Contents • Accessing Exony VIM • Homepage • Report Manager • Viewing Reports • Parameter Sets • Thresholds • Distributing Reports • User Settings

  3. Accessing Exony VIM To access Exony VIM visit the UM sitehttps://callreporting.tel.miami.edu/Portal/default.aspx Enter your assigned User Name and Password and click OK Enter your Username and Password Click OK Next, the entry screen provides a warning about unauthorised access. Click AGREE. Click agree to continue

  4. Report Manager • Basic Mode Interface: • Report Manager is the home page used to launch and manage reports. • The home page has reports for your group and the Standard Reports, known as Symposium_Style_Reports. Your Group Reports Standard Reports – these are shared across all call centers

  5. Report Manager Basic Report Manager access is used to: Launch reports Print reports Set thresholds to highlight specific conditions with colors Schedule reports Edit reports Save reports Create report links Manage report parameters Delete reports Users are able to delete reports!If a report is accidentally deleted please contactthe system administrator.

  6. Report Manager • There are two types of reports created in Exony: • Historical-Time Reports (HT) - Reports that track call center and agent performance over a period of time - half hour, hour, date, month, year. These are statistics of what happened in the past. HT Reports can be used to evaluate call center, agent and skillgroup performance, identify peak periods, etc. • Real-Time Reports (RT) – Reports which contain “real-time” data that is automatically updated. Exony can refresh data from 15 to 60 seconds, depending on what the user selects. RT Reports can be used to view call center, agent and skillgroup states - including current hold times, how long agents are in Ready or Not Ready, etc. • Note - Reports can be viewed online or exported.

  7. Report Manager • There are two types of reports created in Exony:

  8. Report Manager • Sample text:

  9. Report Manager • Sample text:

  10. Report Manager • Sample text:

  11. Report Manager • Sample text:

  12. Report Manager • Sample text:

  13. Report Manager • Sample text:

  14. Report Manager • Sample text:

  15. Report Manager • Sample text:

  16. Report Manager • Sample text:

  17. Report Manager • Sample text:

  18. Report Manager • Sample text:

  19. Report Manager • Sample text:

  20. Report Manager • Sample text:

  21. TRY IT - Running a Historical-Time Report • To run a HT report: • Select a report. In this example click on the report name Agent_by_Skill_Group_-_Daily Click here

  22. TRY IT - Running a Historical-Time Report • Specify a Skillgroup using the pull-down menu • Enter a Start & End date • Click View Report button

  23. Viewing a Report The View Report screen is divided into 4 sections which will be reviewed in detail Menu Bar Parameter Bar Report Tool Bar Report Data

  24. Menu Bar > Edit report details Edit Save changes to this report (use to save changes to reports in your user’s folder – start with applied changes in place) > Save Create a link to this report (saves a modified report in the user’s folder) > Create Link > Delete this report Delete Set thresholds to highlight specific conditions with colours > Thresholds Schedule a report to run at a chosen time or interval > Schedule

  25. Report Parameters Bar Using the Parameter bar you can: Select a Parameter Set. In this example Skillgroups Enter ‘From’ and ‘To’ dates for historical reports Change ‘Sort On’ measure Change ‘Sort Order’ • Add ‘Header Text’ to a report • Select to ‘Show Only Exceptions’ of existing thresholds • Select to show ‘Raw Data’ on historic reports

  26. Parameter Sets Parameter Sets are a collection of dimension items you can report on: For example: Agents SkillGroups Call Types There are a number of pre-configured Parameter sets within Exony VIM. Within the Parameters bar you can choose how you want to sort the report data. Select the measure you want to Sort On Select the Sort Order – Ascending or Descending

  27. Real Time Parameter Bar When running a Real Time Report the Parameter Bar is slightly different. Run RT Report XXXXXXXXXXXXXXXXXXXXXXX • Choose Parameter Set - in this example Call Type • Show Only Exceptions • Sort On - Select the measure you want to Sort On • Sort Order - Ascending or Descending • Add Header Text

  28. Report Toolbar Real-Time Reports has an adjustable slider that you can set to refresh the data automatically from 15 to 60 seconds. Real Time and Historical Reports have buttons to: Refresh Pause Print Export to CSV, Excel or PDF file Maximize screen

  29. Exercise: Saving a Report There are 2 options when saving a report. Save changes to this report (use to save changes to reports in your users folder – start with applied changes in place). Save > Create a link to this report (saves a modified report in the users folder). Create Link > Exercise 1 (Historical Link): Perform a Create Link on your current report. Select the \Training folder Create Link report name HISTORIC Call Type your initials Run the report Exercise 2 (Real-Time Save): Select parameter set and date ranges Perform a Save Run the report

  30. Linked Reports • You cannot make changes to the report template on a linked report. • If changes are made to the ‘master’ report, these changes will be reflected in any reports linked to it. • If the ‘master’ report is deleted all linked reports will also be deleted.

  31. Dashboard The Dashboard is a real-time view of the call center queues. The data displayed is configured by the system administrator. The Dashboard is used to view call center, agent and skillgroup states - including current hold times, how long agents are in Ready or Not Ready, etc.

  32. Exercise: Export a Historic Report Users can Export the current displayed Report. Select the desired format by choosing from the drop down list. Click on the Export drop down Exercise:Export your current report as a CSV … Excel … PDF

  33. Exercise: Export a Real-time Report Users can Export the current displayed Report. Select the desired format by choosing the CSV, Excel or PDF icon. Click on the Export format you require Exercise:Export your current report as a CSV … Excel … PDF

  34. Thresholds Thresholds allow a user to change the formatting of a cell when a certain condition is met. e.g. Calls Answered >10 There is no relationship between different Thresholds. Thresholds When selected the ‘Show Only Exceptions’ option only shows report rows that meet the threshold condition(s). Use the Thresholds link on the Menu bar to access Thresholds.

  35. Thresholds Press Add + button for the measure on which to set a threshold Set the Threshold(s) conditions and formatting

  36. Thresholds • Condition types: • Equal (=) • Not Equal (<>) • Between • Less Than (<) • Greater Than (>) • Less Than or Equal to (<=) • Greater Than or Equal to (=>) • Threshold value(s) • % values should be expressed as decimal value between 0 an 1, e.g. 25% would be entered as 0.25 • duration values should be expressed in seconds - so 1½ minutes should be entered as 90 etc. • Formatting for threshold exceptions • Font Colour / Background Colour • Bold/Italic/Underline

  37. Exercise: Change Thresholds • Check measure Calls Answered • Set condition to > (greater than or equal to) • Set value as 20 • Set format to • Text white • Text Bold • Background Blue • Check measure Calls Handled In • Set condition to > • Set value as 10 minutes • Set format to • Text Red • Text Bold • Background White • Click Save • Run report • Select Show Exceptions Only

  38. Schedule Report & Distribution Users can schedule reports to be exported to a file share location or emailed at a specific time or regular interval, e.g. on the first of the month for the previous month. The schedule page is accessible from the Report Menu Bar on the Report Viewing Page • Reports can also be distributed in a variety of formats • This is configured through the Schedule page

  39. Schedule Report Time/Frequency Enter schedule Name and Description Click drop down for schedule time / frequency Select frequency

  40. Schedule Report Time/Frequency Click to select range on chosen frequency Select time Enter End Date if appropriate Click Update

  41. Schedule Parameters Select Parameter Set Select Time Periods (Historic) Select Sort Options Select options

  42. Schedule Delivery Select delivery Report Format Select Email or Fileshare delivery

  43. Click + icon to add /save Email addresses Click magnifying glass icon to select Email addresses Email Delivery Enter To: Email address(s)

  44. Confirmation shown under report menu bar Email Delivery Click on Cc/Bcc to add CC: and Bcc: Email addresses Select Subject and Priority options Click Save

  45. Click + icon to add /save Network File Share locations Click magnifying glass icon to select Network File Share saves File Share Delivery Enter file share Path

  46. Confirmation shown under report menu bar File Share Delivery Add Windows Username and Password Select file Write Mode Click Save

  47. Viewing / Editing Schedules Click View Existing Schedules Schedule details Click on Schedule

  48. Exercise: Schedule a File Share Name the report Your Name Select Report Server File Share as delivery method Enter your domain credentials Add your email as the sender address. Choose to include the report, and select Excel as the file type. Set the schedule to run weekly on a Friday Set the report Parameters for This Week Click Save Now access the list of schedules and delete it.

  49. Exercise: Schedule an Email Name the report Your Name Select Report Server Email as delivery method Send the Report to dave.adye@exony.com Add your email as the sender address. Choose to include the report, and select Excel as the file type. Set the schedule to run weekly on a Friday Set the report Parameters for This Week Click Save Now access the list of schedules and delete it.

  50. User Settings Under User Settings you can change your password