Cisco Unified Contact Center

IPCAR v1.0 - Cisco IPCC Advanced Reporting

Duration: 2 Day Hands-on Lab & Lecture Course

Description
The Cisco? IPCC Advanced Reporting class curriculum addresses technical aspects of reporting in the Cisco Intelligent Contact Management (ICM) IP Call Center (IPCC) reporting environment. Although focused on IPCC implementation, participants with traditional installations also benefit from the course. To lay the groundwork necessary for advanced reporting concepts, the course provides a detailed examination of how ICM components work together to generate the reporting data.

Students build reporting knowledge while participating in hands-on exercises based on common requirements encountered in the field. The course focuses on the basic implementation of a Webview template, intermediate report design and construction, and concludes with implementation of custom extract from the call detail tables. After completing the course, participants have a full understanding of the reporting environment, methods for determining when customization is required, gathering and documenting custom requirements and proven techniques for extracting and summarizing call detail data.
Objectives

  • Describe the ICM environment
  • Describe a typical call flow
  • Name key database tables
  • Describe key formulas for ICM call statistics
  • Use Infomaker to format and create templates
  • Add custom templates to Webview
  • Navigate and query the ICM database schema
  • Identify and understand key fields of call detail records
  • Compare and validate detail call records with summary data
  • Access the need for customization
  • Construct and execute a basic custom extract
  • Describe reporting best practices

Course Outline


IPCAR v1.0
  • ICM/IPCC Overview
  • Call Statistics
  • Formulas and Calculations
  • Introduction to Webview
  • Reporting Architecture
  • Introduction to Infomaker
  • Template Formatting
  • Installing and Modifying Webview Templates
  • Database Tools
  • Basic SQL
  • Designing and Building Templates
  • Agent Detail Records
  • RCD and TCD Records
  • Key Data Fields
  • Validating Call Data

Lab Outline

  • Formatting a Template
  • Modifying a Standard Template
  • Analyzing ICM Database Schema
  • Preparing Report Requirements, Design, and Construction
  • Implementing a Database Extract
  • Designing Templates for Database Extract
  • Constructing an Extract Cursor
  • Standard routing script using digit collection
  • Troubleshooting procedures