Master Your Data with Power Query in Excel and Power BI

By Ken Puls, Miguel Escobar,

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

Book 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…

When you buy books, we may earn a commission that helps keep our lights on (or join the rebellion as a member).

Why read it?

1 author picked Master Your Data with Power Query in Excel and Power BI as one of their favorite books. Why do they recommend it?

Microsoft quietly slipped the Get & Transform tools onto the Data tab in Excel in 2016. These tools are incredibly powerful – you clean your data once and Excel will remember how to clean your data every month, every week, every day, every hour. Ken Puls and Miguel Escobar will show you all of the best tricks for using these tools.

Want books like Master Your Data with Power Query in Excel and Power BI?

Our community of 12,000+ authors has personally recommended 10 books like Master Your Data with Power Query in Excel and Power BI.

Browse books like Master Your Data with Power Query in Excel and Power BI

Book cover of Cleaning Excel Data With Power Query Straight to the Point
Book cover of The Absolute Guide to Dashboarding and Reporting with Power Bi: How to Design and Create a Financial Dashboard with Power Bi - End to End
Book cover of Supercharge Power BI: Power BI is Better When You Learn To Write DAX

Share your top 3 reads of 2024!

And get a beautiful page showing off your 3 favorite reads.

1,586

readers submitted
so far, will you?

5 book lists we think you will like!

Interested in Power Pivot, Microsoft Power BI, and big data?

Power Pivot 7 books
Big Data 29 books