Book description
This book introduces PowerPivot in Excel 2010 to power users and data analysts who want to use Excel as a business intelligence tool.
Publisher resources
Table of contents
- Microsoft® PowerPivot for Excel 2010: Give Your Data Meaning
- Dedication
- A Note Regarding Supplemental Files
- Preface
- Acknowledgments
- Introduction
- 1. First Steps with PowerPivot
- 2. PowerPivot at Work
- 3. Introduction to DAX
- 4. Data Models
-
5. Loading Data and Models
- Understanding Data Sources
- Loading from a Database
- Opening Existing Connections
- Loading from Access
- Loading from Analysis Services
- Using Linked Tables
- Loading from Excel Files
- Loading from Text Files
- Loading from the Clipboard
- Loading from a Report
- Loading from a Data Feed
- Loading from SharePoint
- Summary
-
6. Evaluation Context and CALCULATE
-
Understanding Evaluation Context
- Filter Context in a Single Table
- Row Context in a Single Table
- Adding Filters to a Filter Context for a Single Table
- Removing Filters from a Filter Context for a Single Table
- Row Context with Multiple Tables
- Filter Context with Multiple Tables
- Modifying Filter Context for Multiple Tables
- Final Considerations for Evaluation Context
- Understanding the CALCULATE Function
- Understanding the EARLIER Function
- Summary
-
Understanding Evaluation Context
- 7. Date Calculations in DAX
-
8. Mastering PivotTables
- Understanding Different Types of PivotTables
- Custom Sorting in PivotTables
- Computing Ratios and Percentage in PivotTables
- Aggregating Data Without Using Sum
- Creating Dashboards
- Using Complex Queries as Linked Tables
- Performing Analysis of Old and New Data Together
- Defining Sets
- Creating Dynamic Sets with MDX
- Creating Sets of Measures with MDX
- Summary
- 9. PowerPivot DAX Patterns
- 10. PowerPivot Data Model Patterns
- 11. Publishing to SharePoint
- A. DAX Functions Reference
- B. Biography
- Index
- About the Authors
- Copyright
Product information
- Title: Microsoft® PowerPivot for Excel® 2010
- Author(s):
- Release date: October 2010
- Publisher(s): Microsoft Press
- ISBN: 9780735640580
You might also like
book
English Grammar Workbook For Dummies, with Online Practice, 3rd Edition
Improve your English grammar You have nothing to lose and everything to gain by using proper …
video
Microsoft Excel - Pivot Tables In-Depth
In this Microsoft Excel – Pivot Tables training course, expert author Erin Olsen teaches you everything …
book
Microsoft Excel Functions & Formulas
Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of …
book
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition
The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions Foreword by …