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