Filter
Top Products
Management Reports
Nortel Networks Call Center Reporting Set Up and Operation Guide Issue 07
82
For example:
M0301.mdb The monthly statistical database file for the 3
rd
month of 2001.
D0301.mdb The daily statistical database file for the 3
rd
month of 2001.
H0301.mdb The hourly statistical database file for the 3
rd
month of 2001.
W090301.mdb The weekly statistical database file for Week 9, which fell in the 3
rd
month of
2001.
Looking at the Statistical Data with Microsoft Excel
Described below are the steps required to select Call Center Reporting data using Excel 2000
(part of the Microsoft 2000 family).
1. Open Microsoft Excel
2. Select the title bar option Data
3. From the drop-down menu select Get External Data
4. From the drop-down menu select New Database Query…
5. The Microsoft Query dialog appears. The Database tab offers different types of
database that Microsoft Query can work with. Double-click on MS Access Database.
6. The Select Database dialog appears. Browse to the location of the statistical database
file you wish to work with, highlight it and then click OK.
7. The Choose Columns dialog will appear. You will be presented with a list of the tables
within the database. Double click on a table to see the columns within that table.
Highlight a column and click the > button to move the column into the ‘Columns in Your
Query’ list. When you have selected the columns you wish to work with, click on Next.
8. You will be presented with the Filter Data dialog. You can click on the column names
and specify filter criteria for them. If you wish to work with all of the rows in the table,
do not specify any criteria. When you are ready, click on Next.
9. You will then be presented with the Sort Order dialog. You can select a column names
and have the data ordered in either ascending or descending order, according to the values
in the various rows in that column. You may specify up to three levels of sort criteria. If
you do not want the data sorted, do not specify any sort criteria. When you are ready,
click on Next.
10. The Finish dialog appears. Ensure that the Return Data to Microsoft Excel radio button
is checked, and then click Next. Excel then allows you to choose the location of the data
within the current sheet, or to create a new sheet.