- Shopping Bag ( 0 items )
Transform your skills, data, and business—with the power user’s guide to PowerPivot for Excel. Led by two business intelligence (BI) experts, you’ll learn how to create and share your own BI solutions using software you already know and love: Microsoft Excel. Discover how to extend your existing skills, using the PowerPivot add-in to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required. The book introduces you to PowerPivot functionality, then takes a ...
Transform your skills, data, and business—with the power user’s guide to PowerPivot for Excel. Led by two business intelligence (BI) experts, you’ll learn how to create and share your own BI solutions using software you already know and love: Microsoft Excel. Discover how to extend your existing skills, using the PowerPivot add-in to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required. The book introduces you to PowerPivot functionality, then takes a pragmatic approach to understanding and working with data models, data loading, data manipulation with Data Analysis Expressions (DAX), simple-to-sophisticated calculations, what-if analysis, and PowerPivot patterns. Learn how to create your own, “self-service” BI solutions, then share your results effortlessly across your organization using Microsoft SharePoint®.
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to firstname.lastname@example.org.
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;
Posted July 23, 2013
I ordered this book online and despite the assurance that I would receive it quickly (because I was a Member) it had still not arrived after 2 weeks. When I spoke to the customer service representative I was told that she could not track its shipment and had no idea where it was but a new copy would be mailed and I would have it in 3 days. Two weeks later I had still not received the second copy and I called again. The customer service representative's take was: "Maybe we are out of stock."
Maybe? Didn't B&N know that the book was not in stock when they promised that a second copy would be mailed?
So now, after a month of waiting and several phone calls, the best that B&N could do was to refund my money.
Thanks a lot.
And now they contact me and want my opinion on the book that I never received. Please, get it together.
If the Nook is dead in the water and the stores are empty, what is B&N's future if it cannot deliver a book timely, track a shipment or even inform the customer that a book is not available?
Next time I'm going to Amazon or Abe's. Then I can tell you whether this book is good or not. (In the meantime I'll give the book a 5-Star rating as most Microsoft books are pretty good.)