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

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 QueryCHAPTER 2 Basic Data Preparation ChallengesCHAPTER 3 Combining Data from Multiple SourcesCHAPTER 4 Combining Mismatched TablesCHAPTER 5 Preserving ContextCHAPTER 6 Unpivoting TablesCHAPTER 7 Advanced Unpivoting and Pivoting of TablesCHAPTER 8 Addressing Collaboration ChallengesCHAPTER 9 Introduction to the Power Query M Formula LanguageCHAPTER 10 From Pitfalls to Robust QueriesCHAPTER 11 Data ProfilingCHAPTER 12 Basic Text AnalyticsCHAPTER 13 Advanced Text Analytics: Extracting MeaningCHAPTER 14 Query DiagnosticsCHAPTER 15 Power Query OnlineCHAPTER 16 Final Project: Combining It All Together

Select Guide Rating