Chapter 2
Performing Large-Scale Data Analysis
IN THIS CHAPTER
Analyzing worksheet data with PivotTables and PivotCharts
Analyzing worksheet data with the Power Pivot add-in
Analyzing data visually over time with 3D Maps
Analyzing data trends in a visual forecast worksheet
The subject of this chapter is performing data analysis on a larger scale in Excel worksheets, often with visual components that enable you and your users to immediately spot developing trends. The primary Excel tool for performing such large-scale analysis on your worksheet data is the PivotTable and its visual counterpart, the PivotChart. PivotTables enable you to quickly summarize large amounts of data revealing inherent relationships and trends, whereas PivotCharts enable you to easily visualize these connections.
You also have access to Excel’s Power Pivot add-in when you need to perform analysis on data models whose tables contain huge amounts of data. Finally, Excel offers two visual data analysis features designed to help you quickly identify significant indicators of your business’s health and well-being: ...
Get Excel All-in-One For Dummies 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.
