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.
When is the book avaiable for download?
Hi Matthew,
thanks for the interest! We hope around April 1st.
Thanks,
Kasper
What will it cover? I’m looking for advanced DV?
Hi Kasper,
Any update on the release date?
Will it be also available as ebook download?
Thanks,
Manos
We hope to go to print this week so it should be available soon and it will be available as ebook as well.
Where can we buy the ebook? Only through Amazon or can we download the PDF from another site now?
Yes only through Amazon right now. The book is at the printer right now so it will come soon 🙂
we are still waiting…
Hi all,
I have pre ordered the book on Amazon and i just received a mail with a new delivring date : 15 of July !
In the beginning the book should have been ready for 14 april and then 15 may and now 15 of july.
What’s happened with the book ?
Thank you.
The book has been printed and is now making its way through the bowels of distributors and Amazon. I don’t think the actual date will be July 15th but earlier but I am not sure either.
Thats great its printed but I only want the PDF of Kindle version. Surely that available now if it has already been printed! Where can I get this from? I have checked Holy Macro books web page and it is not there…
Hi Brent,
Let me check, I don’t know how this works either. I think the releases are related.
Thanks,
Kasper
I am looking for a electronic version of this book and holy macro doesn’t seem to have it, Can you please check as i find e books to be more convenient to carry around and refer as opposed to the printed book.
Thanks,
Kris.
It is not there yet, It will soon be available at Amazon
I have ordered the printed book. Will there be a Kindle version available?
/Jens Ole
Hi Jens, yes there will be. Right now there are technical difficulties at the publisher so it will take some time.
IS there a sample database I can download to use with the examples in the book?
Hi Glen, please see http://www.kasperonbi.com/dashboarding-with-excel-and-powerpivot-example-dataset/
Thanks,
Kasper
Hello Kasper,
i´m following the Book : Dashboarding and Reporting with Power Pivot and Excel. I have a question please. On Page 34 you defined a new calculated column [CurrentFyYear]=IF([FyYear]=YEAR([Last Invoice Date]);1;0). In the Book I do not find any defintion for [Last Invoice Date] but [Absolute Last Invoice Date]. can you check please?
Hi Johnson, thank you for finding the first bug of the book. The calculation should be using [Absolute Last Invoice Date]. ill see we get it fixed in the next version.
Thanks,
Kasper
Just checking.
For both the [CurrentFyYear] and [CurrentFyMonth] calculated columns you want use [Absolute Last Inoice Date]?
Currently, they are slightly different, ([Last Invoice Fiscal Date]) and ([Last Invoice FyDate]) but both should be [Absolute Last Inoice Date]?
Thanks Greg, you are right. We missed this in the review. Thanks!
Kasper,
Its late but my numbers are not equaling yours on p 64 for Revenue to target.
Will double check tomorrow but can you have a look.
Thanks.
With fresh eyes and a cup of coffee in the morning, I have matched the results on p 64! ([My Running 12 months]) measure was incorrect.
Onward.
Any reason why the $VTT changes from Figure 4.24 to Figure 4.25?
I missed a step there, in 4.24 I still show RevenueTarget where 4.25 shows the actual VTT. Thanks for reporting these.
Hi, Kasper! I purchased your book and love it. Is there a way I can download the data sets used in the book so I can follow along and practice doing the work along side the narrative in the book?
sure thing, you can find them here http://www.kasperonbi.com/dashboarding-with-excel-and-powerpivot-example-dataset/
Where I Can dowload the files used on book?