---
title: "Usage Example"
description: "Now, you can create your own sample pivot table for vSphere hosts in the environment to show all average performance metric values that have been recorded to the OpsMgr Data Warehouse during the previous 7 days: In the PowerPivot for Excel window..."
canonical: "https://helpcenter.veeam.com/docs/mp/resource_kit/usage_example.html"
breadcrumb: "Veeam MP Resource Kit Guide > Visualizing Veeam MP Data Using Microsoft PowerPivot > Importing data from OpsMgr Data Warehouse > Usage Example"
dateModified: "2026-09-10"
---

# Usage Example

Now, you can create your own sample pivot table for vSphere hosts in the environment to show all average performance metric values that have been recorded to the OpsMgr Data Warehouse during the previous 7 days:

1. In the **PowerPivot for Excel** window, switch to the **Home** tab and select **PivotTable** > **PivotTable**.
2. In the **Insert Pivot** window, select **New Worksheet**. This will open a new worksheet in Excel.

   [![Insert a pivot](images/insert_pivot.png "Insert a pivot")](images/insert_pivot.png){.toggle scale=75}

3. In **PivotTable Fields**, expand the **Entities** drop-down list, right-click *ManagedEntityTypeDefaultName* and select **Add to Report Filter**. This will add a new filter for monitored objects in the worksheet.

   [![Add a new filter](images/add_new_filter.png "Add a new filter")](images/add_new_filter.png){.toggle scale=60}

4. Expand the drop-down list in the cell with the *All* value and select **VMware vSphere Host**. This will narrow the filter results to the objects of the *VMware vSphere Host* class.

   [![Select VMware vSphere Host class](images/select_host_object.png "Select VMware vSphere Host class")](images/select_host_object.png){.toggle scale=60}

5. In **PivotTable Fields**, expand the **Perf** drop-down list, right-click *CounterName* and select **Add to Column Labels**. This will add new columns with performance metric names in the worksheet.

   Similarly, right-click *AverageValue*, and select **Add to Values**. This will display metric values for each column in the worksheet.

   [![Add new columns](images/add_columns.png "Add new columns")](images/add_columns.png){.toggle scale=54}

6. In the **VALUES** field, expand the **Sum of AverageValue** drop-down list and select **Value Field Settings**.

   In the **Value Field Settings** window, select *Average* from the **Summarize value field by** list.

   [![Specify field settings](images/value_field_settings.png "Specify field settings")](images/value_field_settings.png){.toggle scale=75}

7. In **PivotTable Fields**, expand the **Entities** drop-down list, right-click *DisplayName* and select **Add to Row Labels**. This will display a list of hosts in the worksheet. 

   [![Add new rows](images/add_row_labels.png "Add new rows")](images/add_row_labels.png){.toggle scale=53}

You can use conditional formatting and highlight hosts with the highest CPU usage level:

1. Select values in the **cpuUsageMHz** column.
2. On the **Home** tab, click **Conditional Formatting** > **Color Scales** > **Red – Yellow- Green Color Scale**.

   [![Use conditional formatting](images/color_scales.png "Use conditional formatting")](images/color_scales.png){.toggle scale=56}

You can also add a timeline to narrow the time frame for data analysis:

1. Open the Pivot Tools **Analyze** tab and click **Insert Timeline**.
2. In the **Insert Timeline** window, select *Perf.DateTime* and click **OK**.

   [![Insert a timeline](images/insert_timeline.png "Insert a timeline")](images/insert_timeline.png){.toggle scale=75}

   In the **DateTime** window, adjust timeline to show *DAYS*. Then stretch the timeline to include the exact dates for which you want the data to be analyzed.

   [![Adjust date and time interval](images/datetime.png "Adjust date and time interval")](images/datetime.png){.toggle scale=75}