Puls K. et al. Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow

2nd.ed. - Holy Macro! Books, 2021 - 386p. - ISBN: 1615470581Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Do you find yourself performing the same data cleansing steps day after day? Power Query will make it faster to clean your data the first time. While Power Query is powerful, the interface is subtle—there are tools hiding in plain sight that are easy to miss. Go beyond the obvious and take Power Query to new levels with this book.The Data Revolution
Power Query Fundamentals
Query Management
Data Types and Errors
Moving Queries Between Excel & Power BI
Importing from Flat Files
Importing Data from Excel
Simple Transformation Techniques
Appending Data
Combining Files
Merging Data
Web Based Data Sources
Relational Data Sources
Reshaping Tabular Data
Conditional Logic in Power Query
Power Query Values
Understanding the M Language
Parameters and Custom Functions
Date and Time Techniques
Query Optimization
Automating Refresh