Power Query for Power BI and Excel

Authors: Webb, Christopher, Limited, Crossjoin Consulting

Download source code
  • Power Query for Power BI and Excel shows how to use Microsoft Power Query to extract data from multiple data sources, filter that data, aggregate it and clean it, and finally load it into Microsoft Excel.

Buy this book

eBook $29.99
price for USA (gross)
  • ISBN 978-1-4302-6692-1
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $39.99
price for USA
  • ISBN 978-1-4302-6691-4
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems.

Power Query for Power BI and Excel goes well beyond the surface of what Power Query can do. The book goes deep into the underlying M language, showing you how to do amazing things that aren’t going to be possible from just the GUI interface that is covered in most other books. You’ll have full command of the GUI, and you’ll be able to drop into the M language to go beyond what the GUI provides. The depth in this book makes it a must-have item for anyone who is pushing Power BI and Excel to their limits in the pursuit of business intelligence from data analysis.

  • Teaches the basics of using Power Query to load data into Excel
  • Helps you solve common, data-related problems with Power Query
  • Shows how to write your own solutions in the powerful M language

About the authors

Chris Webb is a UK-based consultant and trainer specializing in the Microsoft Business Intelligence stack. He has co-authored three books - MDX Solutions, Expert Cube Development with Microsoft SQL Server Analysis Services 2008, and SQL Server Analysis Services 2012: The BISM Tabular Model and is a regular speaker at conferences and user groups around the world. He blogs at http://cwebbbi.wordpress.com.

Table of contents (8 chapters)

Buy this book

eBook $29.99
price for USA (gross)
  • ISBN 978-1-4302-6692-1
  • Digitally watermarked, DRM-free
  • Included format: PDF, EPUB
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $39.99
price for USA
  • ISBN 978-1-4302-6691-4
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Power Query for Power BI and Excel
Authors
Copyright
2014
Publisher
Apress
Copyright Holder
Christopher Webb and Crossjoin Consulting Limited
eBook ISBN
978-1-4302-6692-1
DOI
10.1007/978-1-4302-6692-1
Softcover ISBN
978-1-4302-6691-4
Edition Number
1
Number of Pages
XV, 272
Number of Illustrations and Tables
326 b/w illustrations
Topics