Collect, Combine, and Transform Data Using Power Query in Power BI and Excel - Daniil Maslyuk, Gil Raviv

Collect, Combine, and Transform Data Using Power Query in Power BI and Excel

Buch | Softcover
448 Seiten
2025 | 2nd edition
Addison Wesley (Verlag)
978-0-13-811579-1 (ISBN)
53,95 inkl. MwSt
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

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.

CHAPTER 1 Introduction to Power Query

CHAPTER 2 Basic Data Preparation Challenges

CHAPTER 3 Combining Data from Multiple Sources

CHAPTER 4 Combining Mismatched Tables

CHAPTER 5 Preserving Context

CHAPTER 6 Unpivoting Tables

CHAPTER 7 Advanced Unpivoting and Pivoting of Tables

CHAPTER 8 Addressing Collaboration Challenges

CHAPTER 9 Introduction to the Power Query M Formula Language

CHAPTER 10 From Pitfalls to Robust Queries

CHAPTER 11 Data Profiling

CHAPTER 12 Basic Text Analytics

CHAPTER 13 Advanced Text Analytics: Extracting Meaning

CHAPTER 14 Query Diagnostics

CHAPTER 15 Power Query Online

CHAPTER 16 Final Project: Combining It All Together

Erscheinungsdatum
Reihe/Serie Business Skills
Verlagsort Boston
Sprache englisch
Maße 180 x 225 mm
Gewicht 792 g
Themenwelt Informatik Datenbanken Data Warehouse / Data Mining
Informatik Office Programme Excel
ISBN-10 0-13-811579-6 / 0138115796
ISBN-13 978-0-13-811579-1 / 9780138115791
Zustand Neuware
Informationen gemäß Produktsicherheitsverordnung (GPSR)
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Datenanalyse für Künstliche Intelligenz

von Jürgen Cleve; Uwe Lämmel

Buch | Softcover (2024)
De Gruyter Oldenbourg (Verlag)
74,95
Daten importieren, bereinigen, umformen und visualisieren

von Hadley Wickham; Mine Çetinkaya-Rundel …

Buch | Softcover (2024)
O'Reilly (Verlag)
54,90