Concept: Event Analysis
Event Analysis enables multifaceted negotiations between sourcing teams and supplier engagement. At the end of a sourcing event, you can use Event Analysis to analyze a side-by-side comparison of supplier bids. You can also calculate savings around the best possible outcomes within your supply base. Provide immediate feedback directly to your suppliers on how to improve their bids with actionable data and market trends around their competitors.
You can start the analysis process as soon as you receive bids from your suppliers.
Add and Edit Columns
You can add and edit columns in the Event Analysis module that enables you to add data and create unique columns for each supplier. You can add additional columns to your event data to analyze the bids that your suppliers submit. You can create calculated reference or bid analysis columns by setting the
Analysis Type
to Formula
.Column Type | Description |
|---|---|
Reference | Edit columns in the Event Analysis module enables you to add data and create unique columns for each supplier. You can add additional columns to your event data to analyze the bids that your suppliers submit. You can create calculated reference or bid analysis columns by setting the Analysis Type to Formula . |
Bid Analysis | You can add bid analysis columns to your event data and use them to analyze responses by filling them with unique information for each supplier. You can view your bid analysis columns alongside submitted supplier bids information on the Item Details tab. |
Filter Table Columns
In Event Analysis, you can filter your data by:
- Scenarios
- Suppliers
- Columns
You can also request an update from all your suppliers in the
Suppliers
section.Organizing Columns
When working with large amounts of data, Strategic Sourcing enables you to customize your view to make it easier to read. From the menu of a column header, you can:
- Pin columns to the left or right side of your page.
- Resize columns.
- Set up number filters within the column.
If you need to sort multiple columns, you can Shift-click multiple column headers.
Calculating Cell Data
If you select multiple cells, Strategic Sourcing will calculate these values at the bottom of the Event Analysis grid:
- Average
- Count
- Min
- Max
- Sum
Supplier Coverage
In the
Supplier Summary
tab in Event Analysis, you can view different types of supplier coverage data. This coverage data enables you to analyze bids per line item, by volume, and by baseline price, providing insight into how each supplier responded to your event.Column | Description |
|---|---|
Line Item Coverage | Line item coverage enables you to view the percentage of line items your suppliers bid on. You can determine whether a supplier can provide sufficient coverage for each line item.
Example: When a supplier specializes in a good, you can identify which of your other suppliers are best suited to fulfill different line items. |
Volume Coverage | Volume coverage enables you to see how much of the total quantity your suppliers covered, specifically the volume that your suppliers bid on. This coverage provides a measure of the capacity of a supplier as compared to the total quantity out for bid.
Example: When a supplier bids on 80% of the total volume out for bid, you can identify the best path for awarding bids while consolidating suppliers. |
Baseline Coverage | Baseline coverage enables you to view how much of the business spend is covered based on the supplier. You can evaluate how they performed against a certain benchmark.
Example: When a supplier bids on 50% of the baseline spend, you can identify opportunities for negotiation based on spend with each supplier. |
Supplier Parameters
In the
Supplier Summary
tab of Event Analysis, you can drill down in supplier bids by grouping your important parameters. You can include additional parameters you want to group your suppliers by like Quantity
or Item
. Similar to Excel, when you group by a parameter, you can view the granular details of the coverage of your suppliers. Item Pivots
Item Pivot
enables you to group rows based on column data points. Some common examples for row groupings include section, location, or category. The grouping and structure of the exported pivot table doesn’t save, and the Item Pivot
you create doesn’t persist for different sourcing managers or stakeholders. Access the
Item Pivot
tab in Event Analysis to set up your pivot table.Exporting to Excel
When you finish your analysis, you can export your data as an Excel file. Export individual worksheets by right-clicking in the worksheet that you want to export and clicking
Export
. You can export either a CSV or XLSX file. You can't export from the Item Pivot
tab of a worksheet.If you have filters, the export excludes any hidden data.
You can also export using the
Export Bid Data
tab. Before you export the data, you can define:
- Which suppliers to include.
- Which data to include.
- How the data displays.
When you export from the
Export Bid Data
tab, you can only export Excel files, and you obtain all event data from the selected suppliers.