Master Your Data with Power Query in Excel and Power BI
Leveraging Power Query to Get and Transform Your Task Flow
Published on 1. November 2021
387 pages
978-1-61547-241-3 (ISBN)
Description
Power 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.
More details
Other editions
Additional editions
Miguel Escobar | Ken Puls
Master Your Data with Excel and Power BI
Leveraging Power Query to Get & Transform Your Task Flow
Book
11/2021
Holy Macro! Books
€33.00
Shipment within 3-4 weeks
Content
- Intro
- Preface/Forward/Intro
- Foreword
- Chapter 0 - The Data Revolution
- Chapter 1 - Power Query Fundamentals
- Chapter 2 - Query Management
- Chapter 3 - Data Types and Errors
- Chapter 4 - Moving Queries Between Excel & Power BI
- Chapter 5 - Importing from Flat Files
- Chapter 6 - Importing Data from Excel
- Chapter 7 - Simple Transformation Techniques
- Chapter 8 - Appending Data
- Chapter 9 - Combining Files
- Chapter 10 - Merging Data
- Chapter 11 - Web Based Data Sources
- Chapter 12 - Relational Data Sources
- Chapter 13 - Reshaping Tabular Data
- Chapter 14 - Conditional Logic in Power Query
- Chapter 15 - Power Query Values
- Chapter 16 - Understanding the M Language
- Chapter 17 - Parameters and Custom Functions
- Chapter 18 - Date and Time Techniques
- Chapter 19 - Query Optimization
- Chapter 20 - Automating Refresh
- Index
