Microsoft Excel 2013 Building Data Models with PowerPivot und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr
EUR 22,95
  • Alle Preisangaben inkl. MwSt.
Auf Lager.
Verkauf und Versand durch Amazon.
Geschenkverpackung verfügbar.
Menge:1
Microsoft® Excel®... ist in Ihrem Einkaufwagen hinzugefügt worden
Ihren Artikel jetzt
eintauschen und
EUR 7,03 Gutschein erhalten.
Möchten Sie verkaufen?
Zur Rückseite klappen Zur Vorderseite klappen
Anhören Wird wiedergegeben... Angehalten   Sie hören eine Probe der Audible-Audioausgabe.
Weitere Informationen
Alle 2 Bilder anzeigen

Microsoft® Excel® 2013: Building Data Models with PowerPivot (Business Skills) (Englisch) Taschenbuch – 15. März 2013


Alle 2 Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Amazon-Preis Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
Taschenbuch
"Bitte wiederholen"
EUR 22,95
EUR 19,94 EUR 24,08
47 neu ab EUR 19,94 8 gebraucht ab EUR 24,08

Wird oft zusammen gekauft

Microsoft® Excel® 2013: Building Data Models with PowerPivot (Business Skills) + DAX Formulas for PowerPivot: The Excel Pro's Guide to Mastering DAX + Dashboarding and Reporting with Power Pivot and Excel: How to Design and Create a Financial Dashboard with Powerpivot - End to End
Preis für alle drei: EUR 71,75

Die ausgewählten Artikel zusammen kaufen
Jeder kann Kindle Bücher lesen — selbst ohne ein Kindle-Gerät — mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.


Produktinformation

  • Taschenbuch: 487 Seiten
  • Verlag: Microsoft Press; Auflage: 1 (15. März 2013)
  • Sprache: Englisch
  • ISBN-10: 0735676348
  • ISBN-13: 978-0735676343
  • Größe und/oder Gewicht: 18,5 x 3 x 22,4 cm
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (2 Kundenrezensionen)
  • Amazon Bestseller-Rang: Nr. 19.327 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
  • Komplettes Inhaltsverzeichnis ansehen

Mehr über die Autoren

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

Produktbeschreibungen

Über den Autor und weitere Mitwirkende

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.

Kundenrezensionen

5.0 von 5 Sternen
5 Sterne
2
4 Sterne
0
3 Sterne
0
2 Sterne
0
1 Sterne
0
Beide Kundenrezensionen anzeigen
Sagen Sie Ihre Meinung zu diesem Artikel

Die hilfreichsten Kundenrezensionen

Format: Taschenbuch
Dieses Buch richtet sich an Excel User, die Powerpivot und Dax lernen wollen (oder müssen). Obwohl im Titel Excel 2013 steht, ist es auch für Nutzer von Excel 2010 extrem nützlich. Man merkt deutlich, dass die Autoren nicht nur Unternehmen beraten sondern auch Dax-Workshops durchführen. Gerade die Punkte, über die man als reiner Excel User gerne stolpert, werden ausführlich und so erklärt, dass man sie gut versteht.

Was mir auch schon in dem 2010 erschienenen Buch der beiden Autoren gut gefallen hat, ist das Hintergrundwissen über BI, dass man durch diese Buch bekommt. Das hat sich für mich auch positives auf meine gesamte Arbeitsweise und mein Verständnis von Datenbanken ausgewirkt. Echte BI-Profis werden aber wohl eher mit einem Buch speziell über das BISM Tabular Model glücklich, auch hier gibt es ein Buch der Autoren, dass sie zusammen mit Chris Webb geschrieben haben.
Kommentar War diese Rezension für Sie hilfreich? Ja Nein Feedback senden...
Vielen Dank für Ihr Feedback. Wenn diese Rezension unangemessen ist, informieren Sie uns bitte darüber.
Wir konnten Ihre Stimmabgabe leider nicht speichern. Bitte erneut versuchen
1 von 2 Kunden fanden die folgende Rezension hilfreich Von M. Riedmueller am 30. Mai 2014
Format: Kindle Edition Verifizierter Kauf
Ein absolut unverzichtbares Buch, wenn man sich wirklich über die ersten Schritte mit Power Pivot hinaus ernsthaft mit DAX beschäftigen möchte. Und der Zeitpunkt kommt schnell, dass man das braucht, um seine Anforderungen umzusetzen.
Kommentar War diese Rezension für Sie hilfreich? Ja Nein Feedback senden...
Vielen Dank für Ihr Feedback. Wenn diese Rezension unangemessen ist, informieren Sie uns bitte darüber.
Wir konnten Ihre Stimmabgabe leider nicht speichern. Bitte erneut versuchen

Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)

Amazon.com: 27 Rezensionen
32 von 32 Kunden fanden die folgende Rezension hilfreich
Prepare to Master PowerPivot 8. April 2013
Von Oleg Gvozdenko - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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.
28 von 32 Kunden fanden die folgende Rezension hilfreich
Perfect book for the right audience 29. März 2013
Von Student - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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.
11 von 11 Kunden fanden die folgende Rezension hilfreich
How to work with PowerPivot 1. Januar 2014
Von Michael Mclaughlin - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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.
5 von 5 Kunden fanden die folgende Rezension hilfreich
Serious DAX... 17. Januar 2014
Von Matt Hughes - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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 von 4 Kunden fanden die folgende Rezension hilfreich
Comprehensive Coverage of Powerpivot and Data Models 27. April 2013
Von Bryan D Povlinski - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
I haven't gotten through the entire book yet, but I've been using it as a resource in my position where I'm currently an avid Excel user. Alberto and Marco have covered the full spectrum of what you can do with Powerpivot and provide a wealth of information on how to form and shape your data model for best use in reporting and analytics. I would highly recommend this book if you're getting started with Powerpivot.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.