Microsoft PowerPivot for Excel 2010: Give Your Data Meaning

by Alberto Ferrari, Marco Russo

Overview

Microsoft PowerPivot for Excel 2010: Give Your Data Meaning introduces PowerPivot in Excel 2010 to power users and data analysts who want to give their data meaning by creating their own Business Intelligence models. And with Microsoft Excel 2010: Data Analysis and Business Modeling, you'll learn the best ways to use Office Excel 2010 for data analysis and business modeling. Award-winning professor and statistician Wayne Winston shares practical examples to help you transform data into bottom-line results. Web site includes practice files.

The two books included in this kit are:

• 9780735640580 Microsoft PowerPivot for Excel 2010
• 9780735643369 Microsoft Office Excel 2007: Data Analysis and Business Modeling, 3E

Product Details

ISBN-13:	9780735657069
Publisher:	Pearson Education
Publication date:	10/05/2010
Series:	Business Skills
Sold by:	Barnes & Noble
Format:	eBook
Pages:	416
File size:	17 MB
Note:	This product may take a few minutes to download.
Age Range:	18 Years

About the Author

ALBERTO FERRARI is a consultant and trainer who specializes in developing Microsoft Business Intelligence solutions, including guiding software organizations through the design of complex BI solutions. He is the coauthor of Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology (with Russo).

Table of Contents

Preface; Marco Russo; Alberto Ferrari; Acknowledgments; Introduction; Who Is This Book For?; System Requirements; About the DVD; Errata & Book Support; We Want to Hear from You; Stay in Touch; Chapter 1: First Steps with PowerPivot; 1.1 Working with Classic Excel PivotTables; 1.2 Working with PivotTables in PowerPivot; 1.3 Summary; Chapter 2: PowerPivot at Work; 2.1 Using the PivotTable to Produce Reports; 2.2 Adding More Tables; 2.3 Working with Dates; 2.4 Refreshing Data; 2.5 Using Slicers; 2.6 Summary; Chapter 3: Introduction to DAX; 3.1 Understanding Calculation in DAX; 3.2 Understanding Calculated Columns and Measures; 3.3 Handling Errors in DAX Expressions; 3.4 Common DAX Functions; 3.5 Summary; Chapter 4: Data Models; 4.1 Understanding Data Models; 4.2 Understanding Physical and Logical Data Models; 4.3 Understanding How and When to Denormalize Tables; 4.4 Complex Relationships; 4.5 Understanding OLTP and Data Marts; 4.6 Discovering Advanced Types of Relationships; 4.7 Summary; Chapter 5: Loading Data and Models; 5.1 Understanding Data Sources; 5.2 Loading from a Database; 5.3 Opening Existing Connections; 5.4 Loading from Access; 5.5 Loading from Analysis Services; 5.6 Using Linked Tables; 5.7 Loading from Excel Files; 5.8 Loading from Text Files; 5.9 Loading from the Clipboard; 5.10 Loading from a Report; 5.11 Loading from a Data Feed; 5.12 Loading from SharePoint; 5.13 Summary; Chapter 6: Evaluation Context and CALCULATE; 6.1 Understanding Evaluation Context; 6.2 Understanding the CALCULATE Function; 6.3 Understanding the EARLIER Function; 6.4 Summary; Chapter 7: Date Calculations in DAX; 7.1 Working with a Dates Table; 7.2 Aggregating and Comparing over Time; 7.3 Closing Balance over Time; 7.4 Summary; Chapter 8: Mastering PivotTables; 8.1 Understanding Different Types of PivotTables; 8.2 Custom Sorting in PivotTables; 8.3 Computing Ratios and Percentage in PivotTables; 8.4 Aggregating Data Without Using Sum; 8.5 Creating Dashboards; 8.6 Using Complex Queries as Linked Tables; 8.7 Performing Analysis of Old and New Data Together; 8.8 Defining Sets; 8.9 Creating Dynamic Sets with MDX; 8.10 Creating Sets of Measures with MDX; 8.11 Summary; Chapter 9: PowerPivot DAX Patterns; 9.1 Calculating Ratio and Percentage; 9.2 Computing Standard Deviation; 9.3 Ranking over a Measure; 9.4 Computing ABC and Pareto Analyses; 9.5 Event in Progress; 9.6 Summary; Chapter 10: PowerPivot Data Model Patterns; 10.1 Banding; 10.2 Performing Courier Simulation; 10.3 Summary; Chapter 11: Publishing to SharePoint; 11.1 SharePoint 2010 and PowerPivot Integration; 11.2 Publishing an Excel Workbook; 11.3 PowerPivot Data Refresh; 11.4 Summary; DAX Functions Reference; Statistical Functions; Logical Functions; Information Functions; Mathematical Functions; Text Functions; Date and Time Functions; Filter and Value Functions; Time Intelligence Functions; Biography;