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.
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
AutoCAD® 2011 & AutoCAD LT® 2011 Bible
In-depth coverage of all new software features of AutoCAD and AutoCAD LT AutoCAD is the leading …
book
Discovering AutoCAD® 2015
This book presents a hands-on, activity-based approach to the use of AutoCAD as a drafting tool—complete …
book
AutoCAD® 2012 and AutoCAD LT® 2012 Essentials: Autodesk® Official Training Guide
Learn the Essentials on Autodesk's powerhouse architectural software The new Essentials series from Sybex helps you …
book
Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model
Build agile and responsive Business Intelligence solutions Analyze tabular data using the BI Semantic Model (BISM) …