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

CHAPTER 1 Introduction to Power Query 1 CHAPTER 2 Basic Data Preparation Challenges 21 CHAPTER 3 Combining Data from Multiple Sources 61 CHAPTER 4 Combining Mismatched Tables 83 CHAPTER 5 Preserving Context 111 CHAPTER 6 Unpivoting Tables 135 CHAPTER 7 Advanced Unpivoting and Pivoting of Tables 155 CHAPTER 8 Addressing Collaboration Challenges 181 CHAPTER 9 Introduction to the Power Query M Formula Language 205 CHAPTER 10 From Pitfalls to Robust Queries 247 CHAPTER 11 Basic Text Analytics 277 CHAPTER 12 Advanced Text Analytics: Extracting Meaning 311 CHAPTER 13 Social Network Analytics 351 CHAPTER 14 Final Project: Combining It All Together 375