82Management Reports
For example: |
|
M0301.mdb | The monthly statistical database file for the 3rd month of 2001. |
D0301.mdb | The daily statistical database file for the 3rd month of 2001. |
H0301.mdb | The hourly statistical database file for the 3rd month of 2001. |
W090301.mdb | The weekly statistical database file for Week 9, which fell in the 3rd 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
4.From the
5.The Microsoft Query dialog appears. The Database tab offers different types of database that Microsoft Query can work with.
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.
Nortel Networks Call Center Reporting Set Up and Operation Guide | Issue 07 |
