PowerBI examples?

A dedicated forum to help people when working through the book "Learn to Write DAX"
jetboy2k
Posts: 5
Joined: Thu Jan 12, 2017 3:05 am

PowerBI examples?

Postby jetboy2k » Thu Jan 12, 2017 3:11 am

I'm using Office 365 Home which, of course, doesn't support PowerPivot in Excel.

Does Learn to Write DAX include samples and examples in PowerBI, or is it mainly focused on PowerPivot? I've found it becomes harder to follow the examples in books if I'm not able to actually replicate the work myself in sample data.

Thanks.

MattAllington
Posts: 898
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: PowerBI examples?

Postby MattAllington » Sat Jan 14, 2017 1:34 pm

The book was written using Excel as the primary visualisation tool. The concepts around table design, structure, relationships, dax however are identical in all versions of excel and Power BI. In addition I teach many tips about pivot tables and other visuals in a Excel, and non of this is transferable (although most it is reusable in standard Excel).

Here are some options.

1. You could use Power BI desktop and use the table or matrix as the visual. Read the last coup,e of chapters about Power BI fist so you are clear on the differences.
2. You could use Power BI desktop to do the modelling and write the measures and then use the technique I describe in my blog here to build the visuals in Standard Excel. http://exceleratorbi.com.au/excel-workb ... i-desktop/

Have you purchase the book yet? If not, you can purchase it from my shop and try it out. If you are not happy that you are getting the benefit, then let me know and I will refund your money. Just pm me your email address so I know who you are, or contact me ththrough my website.
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

jetboy2k
Posts: 5
Joined: Thu Jan 12, 2017 3:05 am

Re: PowerBI examples?

Postby jetboy2k » Tue Jan 17, 2017 3:22 am

Matt, thank you. I have not purchased Learn to Write DAX, but I did purchase the PowerPivot and Power BI book (I'm a member of the Seattle Excel Users meetup group, which Avi is involved with personally, and he was selling the books there at a discounted price). It's a good book, but I'm not able to actually work the examples because all of the data is provided in PowerPivot tables which, because I'm using Office 365 Home, I can't access. As a result, the value of the book is limited because it becomes somewhat difficult to follow if you're just reading the text, rather than being able to do the exercises and see the results directly,

That being the case, while Learn to Write DAX looks like a good book as well, I think I'd run into the same limitations. It's frustrating that no one appears to have written a book on DAX using Power BI as the visualization/examples context.

Thanks.


Return to “Help with the Book "Learn to Write DAX"”

Who is online

Users browsing this forum: No registered users and 1 guest