New book “The Absolute Guide to Dashboarding and Reporting with Power BI” is now available.

I am very happy that my new book has been released today! This is a brand new update to the book I released 5 years and now covers everything Power BI. You can order the ebook (a DRM-free copy of the book in all three popular e-book formats: PDF, ePub and Mob) or printed version directly from the publisher here. You can also get it on Amazon of course but the prices are a bit higher there and only open on Kindle or Kindle app.

The new version of the book is an update to the previous one that covered Excel and Power Pivot and v1 of Power BI. In the new book I provides a practical step by step guide on creating a financial dashboard using Power BI desktop and the PowerBI.com service.

Contents

The book contains 6 chapters:

  • 1 Introduction. Here I introduce the book, business intelligence and provide some history on Power BI
  • 2 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.
  • 3 Collecting and preparing data. Here we install Power BI desktop, import data into Power BI and do some mashup using Power Query. We also discuss data modelling tips and tricks and start with some DAX (can’t have a book without DAX right :)).
  • 4 Building the main report. Here we will create the main report in Power BI Desktop, using the data model he set up in Chapter 3. We create various data visualizations needed for his report (and talk about which visualization to use when).
  • 5 Building detailed reports. Here we dive into more detailed report building with more DAX examples, sync slicer, custom visuals defining crossfiltering.
  • 6 Sharing dashboards and reports within and organization. In this Chapter we are going to upload our report to PowerBI.com and collaborate with others on our solution using workspaces. Finally we will distribute it to the users in our organization with Apps.

This will provide a full end to end overview of all the steps in Power BI including downloads for all the steps and samples. I hope you enjoy it!

23 Replies to “New book “The Absolute Guide to Dashboarding and Reporting with Power BI” is now available.

  1. Nice job , thanks for this scientigic articles , but There is no way to download this book , im from iran and we cant pay with paypall and other accounts , i need this book , how i can download it ?

  2. Kasper,

    What data source do you use?
    Can you give us a link please
    What about the power bi files that uses in this book?

    Thanks,
    Oded Dror

  3. I bought the book. How do you load the files to your local directory – Since it is a server database it won’t allow me to connect.

    1. Hi Craig,

      You shouldn’t have to connect to the database or load data. The sample files already contain the data and changing it should not be needed if you follow along.

      Hope that helps,
      Kasper

          1. you should be able to cancel out of it, you don’t need to use the Power Query. Which page \ chapter are you at?

  4. Hi Kaspar,
    I am really enjoying this book.
    There may be a logic error:
    “He can use the DAX RELATED function to look up the fiscal date information from the Calendar table for each invoice date by using the table relationship. In the Fields pane, Jim right-clicks on the Calendar table and clicks New Column.”
    I think that Jim should have right-clicked on the Invoice table as the formula requires that the new column is related to the Calendar table. That’s what I did and it worked (after getting an error when trying to add the column to the Calendar table).

  5. Above fig. 3.52 there is this text “These calculated columns compare the values from the current FyYear and FyMonth columns in the DateTable table…”.
    I think it should be “Calendar table” instead of “DateTable table”.

  6. Dear Kasper,
    just bought the book. I am a visual guy. Ready the book without practicing/following along with Jim.
    how could I upload/download this file in my PowerBI Desktop.
    It is link o installation process?
    Thank you,
    Thierry

    1. Hi J,

      That is correct, you cannot change the queries as you don’t have access to the database. You should be able to download a updated version that has all the steps applied. Once the modelling starts you can follow along.

      Kasper

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.