Microsoft Excel 2013 Building Data Models with PowerPivot
by Ferrari, Alberto; Russo, MarcoEdition: 1st
Format: Paperback
Pub. Date: 2013-03-15
Publisher(s): Microsoft Press
Other versions by this Author
List Price: $39.99
Buy New
Usually Ships in 2-3 Business Days.
$39.59
Rent Book
Select for Price
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
Your guide to quickly turn data into results. NOTE: This book is based on Office Customer Preview; its content and publication date will be updated for final Office 2013 software. Transform your skills, data, and business-and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel® 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results-no programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint®
Author Biography
Alberto Ferrari has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and is a consultant and trainer who specializes in developing Microsoft BI solutions. He is the coauthor of Microsoft PowerPivot for Excel 2010 and Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology.
Table of Contents
- Introduction
- Chapter 1: Introduction to PowerPivot
- Chapter 2: Using the unique features of PowerPivot
- Chapter 3: Introducing DAX
- Chapter 4: Understanding data models
- Chapter 5: Publishing to SharePoint
- Chapter 6: Loading data
- Chapter 7: Understanding evaluation contexts
- Chapter 8: Understanding CALCULATE
- Chapter 9: Using hierarchies
- Chapter 10: Using Power View
- Chapter 11: Shaping the reports
- Chapter 12: Performing date calculations in DAX
- Chapter 13: Using advanced DAX
- Chapter 14: Using DAX as a query language
- Chapter 15: Automating operations using VBA
- Chapter 16: Comparing Excel and SQL Server Analysis Services
- About the Authors
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.