ARRAY(0xadaad390)

Vous voulez voir cette page en français ? Cliquez ici.

Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning [Paperback]

Marco Russo , Alberto Ferrari


Available from these sellers.


‹  Return to Product Overview

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;

‹  Return to Product Overview