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?
Rob Collie was a pioneer at Microsoft. After leaving the Excel team, he helped architect the tools that would become Power Pivot and Power BI. He left Microsoft and started his own consultancy, helping big companies answer important questions in just a few hours with Power Pivot.
His books are the best-selling books in the category.
While Matt Allington will get you up to speed, Rob will explain every nuance of Power Pivot, DAX, and Power BI.