HAPPY BOOKSGIVING
Use code BOOKSGIVING during checkout to save 40%-55% on books and eBooks. Shop now.
This eBook includes the following formats, accessible from your Account page after purchase:
EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
PDF The popular standard, used most often with the free Acrobat® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Also available in other formats.
Register your product to gain access to bonus material or receive a coupon.
Transform your data analysis experience with Power Query, the ultimate tool for importing, reshaping, and cleansing data through a user-friendly interface. Whether youre using Power BI, Excel, or other Microsoft products, Power Querys 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, youll delve into comprehensive analytics challenges, seamlessly integrating your skills into a realistic, final project. By the end, youll possess the expertise to handle any data and convert it into actionable insights.
You will learn how to:
About This Book
Follow the instructions to download this book's companion files.
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