Building Data Models with PowerPivot

Building Data Models with PowerPivot : Microsoft (R) Excel (R) 2013

4.31 (66 ratings by Goodreads)
By (author)  , By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 1 business day
When will my order arrive?


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?
show more

Product details

  • Paperback | 500 pages
  • 187.96 x 226.06 x 30.48mm | 703.06g
  • Redmond, United States
  • English
  • 1st. ed.
  • w. ill.
  • 0735676348
  • 9780735676343
  • 198,677

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
show more

About Alberto Ferrari

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.
show more

Rating details

66 ratings
4.31 out of 5 stars
5 52% (34)
4 32% (21)
3 14% (9)
2 3% (2)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X