Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow, 2nd Edition
- Length: 369 pages
- Edition: 2
- Language: English
- Publisher: Holy Macro! Books
- Publication Date: 2019-07-01
- ISBN-10: 1615470581
- ISBN-13: 9781615470587
- Sales Rank: #25180 (See Top 100 Books)
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.
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
Donate to keep this site alive
To access the Link, solve the captcha.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.