Power Query Beyond The User Interface: Solving Advanced Data Cleaning Problems Using M

— —

Chandeep Chhabra

Power Query Beyond The User Interface

Solving Advanced Data Cleaning Problems Using M

Chandeep Chhabra

$62.99

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Holy Macro! Books
01 June 2025

Spreadsheet software; Database design & theory; Information architecture

About the Book This book is a practical guide for business users who rely on Microsoft Power Query to clean and transform messy data. It explains how to go beyond the user interface by focusing on the M language behind Power Query. This is not a conventional textbook. Three key things set it apart: 1. It shows how to think and build solutions, not just how to use M functions. Readers can apply what they learn to their own data. 2. It includes practical, real-life examples from different industries, along with exercises at the end of each chapter to reinforce understanding. 3. It has plenty of illustrations and diagrams at each step so you can follow along even without being at your computer. The book starts with foundational concepts like working with lists, tables, and records, then covers advanced topics such as nested tables, iterations, custom functions, and common data cleaning patterns. Who Is This Book For?

You already know the ""clicks"" of Power Query, either in Excel or Power BI.

You already know how to create basic queries that can combine data, remove columns, filter, and unpivot rows.

You have come across a few data cleaning problems that make you wonder, ""How am I going to do that?"" Whether you're new to Power Query or already know the basics, this book will help you use this powerful data transformation tool more effectively.

By: Chandeep Chhabra
Imprint: Holy Macro! Books
Country of Publication: United States
Dimensions: Height: 254mm, Width: 203mm, Spine: 12mm
Weight: 544g
ISBN: 9781615470815
ISBN 10: 1615470816
Pages: 275
Publication Date: 01 June 2025
Audience: General/trade , ELT Advanced
Format: Paperback
Publisher's Status: Active

Chandeep is a seasoned expert in data analysis and Business Intelligence with a deep proficiency in Excel and Power BI. He runs a popular YouTube channel ""Goodly"" with over 100K subscribers and 30K LinkedIn followers. His channel is recognised for producing high quality content and making complex topics simple to understand. Over the last 10+ years, his online courses have received raving reviews and thousands of students have benefited from his unique teaching style, clear explanations and practical examples based on real-world business scenarios. He is a speaker at international Excel conferences like the Global Excel Summit in London and Bulgaria Excel Days in Sofia. Chandeep's unique background includes 4+ years of experience in financial analysis and investment banking. He is currently the Founder and Principal Partner at Googly Insighs, a Data Analytics and consulting firm that specializes in Power BI and Excel-based solutions for companies around the world.