Power Query Beyond The User Interface
eBook - ePub

Power Query Beyond The User Interface

Solving Advanced Data Cleaning Problems Using M

  1. English
  2. ePUB (mobile friendly)
  3. Available on iOS & Android
eBook - ePub

Power Query Beyond The User Interface

Solving Advanced Data Cleaning Problems Using M

About this book

You've already transformed your data (along with your life) by learning Power Query. This book will take that transformation a lot further by teaching you the M language that sits behind Power Query's User Interface. The book will teach you how to think in Power Query. Using a lot of images, concept diagrams and some silly jokes to make you feel at home, as if you and the author were really working through examples in your living room over a coffee.

Trusted by 375,005 students

Access to over 1.5 million titles for a fair monthly price.

Study more efficiently using our study tools.

Information

Publisher
Holy Macro! Books
Year
2025
Topic
Computer Science
eBook ISBN
9781615471676
Subtopic
Data Modelling & Design
Index
Computer Science

Table of contents

  1. Power Query Beyond the User Interface Solving Advanced Data Cleaning Problems using M
  2. Foreword
  3. Dedication
  4. Acknowledgments
  5. Introduction
  6. Contents at a Glance
  7. Chapter 0: Warming Up
  8. Chapter 1: Working with Lists
  9. Chapter 2: Working with Records
  10. Chapter 3: Working with Tables
  11. Chapter 4: Navigation
  12. Chapter 5: Manipulating Between Lists, Records, and Tables
  13. Chapter 6: If...then...else
  14. Chapter 7: Iteration
  15. Chapter 8: Custom Functions
  16. Chapter 9: Errors
  17. Chapter 10: Nested Tables
  18. Chapter 11: Patterns and Recipes
  19. Chapter 12: Miscellaneous Tips and Tricks
  20. Solutions
  21. Index

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn how to download books offline
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.5M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1.5 million books across 990+ topics, we’ve got you covered! Learn about our mission
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more about Read Aloud
Yes! You can use the Perlego app on both iOS and Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Yes, you can access Power Query Beyond The User Interface by Chandeep Chhabra in PDF and/or ePUB format, as well as other popular books in Computer Science & Data Modelling & Design. We have over 1.5 million books available in our catalogue for you to explore.