Why am I passionate about this?
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?
Kasper DeJonge works at Microsoft on the Power Query team. Before joining Microsoft, he was a data analyst, just like you. In this book, Kasper walks a data analyst through the steps of modelling your Excel data and getting it published on a Power BI dashboard. Along the way, his examples are designed to get you up to speed with the important aspects of Power BI.
1 author picked The Absolute Guide to Dashboarding and Reporting with Power Bi as one of their favorite books, and they share why you should read it.
Written by a member of Microsoft's Power BI team, this book provides a practical step by step guide on creating a financial dashboard using Power BI desktop and the PowerBI.com service. The book contains 6 chapters:
Introduction. Here I introduce the book, business intelligence and provide some history on Power BI
Understanding Dashboards and Report. Here we talk about what dashboards and reports are and how they are used in Power BI. Finally we talk about how to decide what to put on your reports and dashboards.
Collecting and preparing data. Here we install Power BI desktop, import data into…
- Coming soon!