9.2 Using the Pivot Table

This exercise introduces you to some of the very basic features of the pivot table. Through familiarizing yourself with the basic features, you will become proficient enough in the interface to utilize even more advanced features.

  1. Launch the DataAnalytics.exe application.

  2. Click either Load from Database or Load from File.

  3. Complete the fields in the Login dialog box, then click Login.

    The Web Service URI field should specify the URL used to access the Novell File Reporter web application.

    All of the File System scans appear in a list.

  4. Double-click one of the listed scans.

  5. For this exercise, click Create Year from the toolbar.

    Observe the creation of the pivot table.

  6. From the Pivot Fields region, drag File Extension to the right of the Count column.

    Observe the updated appearance of the pivot table.

  7. In the pivot table, double-click one of the cells.

  8. Expand the Count column to see the paths of all listed files.

  9. Close the Scan Data Details report.

  10. In the pivot table, from the File Extension tab that you added, click the associated filter icon; then from the drop-down menu, deselect Show All.

  11. From the same drop-down menu, select two or three common media file types such as mp3, mov, and so forth; then click OK.

    Observe the updated pivot table.

  12. In the pivot table, highlight two rows and observe the change in the Chart region.

  13. Click the Chart tab and the middle arrow to expand the chart options.

  14. Click the Pie option.

  15. Click the Main tab.

  16. Click Generate Report, then view the report.

  17. Close the report.

  18. Click Save to File to save the data locally.

    Save to File saves only the data. In other words, the data from the scan. After it is saved locally, you can load the data into a pivot table later.