DAX Formulas for PowerPivot: The Excel Pro's Guide to Mastering Dax (Anglais) Broché – 1 septembre 2012
Rentrée scolaire 2017 : découvrez notre boutique de livres, fournitures, cartables, ordinateurs, vêtements ... Voir plus.
Il y a une édition plus récente de cet article:
Les clients ayant acheté cet article ont également acheté
Quels sont les autres articles que les clients achètent après avoir regardé cet article?
Description du produit
Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.
Pour obtenir l'appli gratuite, saisissez votre numéro de téléphone mobile.
Détails sur le produit
Si vous vendez ce produit, souhaitez-vous suggérer des mises à jour par l'intermédiaire du support vendeur ?
Meilleurs commentaires des clients
Rob Collie donne tous les conseils pour exploiter au mieux ces nouvelles fonctionnalités (plusieurs tables de données peuvent être intégrées dans un seul tableau croisé dynamique en quelques clics, au revoir les "RechercheV"...) en accompagnant le lecteur à travers des cas pratiques réalistes et instructifs. Le style est très clair, voire ludique : c'est à la fois un livre de référence mais aussi un guide pratique (pour Excel 2010). Au sommaire : les avantages de PowerPivot, les colonnes calculées, le nouveau langage DAX pour créer des formules dans les TCD, la performance des calculs, la visualisation et la mise en ligne des résultats.
Quelques heures de lecture qui permettent de grandement gagner en productivité.
A noter : les fichiers utilisés dans le livre peuvent être téléchargés sur le site de Rob Collie.
A noter également : version Kindle très lisible sans problème d'affichage des captures écran.
Commentaires client les plus utiles sur Amazon.com
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.
Rob Collie's book not only fill in the gaps, it provides a solid foundation upon which you can confidently upgrade from Expert to Master.
I have never come across a technical book that delves deeply into a somewhat complex subject with such an easy to follow and funny style. You will hardly feel the need to read the same chapter again. Once you read it, you are ready to move on to next with a very clear understanding.
This book deserves 6 stars out of 5, and I highly recommend it for Excel/PowerPivot users
How wrong I was..
This is a book I just keep turning too time and time again. And, for as many times that I have referred to it, i have recommended it to coworkers who have purchased as well.
Rob's practical style of teaching by use building blocks and comedy make this a MUST read for anyone who has been using PowerPivot or has heard of its "special powers".
One for certain reality is something that Rob mentions many times in the book. It's this: PowerPivot will make you more valuable . It will make you the superhero among your coworkers and employer when it comes to insights about your business. This is something I said to myself the the first time I saw PowerPivot at a Microsoft conference several year ago.
I have all 3 books that make up this series.. All are just awesome, but this is the foundation..
A must buy.... A must investment in your career...
Written in an easy to understand prose, Rob takes PowerPivot users to the next level with Microsoft's new product.
Packed with tips, tricks, and 'traps' (to avoid) --- A Simple Guide... takes packs a tremendous amount of knowledge into a VERY QUICK read. A must reference and guide for analyst, project manager, finance manager, and engineer.
Order an electronic (Kindle) copy AND a printed book. You'll want to have Rob's insights handy the next time someone tells you "you can't do that in Excel", whatever that task is.
Rob, Marc Russo, Bill Jellen (and a few other) are the next faces on the Mt. Rushmore of Excel self-service BI.
This book addresses problems of managing extremely large datasets without the necessity of using SQL Server/SQL Server Analysis Services. Through thorough explanation and demonstration by examples, Rob Collie provides a structured decision-matrix for enterprise developers considering how to achieve performance improvements, deployment efficiency, and "non-coded" Excel (without VBA) solutions without the intervention of professional database programmers. I recommend this book for persons with limited VBA and SQL programming experience, as the PowerPivot engine exposes similar functionality achieved by programming through the use of DAX formulas - more easily comprehended by traditional users of Excel.
On its own merits, this book is so readable that I recommend it to anyone interested in Microsoft's vision of its future Office product. For example, the capability exposed through PowerPivot requires hefty system requirements, necessary to know prior to purchasing new workstations, or on the contrary, making a decision to use Office in the cloud or on a SharePoint Server. This subject and many others are covered by straight-talk explanation.