Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow

Add to Wishlist

Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow

eBook

$14.99

eBook
$14.99

Available on Compatible NOOK devices, the free NOOK App and in My Digital Library.

WANT A NOOK? Explore Now

Buy As Gift

Related collections and offers

Product Details

ISBN-13:	9781836646648
Publisher:	Packt Publishing
Publication date:	09/26/2024
Sold by:	Barnes & Noble
Format:	eBook
Pages:	386
File size:	21 MB
Note:	This product may take a few minutes to download.

About the Author

Holy Macro! Books has been providing top-quality books on Excel, Power Query, and Power BI since 2002. They have published over 100 titles by 30 authors, including numerous Microsoft MVPs.
Miguel Escobar is an Excel and BI specialist and a Microsoft MVP from 2014-2017.
Ken Puls is the controller/director of IT at the Fairwinds Community & Resort. He is a winner of the prestigious Microsoft MVP – Excel award.

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

From the B&N Reads Blog

Page 1 of

Related collections and offers

Product Details

About the Author

Table of Contents

Related Subjects

Customer Reviews