Power Pivot and Power Query for Dummies

Need to get a quick ramp-up on Power Pivot and Power Query? Good news…A new book just dropped on Amazon.

Learn how to:

  • Create your own database right in Excel with Power Pivot
  • Make pivot tables that use multiple data sources
  • Scrape websites and import hard-to-reach data with Power Query
  • Simplify and automate data cleanup and transformation
  • Create your own powerful formulas and functions to go beyond simple data imports

Now available on Amazon:

“Discover how Power Pivot 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. Rev up your reporting — fire up Power Pivot, build table relationships, and create robust pivot table reporting using multiple data sources Formulate a plan — find out how to add formulas to Power Pivot reports and get the know-how to share your BI solutions with others When in doubt — get the lowdown on Power Query, from choosing where to load Query results to refreshing and managing queries–and everything in between Can’t we all just get along? — discover how to make Queries work together, build your own Query functions, and make marvelous magic with M Query language Get what you need — transform your way to better data by adding Query filters, filling in blank spaces and empty values, splitting and merging columns, and transposing and pivoting data”

3 thoughts on “Power Pivot and Power Query for Dummies

  1. Bjoern Stiel

    Just ordered the book, thanks for sharing. Speaking of Power Query, is there a painless way to get data from an OAuth2 authenticated API (thinking Google Analytics). What I’ve found so far looks rather painful… any ideas much appreciated, thanks!

  2. Alex Powers

    Been playing around with Power Query at work a lot more lately since the boot camp. Need to pick up the book and make the employer pay for it – how about I order 100 or so?

Leave a Reply

Your email address will not be published. Required fields are marked *