No clue. When I was looking for stuff on dimensional modeling, everything came back to Kimball. So just bought the latest version. I’d imagine for PBI either version would be good as the basics probably havent changed all that much.
Not so much books to recommend but a site - http://www.packtpub.com
order ebooks, print books and videos but the best part -
black friday (at least the past few years) - every ebook/video $5.
The sales usually lasts through the start of the new year.
They also have a club with access to all e-material - $10/month, $99/year
Ralph Kimball and Margy Ross co-authored the third edition of Ralph’s classic guide to dimensional modeling. It provides a complete collection of modeling techniques, beginning with fundamentals and gradually progressing through increasingly complex real-world case studies.
The book significantly enhances and expands upon the concepts and examples presented in the earlier editions of The Data Warehouse Toolkit.
New chapter with the “official” library of the Kimball dimensional modeling techniques Expanded coverage of advanced dimensional modeling patterns for more complex real-world scenarios, including bridge tables for ragged variable depth hierarchies and multivalued attributes Sample data warehouse bus matrices for 12 case studies Enhanced slowly changing dimension techniques type 0 through 7 Recommended best practices for big data analytics Guidance regarding collaborative, interactive dimensional modeling design sessions with business stakeholders Updated overview of the Kimball DW/BI project lifecycle methodology Comprehensive review of extract, transformation, and load (ETL) systems and design considerations, including 34 subsystems and techniques to populate dimensional models
Just received the first 2 books but couldn’t find the third one in Amazon Canada . Time to dive into the world of Statistics.
Third book is still just available only as an e-book. Publication expected in hardcopy later this month. I subscribe to his newsletter, so will post a message on the thread when the third book becomes available.
Please let me know what you think of the first two. I hope you enjoy them.
Also not books, but your post about the Packt Black Friday sale (which I did not know about) reminded me of two other big Black Friday sales.
For those of you looking to supplement the eDNA training, SQLBi and Power Query Academy both run incredible discounts the week of Thanksgiving/Black Friday. Last year, I picked up both the full SQLBi DAX series and the full PQA series for a fraction of the original total cost.
@MudassirAli and others interested,
Just got an update from Jim Frost that his third book in the series discussed above is now available in hardcopy through Amazon:
Regression Analysis: An Intuitive Guide for Using and Interpreting Linear Models , Jim Frost, October 2020
That’s awesome. I will have to buy the book now because
"I want to play in everyone else’s backyard"
Just my two cents here - What I liked about Kimball’s book are the chapters on different industries or business processes and the specific challenges they present to data warehouse designers. When I was taking data warehousing courses back in mid-2001 (when reporting via corporate data warehouses were hitting their stride), we used this book as part of the program. I still pick it up today when I’m trying to solve for specific modeling issues either in Power BI or Power Pivot. I would like to believe the updated version deals with the advanced topics of snowflaking (there’s a bit of that in my book version but more warnings than examples) a star schema or how and when to use a double star schema.
The Greg Deckler book is pretty outstanding, some of his DAX gives me a sore head as I try to follow it haha! I love how the book is set up.
Received the Regression Analysis Book Today.
Start of new adventure.
. Got my hardcopy late last week. What did you think of the first two?
I haven’t started the 2nd one yet. I liked the first one as it helped in building the foundation in Statistics. Starting the 2nd one from today and I know I will keep peeking into the 3rd one often.