Collect, Combine, and Transform Data Using Power Query in Power Bi and Excel
暫譯: 使用 Power Query 在 Power BI 和 Excel 中收集、合併與轉換資料
Maslyuk, Daniil, Raviv, Gil
相關主題
商品描述
Transform your data analysis experience with Power Query, the ultimate tool for importing, reshaping, and cleansing data through a user-friendly interface. Whether you're using Power BI, Excel, or other Microsoft products, Power Query's capabilities are at your fingertips. Renowned Power Query experts Daniil Maslyuk and Gil Raviv guide you through mastering this indispensable tool, helping you eliminate tedious manual data preparation, tackle common issues, and avoid potential pitfalls. In this updated edition, you'll delve into comprehensive analytics challenges, seamlessly integrating your skills into a realistic, final project. By the end, you'll possess the expertise to handle any data and convert it into actionable insights.
You will learn how to:
- Effortlessly prepare data by utilizing Power Query in Power BI and Excel to transform your data quickly and efficiently
- Overcome common data preparation problems with intuitive mouse clicks and straightforward formula edits
- Combine data from various sources, multiple queries, and mismatched tables with ease
- Reshape tables to suit your analysis needs
- Use the Power Query M formula language to create flexible data mashups and tailor transformations to your requirements
- Address and overcome collaboration challenges by using Power Query's powerful features
- Gain crucial insights from text feeds by enhancing your data analysis capabilities
- Profile data, diagnose queries, improve query performance, and more!
About This Book
- For everyone who wants to get more done with Power Query in less time
- For business and financial professionals, developers, entrepreneurs, students, and others who need to efficiently manage and analyze data
商品描述(中文翻譯)
將您的數據分析體驗轉變為使用 Power Query，這是通過用戶友好的介面導入、重塑和清理數據的終極工具。無論您是使用 Power BI、Excel 還是其他 Microsoft 產品，Power Query 的功能都在您的指尖之間。著名的 Power Query 專家 Daniil Maslyuk 和 Gil Raviv 將指導您掌握這個不可或缺的工具，幫助您消除繁瑣的手動數據準備，解決常見問題，並避免潛在的陷阱。在這個更新版中，您將深入探討全面的分析挑戰，將您的技能無縫整合到一個現實的最終項目中。到最後，您將擁有處理任何數據並將其轉化為可行見解的專業知識。
您將學習如何：
- 輕鬆準備數據，利用 Power Query 在 Power BI 和 Excel 中快速高效地轉換您的數據
- 通過直觀的滑鼠點擊和簡單的公式編輯克服常見的數據準備問題
- 輕鬆地從各種來源、多个查詢和不匹配的表格中合併數據
- 重塑表格以滿足您的分析需求
- 使用 Power Query M 公式語言創建靈活的數據混合並根據您的需求定制轉換
- 通過使用 Power Query 的強大功能來解決和克服協作挑戰
- 通過增強您的數據分析能力從文本源中獲取關鍵見解
- 對數據進行分析、診斷查詢、改善查詢性能等！
關於本書
- 適合所有希望在更短時間內使用 Power Query 完成更多工作的人
- 適合需要高效管理和分析數據的商業和金融專業人士、開發人員、企業家、學生及其他人員
作者簡介
Daniil Maslyuk is an independent business intelligence consultant, trainer, and speaker who specializes in Microsoft Power BI. Daniil is the author of all official Microsoft Power BI exam reference books. For his community contributions, Daniil has been recognized as a Microsoft MVP. Daniil blogs at xxlbi.com and posts on X as @DMaslyuk.
Gil Raviv is a seasoned Data & AI expert, founder of DataChant Consulting, and the creator of BI Pixie, an enterprise solution that measures the engagement, adoption, and user satisfaction of Microsoft Power BI audiences. Gil started his Power Query journey as a senior program manager on the Microsoft Excel Product team, where he led the design and integration of Power Query as the next-generation Get Data and data-wrangling technology in Excel 2016. Since then, Gil has been a devoted Power Query practitioner. With the knowledge of Power Query at his disposal, Gil moved to consulting, and over the course of seven years he reached global leadership roles at Avanade and Amazon Web Services (AWS), where he advised Fortune 1000 enterprises in their BI migrations and Analytics centers of excellence. With two decades of software development, product management, and consulting experience at Microsoft, AWS, and other companies, Gil has always found the time to share knowledge and has received recognitions for his contributions--including a five year Microsoft MVP award, two years as a Microsoft Fast Track Solution Architect, and four U.S. patents in the fields of computer networks, cybersecurity, and analytics.
作者簡介(中文翻譯)
Daniil Maslyuk 是一位獨立的商業智慧顧問、培訓師和演講者，專注於 Microsoft Power BI。Daniil 是所有官方 Microsoft Power BI 考試參考書的作者。因為他對社群的貢獻，Daniil 被認可為 Microsoft MVP。Daniil 在 xxlbi.com 上撰寫部落格，並在 X 上以 @DMaslyuk 的身份發表文章。
Gil Raviv 是一位資深的數據與人工智慧專家，DataChant Consulting 的創辦人，以及 BI Pixie 的創建者，這是一個企業解決方案，用於衡量 Microsoft Power BI 受眾的參與度、採用率和用戶滿意度。Gil 的 Power Query 之旅始於 Microsoft Excel 產品團隊的高級程式經理，當時他負責設計和整合 Power Query 作為 Excel 2016 中下一代的獲取數據和數據處理技術。自那時以來，Gil 一直是 Power Query 的忠實實踐者。憑藉對 Power Query 的深入了解，Gil 轉向顧問工作，在七年的時間裡，他在 Avanade 和 Amazon Web Services (AWS) 擔任全球領導職位，為 Fortune 1000 企業提供 BI 遷移和分析卓越中心的建議。擁有在 Microsoft、AWS 和其他公司兩十年的軟體開發、產品管理和顧問經驗，Gil 總是能找到時間分享知識，並因其貢獻而獲得多項認可，包括五年的 Microsoft MVP 獎、兩年的 Microsoft Fast Track 解決方案架構師，以及在計算機網絡、網絡安全和分析領域的四項美國專利。
