I am really happy to announce that I am working on a book called “Dashboarding and Reporting with Power Pivot and Excel: How to Design and Create a Financial Dashboard with PowerPivot – End to End” it will release on April 1st with Bill Jelen’s Holy Macro! Books.
The book is written for the user who wants to get started with Dashboarding and reporting using Power Pivot and Excel. This book will not cover all the features in Power Pivot or Excel and DAX. there are already some great books out there that take care of that.
The book we will provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Excel, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports, including year-to-date, variance-to-target, percentage-of-total, and running totals reports. In the book we will follow Jim the business analyst on his journey from importing data, preparing the data into the model, creating the dashboard to sharing the end result on SharePoint and Power BI.
The book will read as a story that offers the reader a practical, real-world scenario and can be used as a day-to-day reference. Though the guide focuses on features that can be used in both Power Pivot for Excel 2010 and 2013, a chapter that discusses Power View—compatible with Excel 2013— and Power BI is also included.
It’s already available for pre-order on Amazon here.