Book description
"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
Table of contents
- Cover
- Title
- Copyright
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Preface
- Chapter 1: Introducing Power Query
-
Chapter 2: Power Query Data Sources
- Querying Relational Databases
- Extracting Data from Files
- Working with Folders and Multiple Files
- Working with Data from the Current Excel Workbook
- Working with Data from the Web
- Using Other Queries as Data Sources
- OData Data Sources
- Working with Data from HDFS and HDInsight
- Working with Active Directory Data
- Working with Data from Microsoft Exchange
- Working with Data from Facebook
- Working with Data from SAP BusinessObjects
- Reusing Recent Data Sources
- Managing Credentials
- The Importance of Locale
- Summary
- Chapter 3: Transforming Data with Power Query
- Chapter 4: Data Destinations
- Chapter 5: Introduction to M
- Chapter 6: Working with Multiple Queries
- Chapter 7: Power Query and Power BI for Office 365
- Chapter 8: Power Query Recipes
- Index
Product information
- Title: Power Query for Power BI and Excel
- Author(s):
- Release date: June 2014
- Publisher(s): Apress
- ISBN: 9781430266921
You might also like
book
Excel 2016 Power Programming with VBA
Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to …
book
Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources
Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and …
book
Financial Analysis and Modeling Using Excel and VBA
An updated look at the theory and practice of financial analysis and modeling Financial Analysis and …
book
Power Query
Power Query ist ein in Excel integriertes Tool, mit dem man Daten aus verschiedenen Quellen extrahieren …