Mining Some Data
Often data mining techniques are used to better understand the characteristics of events. As an illustrative exercise on the value of data mining, we are going to use data from the United States Department of Transportation's Bureau of Transportation Statistics. In the sample file, we have approximately 30,000 records summarizing flights by carrier, origin, destination, day of week, and distance group. Each summary row contains a value representing the total delays for weather, for the group of characteristics.
After converting the PivotTable to an Excel table as detailed in the previous section, select a cell within the table. Selecting a table cell is necessary in order for the context-sensitive Table Tools ribbon to become ...
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.
