What is Reddit's opinion of
Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills)?
From 3.5 billion Reddit comments
By popularity on Reddit, this product is:
7 reviews of this product found across Reddit:
Marco Russo’s book brought me from average PBI dev to team lead … if you thought DAX was rough before, wait until you find out about all the implicit bullshit under the hood!
https://www.amazon.ca/Definitive-Guide-DAX-intelligence-Microsoft/dp/073569835X
First, thank you for the taking the time to respond to my question - I really appreciate it. Second, congratulations on receiving the MCSA: BI Reporting badge!
The reason I am struggling to prepare for this exam is because there is no real comprehensive prep course like there is for the CPA exam. There's no "Becker for MCSA: BI Reporting". Can you share how you went about preparing for these exams? I feel like I have learned a lot from edX but not enough to pass the exam and I cannot find any additional practice questions/tests to study - anywhere. Do you have any insight on this?
Yes, the edX Excel course was very good and has significantly improved my Excel skills. However I am still unsure what to expect as far as test questions are concerned. Are they similar to the ones on the edX course?
As far as DAX and M, I assume DAX will be more heavily tested on the Power BI exam then the Excel one. Would you say that's correct? At the moment, my DAX skills are limited because I haven't been able to sit down and really run through it yet - but I will do so. I am waiting for my DAX book to come in the mail. M doesn't seem that difficult but nonetheless I have to run through it.
Again, thank you for your insight - I really appreciate it!
It looks like there is a second edition of the book on Amazon but it is 1-3 months from delivery? Is the 1st edition enough?
The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills) https://www.amazon.com/dp/073569835X/ref=cm_sw_r_cp_api_i_pIrECbK2S62TG
The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (2nd Edition) (Business Skills) https://www.amazon.com/dp/1509306978/ref=cm_sw_r_cp_api_i_nGrECb8VXVB3R
If you want to learn a lot about PowerPivot and (don't mind reading) I'd recommend anything written by Alberto Ferrari and Marco Russo. They write on PowerPivot / SSAS / Power BI for the Microsoft Press. One of their books was recommended by Michael Alexander who's a Microsoft MVP (I think for Access, but he also knows Excel very, very well.) Take a look at a few of the books below:
https://www.amazon.com/Definitive-Guide-DAX-intelligence-Microsoft/dp/073569835X/ref=asap_bc?ie=UTF8
I only read a bit of their 2013 book, but it's very comprehensive and of high quality.
I also want to discuss a few other things mentioned here in the comments: PowerPivotPro by Rob Collie and SQLBi. Rob Collie is a former Microsoft engineer on Excel, is an expert on it, and still talks to many engineers on the Excel team. And SQL Bi is run by Marco Russo, who I mentioned above.
Popular alternatives to Definitive Guide to DAX, Th...
How to Lie with Statistics
Factfulness: Ten Reasons We're Wrong About the World--and Why Things Are Better Than You Think
