undrgrnd Cliquez ici Baby ValentinB nav-sa-clothing-shoes nav-sa-clothing-shoes Cloud Drive Photos cliquez_ici nav_HPTV Cliquez ici Acheter Fire Acheter Kindle Paperwhite cliquez_ici Jeux Vidéo Montres soldes Bijoux Soldes

Envoyer sur votre Kindle ou un autre appareil


Essai gratuit

Découvrez gratuitement un extrait de ce titre

Envoyer sur votre Kindle ou un autre appareil

Désolé, cet article n'est pas disponible en
Image non disponible pour la
couleur :
Image non disponible

Microsoft Excel 2013 Building Data Models with PowerPivot: Building Data Models with PowerPivot [Format Kindle]

Alberto Ferrari , Marco Russo
4.0 étoiles sur 5  Voir tous les commentaires (1 commentaire client)

Prix conseillé : EUR 24,25 De quoi s'agit-il ?
Prix livre imprimé : EUR 34,81
Prix Kindle : EUR 16,98 TTC & envoi gratuit via réseau sans fil par Amazon Whispernet
Économisez : EUR 17,83 (51%)

App de lecture Kindle gratuite Tout le monde peut lire les livres Kindle, même sans un appareil Kindle, grâce à l'appli Kindle GRATUITE pour les smartphones, les tablettes et les ordinateurs.

Pour obtenir l'appli gratuite, saisissez votre adresse e-mail ou numéro de téléphone mobile.


Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle EUR 16,98  
Broché EUR 24,06  
-40%, -50%, -60%, -70%... Découvrez les Soldes Amazon jusqu'au 16 février 2016 inclus. Profitez-en !

Les clients ayant acheté cet article ont également acheté

Cette fonction d'achat continuera à charger les articles. Pour naviguer hors de ce carrousel, veuillez utiliser votre touche de raccourci d'en-tête pour naviguer vers l'en-tête précédente ou suivante.

Descriptions du produit

Présentation de l'éditeur

Your guide to quickly turn data into results.


Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required!

  • Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI
  • Extend your existing data-analysis skills to create your own BI solutions
  • Quickly manipulate large data sets, often in millions of rows
  • Perform simple-to-sophisticated calculations and what-if analysis
  • Create complex reporting systems with data modeling and Data Analysis Expressions
  • Share your results effortlessly across your organization using Microsoft SharePoint

Authors’ note on using Microsoft Excel 2016: This book’s content was written against Excel 2013, but it is useful and valid for users of Excel 2016 too. Excel 2016 introduces several new DAX functions and an improved editor for DAX without changing any existing behavior. In other words, all of the concepts and examples explained in this book continue to work with Excel 2016.

Biographie de l'auteur

Alberto Ferrari has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and is a consultant and trainer who specializes in developing Microsoft BI solutions. He is the coauthor of Microsoft PowerPivot for Excel 2010 and Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology.

Détails sur le produit

  • Format : Format Kindle
  • Taille du fichier : 30083 KB
  • Nombre de pages de l'édition imprimée : 500 pages
  • Utilisation simultanée de l'appareil : Jusqu'à 5 appareils simultanés, selon les limites de l'éditeur
  • Editeur : Microsoft Press; Édition : 1 (15 mars 2013)
  • Vendu par : Amazon Media EU S.à r.l.
  • Langue : Anglais
  • Synthèse vocale : Activée
  • X-Ray :
  • Word Wise: Non activé
  • Composition améliorée: Non activé
  • Moyenne des commentaires client : 4.0 étoiles sur 5  Voir tous les commentaires (1 commentaire client)
  • Classement des meilleures ventes d'Amazon: n°100.397 dans la Boutique Kindle (Voir le Top 100 dans la Boutique Kindle)

En savoir plus sur les auteurs

Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.

Commentaires en ligne

5 étoiles
3 étoiles
2 étoiles
1 étoiles
4.0 étoiles sur 5
4.0 étoiles sur 5
Meilleurs commentaires des clients
4.0 étoiles sur 5 Bien fait et très didactique 18 août 2015
Format:Broché|Achat vérifié
Agréable à lire, démarche progressive avec de nombreux exemples (tous téléchargeables).
Le langage DAX, assez complexe à utiliser avec PowerPivot est très bien expliqué.
Avez-vous trouvé ce commentaire utile ?
Signaler un abus
Commentaires client les plus utiles sur Amazon.com (beta)
Amazon.com: 4.7 étoiles sur 5  32 commentaires
46 internautes sur 46 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Prepare to Master PowerPivot 8 avril 2013
Par Oleg Gvozdenko - Publié sur Amazon.com
I got this book as part of the PowerPivot workshop that Marco and Alberto teach. I am about half-way through the book now, and I am at the point where I am starting to re-read chapters to make sure I fully understand the concepts. The material is dense with facts and examples, and the book will take you from 0 to 60 in the first few pages, especially if you have not had a lot of PowerPivot exposure prior to this.

The pace of new information introduction seems to accelerate, and there is more and more reliance on you remembering concepts from earlier in the book, that some may find a bit discouraging (for a shot of confidence boost, check out Collie's book, which is a fantastic beginner's book). I think an expectation on the author's part is that the reader will not understand everything on the first try, and will re-read sections for more complete understanding - just be prepared for that.
I read 4 PowerPivot books so far, and while some go mile wide and a foot deep (Jelen's book), and others go foot wide and a mile deep (Collie's book), this one tries (and does) boil the entire ocean. The book has both a technical edge of thorough, complex DAX scenarios with explanations of potential errors and why the errors occur, and a more conceptual side, which goes in some depth explaining Data Modeling and thinking in Evaluation Context terms.

At its current Amazon price, it is an extremely great value. It is THE book if you want to master PowerPivot. If you are more of a casual user, you may find it more challenging than necessary, but the sections on CALCULATE and Evaluation Context are truly invaluable and are not really well-covered in other books, so it is well worth getting this book just for that.
16 internautes sur 16 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 How to work with PowerPivot 1 janvier 2014
Par Michael Mclaughlin - Publié sur Amazon.com
I've worked with every release of Microsoft Excel, and I know it takes effort to keep up to date with certain releases. Clearly, the Data Analysis eXpression (DAX) Language introduced in Excel 2010 went unnoticed by many, which was sad. DAX is truly a powerful extension to the analytical and modeling approaches in Microsoft Excel.

I'd like to recommend this book to those who haven't learned or mastered how to use DAX in Excel 2010, 2011, or 2013 and those who want to master PowerPivot.

DAX works with tables but if you don't use tables, I guess you can skip DAX because you must have infinite time to produce marginal analytical outcomes (tongue in cheek humor). However, if you're like most folks, you want a book to get you up-to-speed quickly, and that's what this book will do for you.

Just a couple caveats, the book assumes:
- An intermediate knowledge of Excel functions
- Basic knowledge of SQL and database modeling concepts
- It introduces but doesn't cover all potential advance uses
- It discusses VBA approaches in one short chapter

If you're serious about Business Intelligence (BI), and familiar with getting your data from an Oracle, MySQL, SQL Server database or SharePoint server, this is a great book for you to learn PowerPivot and the DAX language.

Don't forget, you get best results when you pre-select data before applying analytics in Excel. Remember the more refined the data model you start with the easier it is to structure analytical tools to leverage the data model. While DAX is powerful, it doesn't replace the speed and query optimized behaviors of effective Oracle, MySQL, or SQL Server queries.
32 internautes sur 37 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Perfect book for the right audience 29 mars 2013
Par Student - Publié sur Amazon.com
There is a certain niche audience for this book: intermediate to advanced excel users who aren't necessarily BI/datawarehousing types. If you are a fairly basic excel user, this would not be a book to start with. You should already know vlookups, pivot tables, etc. before getting into PowerPivot. And, if you are a grizzled BI professional, this may serve as a good reference, but you can breeze through parts of it.

I guess I'm pretty much the target audience here, then. I'm an all-day excel user, but had not yet gotten PowerPivot as my company was still on excel 2007. Moreover, I only have a passing familiarity with cubes and BI stuff, facts and dimensions and star schemas, oh my!

But I had heard about this PowerPivot fad (kidding!) and have been intrigued.

I recently upgraded to Excel 2013 on my home computer just so I could begin to play around with this new feature. While I don't love the look and feel of excel 2013, it was worth it.

Okay, enough about excel itself. What do I think of this book? Why did I choose this one over one of the many others? How the heck am I reviewing it before it has even been released? Do I like asking questions as a cheap rhetorical device before essentially answering them myself? YES! I also like to refer to myself in the third person, just to sound important.

As for the third question: I subscribe to an online library that, for some reason, already has this available.

Honestly, the main reason I chose this book over many others is that it has a very comprehensive coverage of the subject by authors who's previous book came highly recommended. Some books are more introductory (Jelen's), some focus on DAX alone, some are more for the Sharepoint stuff, this one seemed to have it all.

The authors spend a good bit of time going over database/warehouseing concepts and lingo for those of us who may need a bit of a refresher. As mentioned above, that was something I felt I could benefit from.

There is also coverage of the new PowerView feature, which reminds me a bit of a simplified Tableau for data exploration and dashboarding. It might be nice to see more on this subject. But I think that would be a separate book. And I'm sure we will see some written soon. After all, the title is "Building Data Models," not "Building Dashboards and Reports."

There is extensive coverage of the DAX language, which is something I have no experience with, so, again, good to have most of what we need in one book. Though I know whole books have been written on DAX.

From what I can tell, the Collie book is more readable and "fun." This one is more or less typical of similar technical books. I mean, it's not a suspense/thriller.

I have downloaded the supporting files and they are extensive. So far, all seem to be working correctly and are important to work through as you follow along with the book.

Overall, recommended if you are an excel pro who wants a single source book to learn about PowerPivot, DAX, PowerView, and data modeling in general.
8 internautes sur 8 ont trouvé ce commentaire utile 
4.0 étoiles sur 5 Serious DAX... 17 janvier 2014
Par Matt Hughes - Publié sur Amazon.com
I'm pretty sure that Rob Collie's book on DAX Formulas should be read before tackling this book. I struggled with the content at about page 150...then I bought Rob Collie's book on DAX formulas...then I came back to this book. All the detail that doesn't get covered in Rob's book shows up in Alberto's book. I needed them both. Some issues with choppy sentence structure with this book.
4 internautes sur 4 ont trouvé ce commentaire utile 
2.0 étoiles sur 5 Absoulte waste of time 3 juin 2015
Par Tarar - Publié sur Amazon.com
Format:Broché|Achat vérifié
I brought this book to understand and master Powerpivot and DAX. Although I had learned the basics myself before the book came, I am really frustrated by the way this book is written.

It seems that the authors have no basic sense of how humans read and understand concepts. The authors are just giving you unlimited shots of imagination ... leaving no room for someone to understand what is happening. At times it appears that you are being taught one formula after another and then another without a breathing space. The first few chapters are basic understanding.

As soon as the first real chapter on DAX formulas start you start feel getting lost. Too much theory and technical jargon and there is no focus on a single formula. The author at beginning of each chapter assumes we have become masters with all stuff in previous chapter. The learning curve assumed is very steep and illogical in my view. It would have been much better if they started with one formula and explained that in detail before moving to next one.

I am hugely disappointed by the way content runs through the book. Programming cannot be learned by reading a 'novel' like this book which goes on and on without any room to test and practice what we have learned before. This book is total nonsense and probably the author assumes a very high IT and programming background for you which is not mentioned.
Ces commentaires ont-ils été utiles ?   Dites-le-nous
Rechercher des commentaires

Discussions entre clients

Le forum concernant ce produit
Discussion Réponses Message le plus récent
Pas de discussions pour l'instant

Posez des questions, partagez votre opinion, gagnez en compréhension
Démarrer une nouvelle discussion
Première publication:
Aller s'identifier

Rechercher parmi les discussions des clients
Rechercher dans toutes les discussions Amazon

Rechercher des articles similaires par rubrique