Preparing Data with PowerPivot
With the Data Mining Add-In installed, and the SSAS server configured and connected to Excel, the next task is to prepare your data for data mining. PowerPivot for Excel is well suited for the assembly of the data.
Within the On Time Performance.xlsx file already used in the section titled “Adding the SSAS Connection Within the Data Mining Add-In,” create a new flattened PivotTable from the PowerPivot ribbon menu. Use a new worksheet as the destination for the flattened PivotTable. Use Month, DayofWeek, Carrier, Origin, Dest, and DistanceGroup as row labels. Drag WeatherDelay to the Values area of the PowerPivot Field List. When finished, your PivotTable should resemble Figure 10-27.
Figure 10-27. Flattened ...
Get PowerPivot for Business Intelligence Using Excel and SharePoint now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
