Download PowerPivot Alchemy Patterns and Techniques for Excel Bill Jelen Rob Collie 9781615470211 Books
Download PowerPivot Alchemy Patterns and Techniques for Excel Bill Jelen Rob Collie 9781615470211 Books
Download As PDF : PowerPivot Alchemy Patterns and Techniques for Excel Bill Jelen Rob Collie 9781615470211 Books
Rob Collie (PowerPivotPro) and Bill Jelen (MrExcel) join forces in this combined sequel to their best-selling Power Pivot books. Alchemy sets aside the fundamentals of past books and provides a series of practical, easy-to-follow “patterns” for dozens of common analysis, reporting, and dashboarding needs. Three “bonus” chapters introduce you to the newer members of the “Power BI” family – Power Query, Power View, and Power Map. Whether you are starting your transformation from “old school” Excel User to Modern Data Professional or a veteran of the Power BI arts, this book will dramatically expand your data superpowers.
Download PowerPivot Alchemy Patterns and Techniques for Excel Bill Jelen Rob Collie 9781615470211 Books
"This book is game-changing!
I'm part of a small Business Analytics team running herd on all of our national unit's US-level data. The PowerPivot book series has made such a difference for us - we have had to learn PowerPivot on our own, through trial-and-error and keeping our noses buried in books. Rob and Bill have made a huge difference for us - both in wowing our report viewers and in trying to navigate the in's and out's of Powerpivot. I explain to people the difference between a Pivot Table and Power Pivot is comparing a sturdy old work-horse plowing fields to a champion racehorse. Or a family sedan to a Ferrari. Sure they need a firm hand and more finesse, but the performance difference is out of this world.
I simply do not go ANYWHERE without tucking these three books into my laptop bag.
Alchemy is a fantastic followup to DAX because it takes that solid foundation and allows you to build the castles. I also like how it relies heavily on the original PowerPivot PRO website content, refining and clarifying those lessons to make it even more user-friendly.
One glitch I found - or maybe it is a request for future versions? - is some chapters skip over some steps. Perhaps this is assumed to be intuitive on the part of the user, but it seriously tripped me up in the TopN slicer project. Everything was going fantastic but for the life of myself and a colleague, we couldn't get it to sort descending by our slicer metrics. We finally realized that the key to that (the hidden column and the "sort by" filter) was in the previous chapter project.
If there had been a little note bubble in the chapter, reminding self-learners who might not have all the intuitive knowledge where to find those little steps, it would make our lives a lot easier :)
Still, it's a phenomenal book and part of an amazing series. I highly recommend buying the Trifecta - even if you get called an Excel geek with them tucked under your arm when you walk into the office!
I can't wait for the next book to come out - one that includes more about OLAP cubes and especially Pivot Calendars (which are a whole other level of game-changing)!"
Product details
|
Tags : PowerPivot Alchemy Patterns and Techniques for Excel [Bill Jelen, Rob Collie] on . <div><p class= MsoNormal style= MARGIN 0in 0in 0pt >Rob Collie (PowerPivotPro) and Bill Jelen (MrExcel) join forces in this combined sequel to their best-selling Power Pivot books. <I>Alchemy</I> sets aside the fundamentals of past books and provides a series of practical,Bill Jelen, Rob Collie,PowerPivot Alchemy Patterns and Techniques for Excel,Holy Macro! Books,1615470212,Desktop Applications - Spreadsheets,Business intelligence - Computer programs,Business intelligence;Computer programs.,Electronic spreadsheets,Electronic spreadsheets.,Spreadsheet software.,Business intelligence,COMPUTERS / Desktop Applications / Spreadsheets,Computer Books Spreadsheets,Computer programs,Computers,Computers - Spreadsheets,Excel,Microsoft Excel (Computer software)
PowerPivot Alchemy Patterns and Techniques for Excel Bill Jelen Rob Collie 9781615470211 Books Reviews :
PowerPivot Alchemy Patterns and Techniques for Excel Bill Jelen Rob Collie 9781615470211 Books Reviews
- The book itself is great, but I am going to piggyback on two previously logged complaints that moved this from a 5 star to a 3 star review.
1. We need the example files. For the first Power Pivot Pro Book the example files were easy to find - http//www.powerpivotpro.com/book-files-2/ These files made that book a no doubt 5 star because you could work along with the examples - you could break, recreate, expand on, etc all of the data and the book and that transforms it from "reading" to "understanding" which is the whole point. There does not appear to be any posted files for this book (I have spent the better part of the last hour looking) and that limits this book to just the reading part. Test data is desperately needed for this book to have anywhere the impact of the first.
2. the aforementioned lack of color in the printed book. I would call this 5% of the problem (with the files being 95% of the problem) because it really doesn't matter, it cant be easily addressed (in the way the files can) and I didn't even notice until someone else brought it up. - (review from my blog SqlServerBiBlog.com)
There are two relatively new books on the market from Holy Macro! Books. The first thing that I'll point out is that this small publishing company is actually owned by one of the authors, which should tell you something about the ambition and caliber of the guys who are writing them. I have several Power Pivot, DAX and dashboard design books on my shelves. I'm very impressed with both of these books and they've made a valuable addition to my library. Rather than a cursory introduction or restatement of product documentation, they both address real business problems and are based on a body of customer problems and field experience. Now, I have to admit that I'm a little biased. I know Rob Collie and Kasper de Jonge quite well from conferences and community involvement. I've also met Bill a few times and know of his reputation in the industry as a tried and true Excel guru. Rob stared his career at Microsoft on the Excel product team and the group that developed the Power Pivot technology. He's now a consultant and trainer, a Microsoft MVP and an active member of the online community. Kasper's background is the polar opposite of Rob's; he started in the industry, doing consulting and project work and now works for Microsoft on the SQL Server Analysis team responsible for the ongoing development of this technology. I didn't realize this until reading their bios on the Rob's PowerPivotPro site but Kasper actually filled the position at Microsoft vacated by Rob and from my perspective, that was a good transition and a continued partnership of experts who continue to give back to the community. Kasper is also well-known in the industry for his online present, conference presentations and ongoing support of the MVP and professional community. As far as I'm concerned, these two books could be bound together into a single volume that would be a comprehensive guide to Power Pivot design, problem solving and best practices.
In the past two years, I've spent a great deal of my consulting time developing SSAS Tabular models for clients. I've also done a bit of work in Power Pivot but not nearly as much as the IT-centered version of the xVelocity in-memory aggregation engine from Microsoft. So, why am I reviewing books about Power Pivot and not SSAS Tabular? That's simple SSAS Tabular is the IT Pro extension of the Power Pivot foundation. Last year, I reviewed Rob Collie's book "DAX Formulas for PowerPivot A Simple Guide to the Excel Revolution" and it just blew me away. As a learning tool, I found the book to be golden for getting my head around all the basics of DAX even though the focus was on applying it to Power Pivot in Excel rather that Analysis Services. This book is in the same relaxed, conversational voice that he is known for.
I have to admit that at first DAX was a big brick wall for me. I've taught myself a lot of different languages and tools in my career just by being stubborn and persistent. When I started using DAX I got the basics but more challenging problems were just insurmountable. I hounded the known experts; Marco, Alberto, Chris, Darren, Rob and others who were gracious and patient but it took time for that light to turn on and to finally "get it", or at least to get most of the important concepts. If you're like me, you'll work on a problem obsessively, lose sleep, try to approach it from different angles and keep hacking at it until the answer comes. Something I've learned the hard way about DAX is that it's just not something you figure out on your own unless you've seen the solution demonstrated or solved similar problems before.
Three weeks ago, I started reading "Power Pivot Alchemy" which is also a book centered on using the Power Pivot Excel add-in. This time, Rob teamed with Bill Jelen (aka "MrExcel") who is very well-known in the Excel community for his teaching tools and books on just about every facet of Excel. Rob and Bill are a good team which comes through the pages as two very experienced experts giving very qualified advice about solving pertinent problems rather than a typical "how to" or reference book. The book is written in the same casual voice with a lot of personality and humor leading the narrative. This is an excellent book for the moderate to advanced skilled Excel Analyst who needs to create advanced formulas and pivot tables with strong emphasis on best practices and targeted solutions.
I recently picked up Kasper's book on dashboarding and reporting, and I'm finding it to provide very targeted guidance about the best ways to design models, write formulas and reporting and create dashboarding solutions with all of the new integrated features in Excel and Power BI. I think that Microsoft has generally done a good job of talking to their users and building products that solve real problems but there is a bit of Kool Aid drinking that goes on in Redmond. This is especially true among the vast majority of Microsoft employees who spend all of their time on campus writing code and imagining how customers might use their products. In this book, the author demonstrates a perspective based on his community involvement and direct support of Microsoft and partner customers. I know this because Kasper and I have actually worked together to solve some specific customer problems and his assistance as an advocate from the product team has been invaluable.
Someone recently mentioned that I've only given positive book reviews on my blog. I suppose I'm not much of a critic and frankly I just don't have time to review bad books - and I've read - or started to read - several. Occasionally someone I know or work with in the community will ask me to review a book and if I'm not impressed, I'll respectfully decline. The only thing even remotely critical I can say about the format of these books is that some of the graphics seem a bit oversized. It makes me feel like I'm reading the large print edition of the book. Granted, this is a very visual topic and I'd rather have oversized graphics than not enough. - This book is game-changing!
I'm part of a small Business Analytics team running herd on all of our national unit's US-level data. The PowerPivot book series has made such a difference for us - we have had to learn PowerPivot on our own, through trial-and-error and keeping our noses buried in books. Rob and Bill have made a huge difference for us - both in wowing our report viewers and in trying to navigate the in's and out's of Powerpivot. I explain to people the difference between a Pivot Table and Power Pivot is comparing a sturdy old work-horse plowing fields to a champion racehorse. Or a family sedan to a Ferrari. Sure they need a firm hand and more finesse, but the performance difference is out of this world.
I simply do not go ANYWHERE without tucking these three books into my laptop bag.
Alchemy is a fantastic followup to DAX because it takes that solid foundation and allows you to build the castles. I also like how it relies heavily on the original PowerPivot PRO website content, refining and clarifying those lessons to make it even more user-friendly.
One glitch I found - or maybe it is a request for future versions? - is some chapters skip over some steps. Perhaps this is assumed to be intuitive on the part of the user, but it seriously tripped me up in the TopN slicer project. Everything was going fantastic but for the life of myself and a colleague, we couldn't get it to sort descending by our slicer metrics. We finally realized that the key to that (the hidden column and the "sort by" filter) was in the previous chapter project.
If there had been a little note bubble in the chapter, reminding self-learners who might not have all the intuitive knowledge where to find those little steps, it would make our lives a lot easier )
Still, it's a phenomenal book and part of an amazing series. I highly recommend buying the Trifecta - even if you get called an Excel geek with them tucked under your arm when you walk into the office!
I can't wait for the next book to come out - one that includes more about OLAP cubes and especially Pivot Calendars (which are a whole other level of game-changing)!
Comments
Post a Comment