Power Query Data Cleaning (29 results)

Paperback or Softback. Condition: New. Learning Power Query: Simplify data cleaning and analysis with Excel's most powerful tool (English Edition). Book.

Condition: New.

paperback. Condition: New.

Condition: As New. Unread book in perfect condition.

Condition: New.

Paperback or Softback. Condition: New. Power Query Beyond The User Interface: Solving Advanced Data Cleaning Problems Using M (Colour Version). Book.

Paperback. Condition: Brand New. In Stock.

Condition: New.

Condition: New.

Condition: New.

Condition: As New. Unread book in perfect condition.

paperback. Condition: Good. The spine is bent. The copy shows minor external wear, but is in otherwise clean condition.

Paperback. Condition: Brand New. 246 pages. 8.50x0.52x11.00 inches. In Stock.

paperback. Condition: New. Paperback. Pub Date: 2023-09 Pages: 256 Publisher: China Railway Publishing House Introduction This book arranges the content in the order of basic introduction data cleaning practice skill improvement. It first introduces the basic operations that novices should master. then explains the practical skills of using PowerQuery to clean data. as well as the structuring and grouping and merging operations of query tables. and finally explains the practical operations of understanding the M langua.

paperback. Condition: Very Good. Power Query Beyond The User Interface: Solving Advanced Data Cleaning Problems Using M This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. .

paperback. Condition: Very Good. Shipped within 24 hours from our UK warehouse. Clean, undamaged book with no damage to pages and minimal wear to the cover. Spine still tight, in very good condition. Remember if you are not happy, you are covered by our 100% money back guarantee.

paperback. Condition: New. Paperback. Pub Date: 2023-09 Pages: 304 Publisher: Beijing Institute of Technology Press This book combines multiple typical practical cases to comprehensively and systematically explain the core technology of PowerQueryM function language data cleaning in Microsoft Excel and PowerBI. This book focuses on the four major sections of PowerQueryM function language. namely data types. operators. keywords and functions. This book has 11 chapters and is divided into 3 parts. The first part. Backgro.

paperback. Condition: New. Language:Chinese.Paperback. Pub Date: 2025-04 Pages: 224 Publisher: China Water Resources and Hydropower Press Whether data is exported from a system or manually created forms. it often requires tedious secondary processing. which is particularly time-consuming and labor-intensive. Some problems are even very difficult to solve using ordinary Excel tools. let alone building an efficient and automated data analysis model. Intelligent Data Cleaning and Modeling: From Excel Data to PowerQuery Au.

paperback. Condition: New. Paperback. Pub Date: 2020-11-01 Pages: 212 Publisher: Peking University Press This book introduces in detail the main features of Excels new functional component Power Query in data query and data conversion through the demonstration and explanation of multiple examples Features.?The book is divided into 8 chapters. mainly including the basic functions of the Power Query editor. querying and importing common data types. merging. splitting. calculating. and converting original data. and how to.

paperback. Condition: New. Language:Chinese.Paperback. Pub Date: 2021-01-01 Pages: 264 Publisher: China Water Resources and Hydropower Press Excel Automation PowerQuery Intelligent Data Cleaning and Data Modeling mainly explains how to turn raw data into automated reports. combining a large number of actual cases. In order to allow ordinary Excel users to quickly grasp the core knowledge of Power Query. so as to effectively apply it to actual work and improve work efficiency.?This book introduces various practical appl.

paperback. Condition: New. Paperback. Pub Date: 2022-09-01 Pages: 320 Language: Chinese Publisher: Electronic Industry Press This book mainly introduces the application of Excel business intelligence components Power Query and Power Pivot in data analysis. The book has 11 chapters in total: Chapter 1 introduces Power Query and Power Pivot in Excel. two major business intelligence components and their functions; Chapter 2 to Chapter 6 introduces how to use Power Query to obtain data and process it. mainly including Powe.

paperback. Condition: New. Paperback. Pub Date: 2023-12 Publisher: Beijing Institute of Technology Press Power Query M Function Language: Advanced Practical Practice of Data Cleaning Based on Excel and Power BI combines a large number of teaching examples and logic diagrams to provide an in-depth introduction to Microsoft Excel and Power BI. The operating logic and advanced usage skills of Power Query M functional language data cleaning technology. According to the knowledge structure of Power Query M function language.

paperback. Condition: New. Paperback. Pub Date: 2021-07-01 Language: Chinese Publisher: China Water Conservancy and Hydropower Publishing House Introduction and Application of M Functions in Power Query Data Processing (Case and Video): This book has 10 chapters. with M functions as the main line . combined with a large number of actual cases. introduces the basic grammatical rules of various M functions and their applications in actual data processing. M functions include text functions. date functions. time functions.

Condition: New. Print on Demand.

Condition: New. PRINT ON DEMAND.

Taschenbuch. Condition: Neu. nach der Bestellung gedruckt Neuware - Printed after ordering - In a time where data drives decision-making, Excel continues to be a vital resource for professionals. Power Query greatly enhances its functionality. As businesses increasingly seek automation and scalable solutions, proficiency in Power Query and the M language is a crucial advantage for data practitioners. This book fulfills that demand by combining technical accuracy with practical examples.Beginning with basic transformations and progressing to advanced query logic, parameterization, and custom M solutions, each chapter fosters technical expertise. Readers will discover how to import data from diverse sources, enhance performance, troubleshoot queries, and tackle intricate business problems using clean and efficient M code. The book prioritizes clarity and control, providing alternative methods, performance optimization tips, and refined coding techniques throughout.By the end of the book, readers will be prepared to create Power Query workflows that extend well beyond the GUI. They will not only gain practical experience with the M language but also cultivate the ability to structure, refine, and optimize queries with accuracy, acquiring essential skills for automation and strategic data analysis.WHAT YOU WILL LEARNż Import data from Excel, folders, and various external sources.ż Transform, filter, and reshape data effectively.ż Develop dynamic parameters, lists, and filters driven by queries.ż Construct and repurpose custom M functions for use across different files.ż Apply techniques for ranking, aggregation, and custom sorting.ż Enhance query performance by employing clean and efficient M code.ż Automate complex transformations that exceed the capabilities of the GUI.ż Address business challenges using nested and recursive logic.WHO THIS BOOK IS FORThis book is for data analysts, Excel professionals, financial modelers, and business intelligence developers who want to push Power Query beyond its interface. It supports those shaping data, enabling precise, scalable, and maintainable transformations using M language.

Taschenbuch. Condition: Neu. Learning Power Query | Simplify data cleaning and analysis with Excel's most powerful tool (English Edition) | Adam Szczepan Kopeż | Taschenbuch | Englisch | 2025 | BPB Publications | EAN 9789365891539 | Verantwortliche Person für die EU: Libri GmbH, Europaallee 1, 36244 Bad Hersfeld, gpsr[at]libri[dot]de | Anbieter: preigu Print on Demand.

Taschenbuch. Condition: Neu. nach der Bestellung gedruckt Neuware - Printed after ordering - 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.

Taschenbuch. Condition: Neu. Power Query Beyond The User Interface | Solving Advanced Data Cleaning Problems Using M (Colour Version) | Chandeep Chhabra | Taschenbuch | Englisch | 2025 | Goodly | EAN 9781615470891 | Verantwortliche Person für die EU: Libri GmbH, Europaallee 1, 36244 Bad Hersfeld, gpsr[at]libri[dot]de | Anbieter: preigu Print on Demand.