What do you think?
Rate this book
Excel Power Pivot & Power Query For Dummies (For Dummies
A guide to PowerPivot and Power Query no data cruncher should be without! Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of tools can be leveraged to more effectively source and incorporate 'big data' Business Intelligence and Dashboard reports. You'll discover how PowerPivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities. Gone are the days of relatively small amounts of data—today's data environment demands more from business analysts than ever before. Now, with the help of this friendly, hands-on guide, you'll learn to use PowerPivot and Power Query to expand your skill-set from the one-dimensional spreadsheet to new territories, like relational databases, data integration, and multi-dimensional reporting. If you spend your days analyzing data, Excel PowerPivot & Power Query For Dummies will get you up and running with the rich set of Excel tools and reporting capabilities that will make your life—and work—easier.
288 pages, Kindle Edition
First published March 21, 2016
46 people are currently reading
27 people want to read
About the author
Michael Alexander
47Ìýbooks9ÌýfollowersThis is "Michael^^^^Alexander", author of computer-related books
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 6 of 6 reviews
September 12, 2021
Purchased online and returned same day. Nothing wrong with the book but I was looking for a solution to a set of specific niggles in my Pivoting like percentage values by rows and I could find this in the index or anywhere. Plus the reader needs to get a few Add-ins for the Excel to really join the the text, these are probably free - but it was too much messing about and head-ache for me. This book though would be great for right person I no doubt, just not for me.
October 12, 2021
If connecting to databases (SQL, Web� etc) will help you in anyway, this book is extremely helpful. As expected, it was an easy read and the scope was exactly what I was looking for!
Lots of great info on manipulating data once in power query. It also exposed me to
power pivot, something I’ve utilized sparingly.
The relational database component was the most useful. If you’re concatenating cells (creating unique IDs) and using lots of VLOOKUPS to connect the databases, read this book.
Lots of great info on manipulating data once in power query. It also exposed me to
power pivot, something I’ve utilized sparingly.
The relational database component was the most useful. If you’re concatenating cells (creating unique IDs) and using lots of VLOOKUPS to connect the databases, read this book.
June 29, 2017
Good intro. Gives me a jumping off point for experimenting and some pointers for other things to learn.
February 26, 2019
Good introductory book.
March 27, 2019
OK intro. Good amount of problems with downloadable content.
July 19, 2021
2.5 stars: really good for basics but a little outdated due to multiple recent Microsoft updates!
Displaying 1 - 6 of 6 reviews
Can't find what you're looking for?
Get help and learn more about the design.