買這商品的人也買了...
-
深入淺出 Python (Head First Python)$780$616 -
太陽能、USB、鋰電池充電轉換Pro 版 (Lipo Rider Pro)$450$441 -
蘋果專業訓練教材 Motion 5 (Apple Pro Training Series: Motion 5)$780$663 -
從 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$537 -
40 條彩色排線 20cm 公對公$100$95 -
改變世界的九大演算法 : 讓今日電腦無所不能的最強概念 (Nine Algorithms That Changed the Future: The Ingenious Ideas That Drive Today’s Computers)$360$284 -
![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$411 -
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)$7,060$6,707 -
$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 的基本知識
- 幫助您解決與 Power Query 相關的常見數據問題
- 展示如何在強大的 M 語言中編寫自己的解決方案
您將學到什麼
- 從關聯數據庫、文本文件、網頁和 Excel 工作簿等來源導入數據。
- 從更特殊的來源導入數據，例如 Facebook、Windows Azure Marketplace、維基百科和組織內外的 OData 來源。
- 建立可重複的過程來過濾、清理、聚合和轉換您的數據。
- 將數據加載到 Excel 表格中或直接加載到 Excel 2013 數據模型中。
- 在 Power Query 的 M 表達式語言中編寫複雜的表達式。
- 與組織中的其他用戶共享查詢及其數據。
- 使用 Power View、Power Map、Power Pivot 和 Microsoft 的 Power BI 套件中的其他工具為進一步分析定位您的數據。
本書適合誰
Power Query for Power BI and Excel 針對需要將數據導入工作表的 Excel 和 Power BI 重度使用者。無論您是分析師、報告撰寫者、商業智慧顧問，還是僅僅是負責準備每月銷售儀表板的「那個人」，您都將學到 Power Query 如何讓您的生活更輕鬆。Power Query for Power BI and Excel 對於希望直接使用支撐 Power Query 所有功能的 M 語言的 Excel 和 BI 高級使用者尤其重要。
目錄
- Power Query 及其使用時機
- 數據來源
- 轉換
- 表格與 Excel 數據模型
- M 語言中的表達式
- 多個數據來源
- Power BI 與共享
- 解決常見問題
