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!
Responsible by power bi adoption by customers
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 ?
I’ll ask the publisher if he has any ideas.
Dear, can not find the Dax measure file page from your book. can you send me the dax file in your book?
Thanks, this should be fixed now. Sorry for the inconvenience.
You can find the whole file here as well: http://ppivot.us/samples/allmeasures.txt
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
Hi Oded,
The books contains links to the workbook in each chapter. You can find the finished version here: http://ppivot.us/sampl32d
For dataset I am using a changed version of contoso that is not available.
Thanks,
Kasper
Kasper,
Thank you
Oded Dror
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.
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
Same Problem
when I try for the first time to open the power query it will ask for my credentials.
you should be able to cancel out of it, you don’t need to use the Power Query. Which page \ chapter are you at?
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).
thanks Barry and you are right! let me see if we can update the ebook. Thanks!
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”.
thank you, you are right! ill get an update out for the ebook.
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
the book contains links to all the material, you should be able to download it all. Here is the link the finished workbook: http://ppivot.us/samples/ContosoSalesFinished.zip
can’t download file form http://ppivot.us/flie34ss which mentioned in page 11 of the book.
Hi Corinna,
I checked and I think you might have a typo in the link this is the right link and allows you to download: http://ppivot.us/file34ss
Kasper
Can not edit any of the queries as the book states. Get error message to Edit Credentials.
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