Chapter 1. Understanding PivotTables
Understanding Data Analysis
The PivotTables and PivotCharts that you learn about in this book are part of the larger category of data analysis. You can get the most out of these tools if you have a broader understanding of what data analysis is, what its benefits are, and what other tools are available to you.
Data analysis is the application of tools and techniques to organize, study, reach conclusions about, and sometimes also make predictions about, a specific collection of information. A sales manager might use data analysis to study the sales history of a product, determine the overall trend, and produce a forecast of future sales. A scientist might use data analysis to study experimental findings and determine ...