- ホーム
- > 洋書
- > 英文書
- > Computer / Spreadsheets
Full Description
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
Contents
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
