Microsoft Excel 2013: Building Data Models with PowerPivot

Front Cover
Pearson Education, 2013 - Computers - 487 pages
0 Reviews

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.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Introduction to PowerPivot
1
Using the unique features of PowerPivot
31
Introducing DAX
49
Understanding data models
83
Publishing to SharePoint
117
Loading data
133
Understanding evaluation contexts
179
Understanding CALCULATE
209
Shaping the reports
289
Performing date calculations in DAX
323
Using advanced DAX
369
Using DAX as a query language
417
Automating Operations using VBA
445
Comparing Excel and SQL Server Analysis Services
463
Index
473
About the Authors
488

Using hierarchies
233
Using Power View
261
Blank Page
490
Copyright

Other editions - View all

Common terms and phrases

About the author (2013)

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.

Marco Russo is a software consultant and Microsoft Certified Trainer who focuses on Windows development and BI solutions. He has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and has coauthored many books, including Microsoft PowerPivot for Excel 2010 and Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model.

Bibliographic information