Ebook: Power BI for the Excel Analyst

Your Essential Guide to Power BI

There are amazing books on DAX, Power Query, Visualisations and more. This book is the one you should read before reading those. I wanted this book to cover the whole Power BI experience. Starting with Power Query, moving to data modelling, DAX, publishing and sharing, report design and other additional important features. Mastering Power BI is a multi-year journey but learning the best practice principles from this book will give you a jump start and a solid foundation on which to build.

I approached this book from the viewpoint of an Excel user starting to use Power BI. There are millions of people in this space, plus this was my journey so I teach from personal experience. I have a chapter dedicated to explaining how the core Power BI functionality can also be applied to your Excel reports. You don’t have to choose between Excel or Power BI, both are amazing, and both continue to evolve at a dizzying pace.

Each chapter has step-by-step instructions covering the key topics and features. There are data sources and example files for you to download if you want to practice hands on. Alternatively, just read along, I wanted this book to be printed in colour and be rich with screenshots so that you don’t have to do the exercises to understand what is happening if that’s your preference.