Название: Collect, Combine, and Transform Data Using Power Query in Power BI and Excel, 2nd Edition
Автор: Daniil Maslyuk, Gil Raviv
Издательство: Microsoft Press/Pearson Education
Год: 2025
Страниц: 634
Язык: английский
Формат: epub
Размер: 34.9 MB

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.

Power BI, Excel, Fabric, and Power Platform share a game-changing data connectivity and transformation technology, Power Query, that empowers any person with basic Excel skills to perform and automate data importing, reshaping, and cleansing. With simple UI clicks and a unified user experience across wide variety of data sources and formats, you can resolve any data preparation challenge and become a master data wrangler.

In this book, you will tackle real data challenges and learn how to resolve them with Power Query. With more than 70 challenges and almost 200 exercise files in the companion content, you will import messy and disjointed tables and work your way through the creation of automated and well-structured datasets that are ready for analysis. Most of the techniques are simple to follow and can be easily reused in your own business context.

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!

Assumptions:
Prior knowledge of Power BI or Excel is expected. While any Excel user can benefit from this book, you will gain much more from it if you meet one of the following criteria:

• You frequently copy and paste data into Excel from the same sources and often need to clean that data.
• You build reports in Power BI or Excel that are connected to external sources, and wish to improve them.
• You are familiar with PivotTables in Excel.
• You are familiar with Power Pivot in Excel and wish to simplify your data models.
• You are familiar with Power Query and want to move to the next level.
• You develop business applications by using Power Apps and need to connect to data sources with messy datasets.
• You are a developer in Analysis Services and wish to speed up your ETL development.

Who this book is for:
This book was written to empower business users and report authors in Microsoft Power BI and Excel. The book is also relevant for SQL Server developers and Fabric analytics engineers who wish to speed up their ETL development. Users who create apps by using Microsoft Power Apps can also take advantage of this book to integrate complex datasets into their business logic.

Whether you develop Power BI reports for your corporation or you are in charge of repetitive data preparation tasks in Excel, this book is for you. Analysts, business intelligence specialists, and ETL developers can boost their productivity by learning the techniques in this book. As Power Query technology has become the primary data stack in Excel, and as Power BI adoption has been tremendously accelerating, this book will help you pave the way in your company and make a bigger impact.

The book was written to empower all Power Query users. Whether you are a new, moderate, or advanced user, you will find useful techniques that will help you move to the next level.