Power Query for Power BI and Excel
Power Query for Power BI and Excel by Christopher Webb, published by Apress on June 26, 2014, is a practical guide designed for users looking to streamline their data management processes in Excel. This 272-page book addresses the challenges of manually copying and pasting data, offering insights into how Power Query can automate data extraction, filtering, aggregation, and calculations. It serves as a comprehensive resource for those seeking to enhance their efficiency in handling data within Excel and the Power BI suite.
Readers will find detailed instructions on utilizing Power Query to tackle common data-related issues, as well as an exploration of the M language for advanced data manipulation. The book delves into both the graphical user interface and the underlying coding, enabling users to maximize the capabilities of Power Query. This edition is particularly beneficial for individuals aiming to leverage business intelligence through effective data analysis, making it a valuable addition for anyone looking to deepen their understanding of Microsoft tools in the realm of information technology and productivity software.
Official synopsis Publisher
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 iscovered 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
Publisher
Topics
FAQ
What is “Power Query for Power BI and Excel” about?
Who is the author of “Power Query for Power BI and Excel”?
When was “Power Query for Power BI and Excel” published?
What is the ISBN for “Power Query for Power BI and Excel”?
What are the book details (language, pages, edition)?
