Power Query for Power BI and Excel

版本说明：1

作     者：Chris Webb (auth.) 

I S B N：(纸本) 9781430266914;9781430266921 

出 版 社：Apress 

出 版 年：2014年

页      数：261页

主 题 词：Microsoft Computer and Information Systems Applications 

摘      要：Power Query for Power BI and Excelis 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 Excelgoes 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 arent going to be possible from just the GUI interface that is covered in most other books. Youll have full command of the GUI, and youll 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 What youll learn Import data from sources including relational databases, text files, web pages, and Excel workbooks. Import from more exotic sources such as Facebook, Windows Azure Marketplace, Wikipedia, and OData feeds within andoutside your organization. Build repeatable processes to filter, clean, aggregate, and transform your data. Load your data into an Excel table or directly into the Excel 2013 Data Model. Write complex expressions in Power Querys M expression language. Share queries and their data with other users in y