Abstract
Once you have the data model created in Power Pivot, you need to create an interface for users to interact with the data model and perform data analysis using the model. You can use several programs to interface with the model depending on the type of analysis taking place; these include Power View, Power Map, Performance Point, and Reporting Services. Although all these tools are viable clients to use, one of the best client tools is Excel itself. Excel is a feature-rich environment for creating dashboards using pivot tables and pivot charts. Furthermore, it is very easy to share Excel files with colleagues or host the Excel workbook on SharePoint for increased performance and security. This chapter covers the basics of building an interface for analyzing the data contained in a Power Pivot model using pivot tables and pivot charts in Excel.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Dan Clark
About this chapter
Cite this chapter
Clark, D. (2014). Data Analysis with Pivot Tables and Charts. In: Beginning Power BI with Excel 2013. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6446-0_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6446-0_7
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6445-3
Online ISBN: 978-1-4302-6446-0
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)