What do you think?
Rate this book
Microsoft Excel 2013 Building Data Models with PowerPivot
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.
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.
487 pages, Paperback
First published March 15, 2013
31 people are currently reading
111 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 5 of 5 reviews
October 24, 2019
DOBRA ZA MOJ POSAO
December 13, 2019
The book that changed my professional life.
Read
August 14, 2013The title of the book sums up perfectly what its objectives are - building data models with the Excel 2013 PowerPivot add-in.
The book is aimed at the following audience: ‘Excel users, project managers and decision makers who wish to learn the basics of PowerPivot for Excel 2013, master the new DAX language that is used by PowerPivot, and learn advanced data modelling and programming techniques with PowerPivot.’
The book is designed to be read from cover to cover; ‘moreover’, as the authors point out, ‘we wrote some chapters knowing that you will need to read them more than once, because the theoretical background they provide is hard to take in at a first read’.
In summary, the content covers the following areas -
pivot tables, database tables, normalisation and de-normalisation, data models and business intelligence (BI) basics
PowerPivot and Power View
DAX (the PowerPivot language) - from scratch through to advanced
publishing to SharePoint
VBA - automating certain tasks
The book is written in tutorial style, and the examples used in each chapter correlate with a large library of Excel 2013 downloadable worksheets and a Microsoft Access database.
So the best way to go through the examples in the book is to be sitting in front of Excel 2013 (Pro.Plus version) with these sample worksheets. Excel 2010 users, with the PowerPivot add-in, should still be able to get some value from the material although some features and functions such as Power View are simply not available in that version.
There is an online errata - which is a good idea with so much material. (At the time of review there was one entry in it.)
At nearly 500 pages the book is a PowerPivot manual, but with practical examples. With all this material and a comprehensive index, this is an excellent book (or should that be a ‘teach-yourself manual’?), which should easily exceed the expectations and needs of the majority of the intended audience.
Reviewed by Mike Rees IT Consultant MBCS CITP
The book is aimed at the following audience: ‘Excel users, project managers and decision makers who wish to learn the basics of PowerPivot for Excel 2013, master the new DAX language that is used by PowerPivot, and learn advanced data modelling and programming techniques with PowerPivot.’
The book is designed to be read from cover to cover; ‘moreover’, as the authors point out, ‘we wrote some chapters knowing that you will need to read them more than once, because the theoretical background they provide is hard to take in at a first read’.
In summary, the content covers the following areas -
pivot tables, database tables, normalisation and de-normalisation, data models and business intelligence (BI) basics
PowerPivot and Power View
DAX (the PowerPivot language) - from scratch through to advanced
publishing to SharePoint
VBA - automating certain tasks
The book is written in tutorial style, and the examples used in each chapter correlate with a large library of Excel 2013 downloadable worksheets and a Microsoft Access database.
So the best way to go through the examples in the book is to be sitting in front of Excel 2013 (Pro.Plus version) with these sample worksheets. Excel 2010 users, with the PowerPivot add-in, should still be able to get some value from the material although some features and functions such as Power View are simply not available in that version.
There is an online errata - which is a good idea with so much material. (At the time of review there was one entry in it.)
At nearly 500 pages the book is a PowerPivot manual, but with practical examples. With all this material and a comprehensive index, this is an excellent book (or should that be a ‘teach-yourself manual’?), which should easily exceed the expectations and needs of the majority of the intended audience.
Reviewed by Mike Rees IT Consultant MBCS CITP
November 19, 2014
This book offers both a great overview of PowerPivot and Powerview as well as going into details about how the more complex aspects of each work. I really enjoyed the DAX calculated fields as well as the expression evaluation context.
Great book.
Great book.
May 25, 2014
Well,written Power Pivot book. The level was just right for me. Not too introductory but deep enough to be useful.
Displaying 1 - 5 of 5 reviews