An Ihren Kindle oder ein anderes Gerät senden


Kostenlos testen

Jetzt kostenlos reinlesen

An Ihren Kindle oder ein anderes Gerät senden

Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Keine Abbildung vorhanden

DAX Formulas for PowerPivot: A Simple Guide to the Excel Revolution [Kindle Edition]

Rob Collie
3.7 von 5 Sternen  Alle Rezensionen anzeigen (3 Kundenrezensionen)

Kindle-Preis: EUR 13,32 Inkl. MwSt. und kostenloser drahtloser Lieferung über Amazon Whispernet

Kostenlose Kindle-Leseanwendung Jeder kann Kindle Bücher lesen  selbst ohne ein Kindle-Gerät  mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.

Geben Sie Ihre E-Mail-Adresse oder Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 13,32  
Taschenbuch EUR 30,23  



Microsoft’s Power Pivot is an add-on to Excel that enables you to produce new kinds of reports and analyses that were simply impossible before. This book is the first to tackle DAX formulas, the core capability of Power Pivot, from the perspective of the Excel audience. Written by a leading Power Pivot educator (and former leader on the Power Pivot and Excel teams at Microsoft), the book’s concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce.
In this book you will learn how Power Pivot: 
1) Gives you “portable” formulas that can be re-used across multiple different reports with a single click.
2) Removes the need to ever write a VLOOKUP formula again.
3) Allows you to add smart calculations to pivots, such as “Year over Year” and “Moving Averages” which auto-adjust as the pivot changes.
4) Effortlessly merges disjointed sets of data into unified insight.
As a bonus, Power Pivot and DAX formulas are both the heart AND brain of Microsoft’s “Power BI” system, giving us a long-needed bridge between the worlds of Excel and Business Intelligence – a bridge that any Excel PivotTable user can cross with the help of this easy-to-follow book. Your new career – and your organization’s future – starts within these pages.

Über den Autor und weitere Mitwirkende

A former Microsoft engineering leader, Rob Collie is an entrepreneur, author, and consultant who believes Excel is enjoying a renaissance in power and importance - a trend that provides massive opportunities for the millions of Excel practioners worldwide. His passion is empowering and the Excel Professional to seize those opportunities. When he's not training, consulting, or writing, Rob can be found in his laboratory, devising new tools and techniques for the Excel community. He also operates the world's leading PowerPivot website ( and occassionally sleeps.


Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?


3.7 von 5 Sternen
3.7 von 5 Sternen
Die hilfreichsten Kundenrezensionen
1 von 2 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Perfekt, sehr gründlich, viele Tipps 20. März 2013
Format:Kindle Edition|Verifizierter Kauf
Sehr weitgehende Behandlung der DAX Formeln mit vielen Beispielen,
Sehr sinnvoll um sich Anregungen zu holen wie man mit DAX Formeln umgeht,
Leider noch keine besondere Berücksichtigung der mit Office 2013 eingeführten Version 2 von Power Pivot, sonst wären es 5 * für mich gewesen.
Dennoch ein perfektes Buch für denjenigen der tiefer in PowerPivot einsteigen will - absolute Empfehlung!
War diese Rezension für Sie hilfreich?
0 von 1 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Sehr schöner Einstieg 22. Mai 2014
Format:Kindle Edition|Verifizierter Kauf
Durch die Art, wie Rob Collie seine Erläuterungen aus der Perspektive eines Excel-Nutzers aufbaut, hat man einen ganz anderen Zugang als in anderen Büchern zum Thema. Man kann dann schon einmal recht viele Dinge mit PowerPivot tun, ohne dessen Komplexität vollständig verstanden zu haben. Und mit seinem Schreibstil liest sich das Buch auch sehr gut.
Natürlich kann man geteilter Meinung sein, was die Wichtigkeit und die Chancen mit dem Produkt angeht, aber es macht zum Anderen auch Mut, sich weiter damit zu beschäftigen.
Wenn man es dann richtig ernst meint, kommt man wohl nicht an einem Buch von Ferrari, Russo, Webb vorbei. Aber auch in Excel schreibt nicht jeder gleich Makros, um seine tägliche Arbeit zu erleichtern.
War diese Rezension für Sie hilfreich?
0 von 2 Kunden fanden die folgende Rezension hilfreich
2.0 von 5 Sternen Nice book, but something is wrong with Amazon 31. Oktober 2013
Von Andrey
Format:Taschenbuch|Verifizierter Kauf
Great and usefull book.
I want to mention that in preview book looks in colors... but the one I have reciewed is black and white. Shame you Amazon.
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf (beta) 4.7 von 5 Sternen  100 Rezensionen
43 von 43 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Dangerously Good 1. Dezember 2012
Von Mark Polino - Veröffentlicht auf
I follow the blog of the author, Rob Collie. After seeing the video of the book getting printed I knew that I had to buy it. Oh, that and I'm a big PowerPivot fan and general Excel junkie. The book is a blast. Rob has a great writing style, honest and fun.

First, PowerPivot doesn't put Excel on steroids. Nor does it turbo charge it. Those metaphors fall short. It's more like PowerPivot takes a solid family sedan that you think you know and turns it into a NASCAR race car.

DAX Formulas for PowerPivot walks you through PowerPivot and how to get the most out of it's powerful DAX formulas. This not merely a reference book. It's full of how to's. Plus it's got nice big illustrations. I do have a couple of warnings for this book though:

1) I found myself up very late playing with PowerPivot stuff while reading this book. Don't start the book if something to do the next day, like go to work. Seriously, I'm not kidding.

2) Read the whole book. I had a personal project that coincided with some of the items in the book, so I started the project while reading the book. I ended up rebuilding the project twice as I worked through the examples. In my initial pass, my project was taking more than a minute to reload the data from the database. After following Rob's performance tips at the end, the reload was down to 13 seconds.

3) The short links to more information are case sensitive and contain both upper and lower case letters. Be careful when you type them.

Bottom line, if you use Excel for anything, and you can spell PowerPivot, you owe it to yourself to see what it can really do. This the book to teach you how.
14 von 14 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Very Good Book For Beginners and Those With Some Experience 5. Dezember 2012
Von MD - Veröffentlicht auf
I can't say much more about this book that hasn't been said here or on other blog reviews.

It's a very good book for getting started with PowerPivot if you have never used it before. If you have some PowerPivot experience, but are mostly self taught from blogs and other random sources, then this is a good book to help "fill in the cracks" and consolidate what you already know.

I have read many technical books over the years on everything from Access to Excel to SQL Server to SharePoint...etc. While many have been good, I don't know that I would classify any as "page turners". This book is as close as a technical book can get. Rob has a unique writing style which he has been demonstrating on his blog for several years now. He is gifted at explaining very techinal issues in an easy to follow and engaging manner. One example flows to the next as does each chapter. It doesn't get bogged down in technical details but gives a solid explanation of real world examples.

I can see myself referencing this for years to come.

I will be recommending this to everyone on my team as well as others throughout my company that show an interest in PowerPivot.
13 von 13 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Who would have thought a book could be so useful AND fun to read? 29. März 2013
Von Amazon Customer - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
First let me say that I read several technical books a month, and have reviewed them for Manning Publications on several occasions. So I have some pretty high standards that must be met before I give a book five stars.
I am teaching myself PowerPivot for work, and have Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning which is very thorough, but this book is more helpful. It focuses most on what I know least about--Data Analysis eXpressions, or DAX. It begins with the assumption that the reader is an Excel power user, or "Excel Pro" as the author calls us. It therefore gets right into the material related to PowerPivot, without wasting time or space on things everyone who uses Excel professionally already knows.
The author's writing style is entertaining, turning what could be a very dry topic into something you want to celebrate along with the writer. I love his side remarks, such as: "You will not see me create another implicit measure in this book. They are dead to me."
My only complaint is a formatting one. Much of the text is in a green font that shows as a much lighter gray on the regular Kindle, making it hard to read. Even on the Fire I would have preferred a choice with more contrast.
Despite that little annoyance, the book is a fast, enjoyable read with the information presented effectively and in an order that makes perfect sense to an Excel Pro. I am tempted to go ahead and buy a print copy just to have as a reference for my team, it is that good.
11 von 13 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Wonderful book, highly recommend 3. Dezember 2012
Von Thomas Larock - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
I've known Rob Collie (blog | @powerpivotpro) for over two years now, ever since he accosted me at TechEd in 2010. Since then we've met up at some SQL Saturdays, the 2010 PASS Summit, and we even collaborated on the computing power and hard dollar costs adjusted for inflation. And by "collaborated" I mean "I emailed Rob and asked him to show me what to do". And then he did. True story.

When I read that post on Moore's Law again it made more sense to me this time. The reason why is because I just got done reading his most amazing book: DAX Formulas for PowerPivot: The Excel Pro's Guide to Mastering DAX

When I opened the book to flip through the pages I will admit I was slightly disappointed in what I first saw: a bunch of formulas like CALCULATE(), DATEADD(), and COUNT(X). I thought "Oh, no, Rob has gone and written a book like all the other tech books out there, full of formulas and a desire to be like a textbook that it is likely never going to be." Knowing Rob this surprised me a bit and since I had already spent my money I figured I might as well start reading it anyway.

I started reading his while sipping on my coffee this past Sunday morning. I was done with the book before lunch. Not because it was a short read, but because I just could not put it down.

Rob walks you through what is essentially the training program he uses with clients that want to know how to use PowerPivot. He gives you step by step examples and ties everything back to clearly defined use cases. He mixes in some anecdotal stories along the way, too. Rob worked at Microsoft for many years and as a result he has many, many stories to share. I think the one about Steve Ballmer was my favorite.

Not only does Rob walk you through formulas he also provides specific use cases and shows you the pitfalls that he has stumbled upon through the years. In short you get years of data analysis experience at your disposal in just a few hours of learning. Rob even has an "intermission" in his book where he tells you to "take stock of your new powers", and that you could close the book now and still be four to five times better than you were when you started. I believe him.

Rob did something that I know other authors dream about: he wrote a technical book and made it seem human. He has an uncanny ability to communicate his thoughts and explanations in terms that others can understand. This is how technical books should be written.

I can't recommend this book enough. It represents the future for data professionals. The future isn't about racking servers. It's about getting people access to the data they want, in a meaningful way, and quickly. As a DBA you are already very familiar with data: how it moves, how it's stored, how it should look. Take those skills and start learning how to apply them in a different manner.

Soon you will find your skills in demand in a similar manner to Rob. There is a reason he is so busy these days.

I've added a new shelf to my library named "Data Analytics and Insights" and placed Rob's book there along with a few others that I think you will find useful.

Go have a look at your future.
5 von 5 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen An unusual book (in a good way) 29. November 2012
Von Paul Turley - Veröffentlicht auf
One of the characteristics of a really good, classic movie is that it has a lot of memorable dialog. I could go on for hours quoting one-liners from The Blues Brothers or Princess Bride. Likewise, I think a good book leaves the reader with gems to ponder and to stimulate ideas. Such has been my recent experience reading Rob Collie's "DAX Formulas for PowerPivot, The Excel Pro's Guide to Mastering DAX". The title doesn't have the allure of an action thriller but it's been a while since I've read a book so entertaining and effective at teaching a valuable skill.

I've challenged myself to learn more advanced DAX while honing my skills with PowerPivot and SSAS Tabular Model design. I understand a lot of the basic concepts but I really need to get deep into practical business calculations. But unlike the past few years of my BI career that I've spent using IT development and performance tuning tools, I am finding my self embracing the PowerPivot designer in Excel. In recent BI client work, I see a growing need to help business professionals do their own analysis and self-service reporting. To educate them, I need to think more like those business users.

I have an arsenal of books and resources that are all really good. However, I chose to focus my attention on using DAX in the Excel add-in for now and then I'll come back to the topic of solution architecture and larger-scale design a little later on. For now, I'm reading Rob Collie's book page by page and working through the examples. The pages just ooze with personality and have no shortage of opinion and advice. I like this quote:

"Much like the heat and pressure in the earth's crust seize the occasional pocket of carbon and transform it into a diamond, the demands of the modern world `recruit' a certain kind of person and forge them into an Excel Pro."

...that's profound. This isn't a book written for programmers or IT professionals but for the new generation of Excel business super-users. Rob's book is unlike most of those technical books that decompose a software tool and lay each part on the examining room table, detailing its features and nuances. He tells you what he thinks and how he has used the tool successfully and then moves on without explaining all of the ways to "do it the other way". The pages are full of screen shots, images and diagrams with call-outs and commentary. Reading it makes me feel like he's personally showing me how to access all the cool trap doors and secrets. As a technical book writer, it's very apparent to me that this book - although I'm sure it's been thoroughly proof-read and reviewed, has not been subjected to the rigid formatting rules and unforgiving styling of a large publisher. In places, it's almost like a hand-written manuscript with the author's doodles & personal notes in the margins.

There are a lot of good books on the market about PowerPivot, tabular models in SSAS and DAX. This book focuses entirely on DAX for the Excel professional and teaches DAX calculations and expressions, and not queries. For me, this is the best book I've found to learn how to think like my business clients and to understand the practical application for the self-service BI designer.

More information about this book is available here on the PowerPivot(pro) blog: [...]
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Erster Beitrag:
Eingabe des Log-ins

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen

Ähnliche Artikel finden