PowerPivot for Advanced Reporting and Dashboards -- Table of Contents -- PowerPivot for Advanced Reporting and Dashboards -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Principles and Installing PowerPivot -- The principle of PowerPivot for Excel -- Benefits of using PowerPivot -- Installing PowerPivot -- Requirements (32-bit and 64-bit versions of Windows) -- Hardware requirements -- Software requirements -- Recommendations -- Getting the PowerPivot add-in for Excel 2010 -- Downloading and installing the PowerPivot add-in for Excel 2010 -- Enabling the PowerPivot add-in for Excel 2013 -- Verifying installation -- Testing the PowerPivot add-in -- Summary -- 2. Preparation Analysis of Data Source -- List of data sources -- Relational database -- Multidimensional sources -- Data feeds -- Text files -- Purpose of importing data from a variety of sources -- General overview of ETL -- Examples -- PowerPivot performance in ETL -- Introducing Data Analysis Expressions (DAX) -- Adding a data source in a single worksheet from a variety of data sources -- E-commerce customer activity data importing -- Importing data from the SQL Server -- Importing data from a flat file -- Sales analysis data importing -- Importing data from the MS Access database -- Importing data using a SQL query -- Importing data based on copy and paste -- Importing data using an Excel-linked table -- Data refresh -- Summary -- 3. Data Model -- General overview of a data model -- A data model in PowerPivot.

Sales analysis data model design process -- Creating a data relationship for the sales analysis data -- Adding a new column using DAX for sales analysis data -- Creating hierarchies for sales analysis data -- Viewing the logical design data model of sales analysis -- E-commerce data model design process -- Splitting the User table for e-commerce data analysis -- Creating relationships -- Adding a new calculated column using DAX and creating hierarchies for e-commerce data -- Viewing the logically designed data model for e-commerce data analysis -- Summary -- 4. Business Intelligence Solutions Analysis -- A general overview of BI reports creation -- OLTP versus OLAP -- OLAP analyses -- The importance of reports -- Dashboards -- Business scorecards -- Key Performance Indicators (KPIs) -- Creating a report using the PowerPivot interface -- Creating simple reports in PowerPivot -- Creating a PivotTable -- Creating a PivotChart -- Creating a PivotTable with Slicers -- Creating PivotChart with Slicers -- PowerPivot Dashboards -- Creating key performance indicators -- Creating a KPI using a Perspective -- Summary -- 5. Publishing Reports Using the SharePoint Server -- PowerPivot for SharePoint -- Configuring PowerPivot for SharePoint -- Verifying the installation -- Types of users -- Deploying the reports in a PowerPivot site -- Summary -- Index.