Home > Store > Home & Office Computing > Microsoft Applications

Microsoft Excel 2013 Building Data Models with PowerPivot

Register your product to gain access to bonus material or receive a coupon.

Microsoft Excel 2013 Building Data Models with PowerPivot

Best Value Purchase

Book + eBook Bundle

  • Your Price: $43.19
  • List Price: $71.98
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

More Purchase Options

Book

  • Your Price: $31.99
  • List Price: $39.99
  • Usually ships in 24 hours.

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Description

  • Copyright 2013
  • Dimensions: 7-3/8" x 9"
  • Pages: 500
  • Edition: 1st
  • Book
  • ISBN-10: 0-7356-7634-8
  • ISBN-13: 978-0-7356-7634-3

Your guide to quickly turn data into results.

 

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

Authors’ note on using Microsoft Excel 2016: This book’s content was written against Excel 2013, but it is useful and valid for users of Excel 2016 too. Excel 2016 introduces several new DAX functions and an improved editor for DAX without changing any existing behavior. In other words, all of the concepts and examples explained in this book continue to work with Excel 2016.

Downloads

Downloads

Follow the instructions to download this book's companion files or practice files.

  1. Click the Download button below to start the download.
  2. If prompted, click Save.
  3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.
Download Part 1 Download Part 2 Download Part 3 Download Part 4

Sample Content

Sample Pages

Download the sample content

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

Updates

Errata

We've made every effort to ensure the accuracy of this book and its companion content. Any errors that have been confirmed since this book was published can be downloaded below.

Download the errata

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership