Too many options? Treat your friends and family to their favourite stores with a Bayshore Shopping Centre gift card, redeemable at participating retailers throughout the centre. Click below to purchase yours today!Purchase Here
*Product information may vary - to confirm product availability, pricing, shipping and return information please contact Coles
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.
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.
Coles is renowned for its outstanding customer service and great selection of books. Along with the vast array of magazines, stationary, audio-books, children's literature, fiction, non-fiction and reference books, you can find accessories to make your reading experience more pleasurable. We can recommend the very best in reading today. We will help you search our titles for exactly what you need, and if we do not have it in stock, we will order it for you.