買這商品的人也買了...
-
深入淺出 Python (Head First Python)$780$663 -
太陽能、USB、鋰電池充電轉換Pro 版 (Lipo Rider Pro)$450$441 -
蘋果專業訓練教材 Motion 5 (Apple Pro Training Series: Motion 5)$780$702 -
從 Linux 直入 TCP/IP 核心世界─使用 C (深入淺出 Linux TCP/IP 協定核心)$520$442 -
SQL Server 2012 商業智慧 2.0$780$663 -
Arduino UNO R3 開發板(副廠相容版)附傳輸線$400$380 -
Excel 2013 統計分析實務--市場調查與資料分析( 範例適用 Excel 2013~2007)$540$427 -
HC06 藍牙模組(從端)$230$219 -
超圖解 Arduino 互動設計入門, 2/e$680$578 -
40 條彩色排線 20cm 公對公$100$95 -
改變世界的九大演算法 : 讓今日電腦無所不能的最強概念 (Nine Algorithms That Changed the Future: The Ingenious Ideas That Drive Today’s Computers)$360$252 -
![Photoshop 設計幫幫忙--解決現場問題的速查即效事典[CC/CS6/CS5/CS4/CS3]-cover](https://cf-assets1.tenlong.com.tw/images/85908/medium/ACU065900.jpg)
Photoshop 設計幫幫忙--解決現場問題的速查即效事典[CC/CS6/CS5/CS4/CS3]$450$356 -
Blender 建模與動畫入門$520$442 -
iOS 8 程式設計實戰--205 個快速上手的開發技巧$500$395 -
網站滲透測試實務入門$380$300 -
高效能網站開發指南 (High Performance Browser Networking: What every web developer should know about networking and web performance)$580$458 -
養成 iOS 8 App 程式設計實力的 25 堂課－最新 Swift 開發教學(A Practical Guide to Building Your First App from Scratch: Beginning iOS 8 Programming with Swift)$580$452 -
Swift初學特訓班--iOS App 開發快速養成與實戰(附近3小時新手入門與關鍵影音教學/全書範例程式)$420$332 -
深入理解 Android 核心設計思想－核心解構篇$720$562 -
Mac 活用萬事通：Yosemite 一本就學會！$520$406 -
Multicomp Raspberry Pi B+/2B 保護殼 - Clear
$350$343 -
Raspberry Pi 2 基本套組(Raspberry Pi 2 Model B + 壓克力外殼(或兩片式外殼帶風扇-隨機出貨) + 散熱片 + 5V/2000mA USB 變壓器)
$2,080$1,976 -
Ruby on Rails 自習手冊：邁向鐵道工人之路$300$234 -
Criminalistics, 10/e (Paperback)$6,930$6,584 -
$301Power Query : 用 Excel 玩轉商業智能數據處理
相關主題
商品描述
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
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 and outside 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 Query’s M expression language.
- Share queries and their data with other users in your organization.
- Position your data for further analysis using Power View, Power Map, Power Pivot, and the rest of Microsoft’s Power BI suite.
Who this book is for
Power Query for Power BI and Excel is aimed at serious Excel and Power BI users who need to import data into a worksheet. Whether you are an analyst, report writer, business intelligence consultant, or just that guy whose job it is to prepare the monthly sales dashboard, youll learn how Power Query can make your life easier. Power Query for Power BI and Excel is especially important for Excel and BI power users who want to work directly in the M language that underlies all of Power Querys functionality.
Table of Contents
- Power Query and When to Use It
- Data Sources
- Transformations
- Tables and the Excel Data Model
- Expressions in the M Language
- Multiple Data Sources
- Power BI and Sharing
- Common Problems Solved
商品描述(中文翻譯)
Power Query for Power BI and Excel 是一本針對厭倦將資料複製貼上到 Excel 工作表的人而設的書籍。Power Query 是 Microsoft Power BI 套件的一部分，它是一個自動化將資料載入 Excel 的工具，可以節省您大量乏味、重複且容易出錯的工作時間！Power Query 讓從多種不同資料來源中提取資料、過濾資料、聚合資料、清理資料和進行計算變得輕鬆，最後將資料載入工作表或直接載入 Power Pivot 使用的新 Excel 2013 資料模型中。這本簡潔實用的書提供了完整的 Power Query 指南，以及如何使用它解決所有 Excel 資料載入問題。
Power Query for Power BI and Excel 不僅僅停留在 Power Query 的表面，它深入探討了底層的 M 語言，向您展示了一些在大多數其他書籍中所涵蓋的 GUI 介面無法實現的驚人功能。您將完全掌握 GUI，並能夠使用 M 語言超越 GUI 提供的功能。這本書的深度使其成為那些在追求商業智能數據分析中將 Power BI 和 Excel 推向極限的人必備的物品。
這本書教授使用 Power Query 將資料載入 Excel 的基礎知識，幫助您解決常見的與資料相關的問題，並展示如何使用強大的 M 語言編寫自己的解決方案。
您將學到以下內容：
- 從包括關聯式資料庫、文字檔案、網頁和 Excel 工作簿在內的來源中匯入資料。
- 從更特殊的來源，如 Facebook、Windows Azure Marketplace、Wikipedia 和組織內外的 OData 資料源中匯入資料。
- 建立可重複使用的過濾、清理、聚合和轉換資料的流程。
- 將資料載入 Excel 表格或直接載入 Excel 2013 資料模型。
- 在 Power Query 的 M 表達式語言中撰寫複雜的表達式。
- 與組織中的其他使用者共享查詢及其資料。
