Book “Dashboarding and Reporting with Power Pivot and Excel” coming to you this spring!

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.

28 Replies to “Book “Dashboarding and Reporting with Power Pivot and Excel” coming to you this spring!

  1. We hope to go to print this week so it should be available soon and it will be available as ebook as well.

  2. 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.

  3. 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.

    1. 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…

      1. Hi Brent,

        Let me check, I don’t know how this works either. I think the releases are related.

        Thanks,
        Kasper

  4. 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.

    1. Hi Jens, yes there will be. Right now there are technical difficulties at the publisher so it will take some time.

  5. 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?

    1. 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

  6. 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]?

    1. I missed a step there, in 4.24 I still show RevenueTarget where 4.25 shows the actual VTT. Thanks for reporting these.

  7. 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?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.