Chapter 2
Performing Large-Scale Data Analysis
In This Chapter
Analyzing worksheet data with pivot tables and pivot charts
Analyzing worksheet data with the PowerPivot and Power View add-ins
Analyzing data visually over time with Power Map
Analyzing data trends in a visual forecast worksheet
The subject of this chapter is performing data analysis on a larger scale in Excel 2016 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 pivot table and its visual counterpart, the pivot chart. Pivot tables enable you to quickly summarize large amounts of data revealing inherent relationships and trends, whereas pivot charts enable you to easily visualize these connections.
In addition, you have access to Excel’s PowerPivot and Power View add-ins when you need to perform analysis on really large data models whose tables contain really huge amounts of data. Finally, Excel 2016 offers you two brand new data analysis features designed to help ...
Get Excel 2016 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.
