Data Analysis with Pivot Tables and Charts
Dan Clark · Apress eBooks · 2020
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. 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.