Learning Power Query
Adam Szczepan Kopeć
This audiobook is narrated by a digital voice.
DESCRIPTION
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.
Duration - 9h 40m.
Author - Adam Szczepan Kopeć.
Narrator - Digital Voice Madison G.
Published Date - Sunday, 12 January 2025.
Copyright - © 2026 BPB ©.
Location:
United States
Networks:
Adam Szczepan Kopeć
Digital Voice Madison G
BPB Publications
English Audiobooks
Findaway Audiobooks
Description:
This audiobook is narrated by a digital voice. DESCRIPTION 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. Duration - 9h 40m. Author - Adam Szczepan Kopeć. Narrator - Digital Voice Madison G. Published Date - Sunday, 12 January 2025. Copyright - © 2026 BPB ©.
Language:
English
Title Page
Duración:00:00:15
Copyright Page
Duración:00:01:21
Dedication
Duración:00:00:07
About the Author
Duración:00:02:21
About the Reviewers
Duración:00:02:16
Acknowledgement
Duración:00:01:02
Preface
Duración:00:11:03
Table of Contents
Duración:00:07:47
1. Getting Started with Power Query
Duración:00:00:04
Introduction
Duración:00:00:51
Structure
Duración:00:00:18
Objectives
Duración:00:00:38
Introduction to Power Query
Duración:00:00:25
Data retrieval
Duración:00:00:56
Data transformation
Duración:00:00:46
Loading data
Duración:00:00:27
Advantages and disadvantages of Power Query
Duración:00:01:18
Advantages of Power Query
Duración:00:00:37
Disadvantages of Power Query
Duración:00:00:38
Correct data range
Duración:00:00:57
Characteristics of a correct data range
Duración:00:01:10
Retrieving data from a webpage
Duración:00:14:16
Retrieving data from a .txt file
Duración:00:07:52
Retrieving data from a .csv file
Duración:00:08:41
Importing fixed-width column data
Duración:00:06:19
Conclusion
Duración:00:00:36
Multiple choice questions
Duración:00:02:02
Answers
Duración:00:00:02
2. Advanced Data Connections and Imports
Duración:00:00:05
Retrieving data from tables and named ranges
Duración:00:05:48
Importing data from an Excel file
Duración:00:13:21
Importing data from folders
Duración:00:12:01
Importing data from Access
Duración:00:06:06
Automatic query refresh
Duración:00:00:45
Changing query settings
Duración:00:02:28
Tracking query usage
Duración:00:00:34
VBA auto refresh
Duración:00:03:12
3. Combining Data Queries
Duración:00:00:04
Appending data
Duración:00:00:18
Appending data from three tables with different columns
Duración:00:07:32
Merging data
Duración:00:00:28
Finding the price for all products
Duración:00:06:19
Merging with two criteria
Duración:00:03:31
Summarizing data in merges
Duración:00:04:17
Right join and full join
Duración:00:06:06
Finding common elements in lists
Duración:00:06:17
Merging a query with itself
Duración:00:05:11
Fuzzy merge
Duración:00:03:22
Choosing the best similarity threshold
Duración:00:00:27
Setting the maximum number of matches
Duración:00:00:20
Using a transformation table
Duración:00:01:09
4. Grouping Data
Duración:00:00:03
Basics of grouping
Duración:00:01:22
Sales results summary using grouping
Duración:00:10:27
Ranking with ties
Duración:00:07:49
More functions with grouping
Duración:00:06:06
Searching for functions
Duración:00:05:23
Local grouping
Duración:00:05:40
Data types
Duración:00:00:47
5. Pivot and Unpivot
Duración:00:00:04
Pivoting and unpivoting basics
Duración:00:03:19
First unpivoting of columns
Duración:00:10:31
Splitting combined headers
Duración:00:08:12
Splitting double headers
Duración:00:10:36
Transforming repeated rows to columns
Duración:00:06:36
Single row into multiple rows
Duración:00:06:39
6. Adding Columns
Duración:00:00:03
Calculating and rounding discount
Duración:00:08:58
Splitting data into rows
Duración:00:08:43
Splitting a column by various delimiters
Duración:00:07:06
Column from examples
Duración:00:11:41
Calculating work time
Duración:00:05:57
Rounding time
Duración:00:05:18
7. Logical Operations and Conditional Columns
Duración:00:00:06
Overtime hours
Duración:00:10:04
Logical operators combining multiple tests
Duración:00:04:28
Grading with nested if
Duración:00:05:28
Grading with appending
Duración:00:03:55
Counting days of absence
Duración:00:07:58
Numbers and errors
Duración:00:10:28
Compare with the previous row using merge
Duración:00:04:31
Compare with the previous row using index
Duración:00:06:27
8. Parameters and Query Parameterization
Duración:00:00:05
Drill down information
Duración:00:02:22
Drill down cells
Duración:00:05:08
Drill down columns
Duración:00:01:57
Drill down rows
Duración:00:01:49
Errors with non-unique keys
Duración:00:02:15
Parameterized query using filter
Duración:00:03:51
List of values
Duración:00:03:14
Query
Duración:00:01:56
Parameterized query using file path
Duración:00:05:37
Parameter M code
Duración:00:01:25
Blank query
Duración:00:02:13
Extracting parameters from a cell
Duración:00:06:14
Parameterized directly in M code
Duración:00:07:29
9. Creating Custom Functions
Duración:00:00:04
Function auto-created on folder import
Duración:00:01:33
Initial import and combination of data from a folder
Duración:00:06:08
Query dependencies
Duración:00:03:13
Modification of query associated with the function
Duración:00:06:45
Transformations in the query that combines data
Duración:00:02:24
Function based on parameterized query
Duración:00:02:02
Importing and preparing the source data
Duración:00:02:14
Handling locale issues and incorrect data types
Duración:00:05:20
Cleaning and standardizing the Name column
Duración:00:05:33
Parameterizing the PDF file path
Duración:00:01:21
Creating a reusable function
Duración:00:01:39
Using the function to process multiple files
Duración:00:02:53
Creating a custom function
Duración:00:04:49
Building the function step by step
Duración:00:03:12
Transforming the query into a function
Duración:00:02:23
Applying the function to a dataset
Duración:00:01:53
10. Examples Using M Language
Duración:00:00:04
Running total
Duración:00:06:33
Sorting by custom lists
Duración:00:10:09
Seller average to overall average
Duración:00:06:34
Removing a dynamic number of top rows
Duración:00:09:29
Remove the last two columns
Duración:00:05:27
Generating pairs
Duración:00:01:28
All vs. all pairing
Duración:00:01:38
Excluding self-matches
Duración:00:01:23
Scheduling matches to ensure all players compete against one another
Duración:00:08:27
Introduction to recursion through factorial
Duración:00:04:33
Tips for efficient M language scripting
Duración:00:01:21
Guidelines for structuring queries
Duración:00:01:48
11. Optimization and Extensions
Duración:00:00:05
View and statistics options
Duración:00:01:16
View options
Duración:00:01:41
Statistic options
Duración:00:05:00
Optimization
Duración:00:07:03
Runtime
Duración:00:00:12
Power Query
Duración:00:00:33
Visual basic for applications
Duración:00:01:46
Power BI Desktop diagnostics
Duración:00:04:09
Power Query extensions
Duración:00:03:36