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