Offline Scoring Analysis with Excel Pivot Tables
Friday, January 25th, 2008Scoring data from RFP / RFx projects is used in different ways by different organisations. It can be statistically manipulated, analysed or used to produce charts and reports. To facilitate these activities SupplierSelect now provides a new way of exporting scoring data for maximum flexibility. This is the “Raw Data Export” report reached under Project -> Reports using the “Raw Data” link under “Analysis”.
This article describes using Excel’s Pivot Table functionality to analyse data thus exported. The screenshot below shows how the a sample dataset appears when it is first loaded in Excel: