Master Your Data with Power Query in Excel and Power BI
Leveraging Power Query to Get & Transform Your Task Flow
Publisher:Packt Publishing Limited
Paid access
|Mar 2025
Table of Contents
- 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
PDF ISBN: 978-1-83664-664-8
Publisher: Packt Publishing Limited
Copyright owner: © 2024 Packt Publishing Limited
Publication date: 2025
Language: English
Pages: 386
Related subjects:
