From my list on to go from Excel to Power Query and Power BI.
Who am I?
I’ve been running the MrExcel website since 1998 and have written 66 books about Excel. I am an Excel generalist – I know a fair amount about almost every aspect of Excel. But I respect the specialists who become experts on one part of Excel and offer deep knowledge dives into those portions of Excel. Cleaning data with Power Query, calculating “impossible” calculations with DAX, and then presenting them on interactive dashboards are some of the deep dives that you will learn on this list.
Bill's book list on to go from Excel to Power Query and Power BI
Why did Bill love this book?
If you just want to find out if Power Query is for you, this short book, written by the entertaining host of the Excel On Fire YouTube channel will show you what is possible using Power Query. Oz will show you the types of everyday problems that can be solved using the Get & Transform section of the Data tab in Excel. Once you get a taste of what is possible, you will be ready to dive in with Ken Puls’ book.