What is Reddit's opinion of
The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)?
From 3.5 billion Reddit comments
10 reviews of this product found across Reddit:
Edit: just noticed that Marco finally published the second edition 3 days ago!!!!!!!!
Edit2: u/itsnotaboutthecell warns that we should be careful trusting Amazon’s info.
Read the Bible and realize you know nothing.
Your question is a little vague, but if you’re asking how to create magic in Power BI without being taught how to use a spreadsheet, this is it. It’s not easy, you may realize you know less than you think.
Deal: The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills) https://www.amazon.co.uk/dp/1509306978/ref=cm_sw_r_apan_glt_fabc_dl_QVNW51QKHSFFT1N9KWPV
^ to master DAX. Not just be proficient at it, but to master it. It's the single best resource available.
You'll also want to read up on Power Query as there's many times where you want to transform your data before loading it. You don't need to master Power Query to the same extent as DAX though. A lot of what you need is baked into the Query Editor GUI.
Couple good resources out there. Workout Wednesdays have good Power BI challenges. The first 4 build on each other which was pretty neat but I dropped off since.
The Definitive Guide to DAX is like the new analysts Bible. Lots of great material to better understand filter and row contexts. This will help write DAX like a programmer.
SQLBI (same guys that wrote Definitive Guide to DAX) have a bunch of free tutorials on data modeling scenarios. I haven't taken the DA-100 but if you want to go beyond the basic star schema and learn a few real world examples of what to do when you have two fact tables and when is the right time to make a second date dimension, I highly recommend their free courses.
I have a few other resources I like for Power BI but no others that offer challenges like you asked for. Good luck! Let me know how it goes!
Sure ;)
The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills) https://www.amazon.co.uk/dp/1509306978/ref=cm_sw_r_apan_i_24XCBS2R51MTGVET2RKP
I’m in finance looking to better understand Power BI and after searching I’m starting with these two books:
The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills) https://www.amazon.com/dp/1509306978/ref=cm_sw_r_cp_api_glt_fabc_HRM563JVHWKMVG8GZCVN
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query https://www.amazon.com/dp/1615470344/ref=cm_sw_r_cp_api_glt_fabc_QKSF3EWG49AKZ3Z6ZRM0
I’m starting with the DAX books first as we have some datasets that I could start working with already, so it would give me the more immediate benefit. Then I think I’ll move onto M. I’d also like to learn SQL. Maybe Python eventually.
And their latest book: The Definitive Guide to DAX
Popular alternatives to The Definitive Guide to DAX...
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA, and .NET
