Microsoft® PowerPivot for Excel® 2010: Give Your Data Mea... und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr
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
Dieses Bild anzeigen

(Microsoft Powerpivot for Excel 2010: Give Your Data Meaning) By Russo, Marco (Author) Paperback on (10 , 2010) (Englisch) Taschenbuch – 12. Oktober 2010


Alle 3 Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Amazon-Preis Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
Taschenbuch, 12. Oktober 2010
EUR 44,55 EUR 44,53
3 neu ab EUR 44,55 2 gebraucht ab EUR 44,53
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
  • Verlag: Microsoft Press (12. Oktober 2010)
  • Sprache: Englisch
  • ASIN: B009WHA4YO
  • Größe und/oder Gewicht: 22,6 x 18,8 x 2,8 cm
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: Nr. 4.278.066 in Bücher (Siehe Top 100 in Bücher)

Mehr über die Autoren

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

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


In diesem Buch (Mehr dazu)
Nach einer anderen Ausgabe dieses Buches suchen.
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis
Hier reinlesen und suchen:

Kundenrezensionen

5.0 von 5 Sternen
5 Sterne
1
4 Sterne
0
3 Sterne
0
2 Sterne
0
1 Sterne
0
Siehe die Kundenrezension
Sagen Sie Ihre Meinung zu diesem Artikel

Die hilfreichsten Kundenrezensionen

2 von 2 Kunden fanden die folgende Rezension hilfreich Von Cab am 28. Juni 2011
Format: Taschenbuch Verifizierter Kauf
Ein sehr gut aufgebautes Buch, das neben PowerPivot auch grundlegende Business Intelligence Konzepte vermittelt, die das Verständnis deutlich erleichtern und der Arbeit mit Powerpivot auch eine grundlegende Struktur geben.

Gleichzeitig zeigen die Autoren aber auch, was man alles mit DAX, der neuen Formelsprache von PowerPivot machen kann und bieten Lösungen für spezielle Problemstellungen, auf die man nicht so ohne weiteres selber kommen würde.

Für mich war es ein guter Einstieg in die Welt der BI.

Das Englisch fand ich gut verständlich und hat mir keine Schwierigkeiten bereitet.
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: 24 Rezensionen
7 von 7 Kunden fanden die folgende Rezension hilfreich
Great book on PowerPivot and DAX 28. Juni 2011
Von Cab - Veröffentlicht auf Amazon.com
Format: Taschenbuch
I like the book for two reasons.
First, while explaining how PowerPivot works, it also explains many BI concepts (OLAP cubes, sql joins, normalization) which are not necessarily known to every excel user. However, these help to maximize the usefulness of PowerPivot.
Second, it also shows what you can do with DAX, the new formula language of PowerPivot, which is quite impressive but not so easily mastered, especially here the book is a tremendous help.
16 von 20 Kunden fanden die folgende Rezension hilfreich
Leaf-Level Book Review: `Microsoft PowerPivot for Excel 2010' 12. Oktober 2010
Von Derek Comingore - Veröffentlicht auf Amazon.com
Format: Taschenbuch
Being a member of the Analysis Services Insiders group is one of my favorite parts about being a Microsoft SQL/BI MVP. The Insider forums are locked down to select individuals and provide Microsoft experts with a venue to exchange ideas, thoughts, and technical solutions among one another. As a result, overtime I have begun to know both Marco & Alberto, and when I learned they were both working on a collaborative PowerPivot book it peaked my interest. Furthermore, when I learned that the book would have a focus on DAX my interest increased yet again. I received an early copy of the printed manual and over the past 24 hours I have torn thru the book's newly printed pages eager to see what my fellow colleagues across the pond created.

Microsoft SQL Server PowerPivot is an extremely powerful and yet diverse Self-Service BI (SSBI) toolset. There are aspects of PowerPivot that are more slanted towards information workers (PowerPivot for Excel) while other aspects are intended purely for IT Pros (PowerPivot for SharePoint). The key decision for software-centric book authoring "is it better to drill down on a subset of a larger software product's features or provide complete coverage with less details" still applies today. Marco Russo and Alberto Ferrari have clearly decided to focus on the PowerPivot for Excel experience with an advanced exploration of DAX, PowerPivot's best in class information worker expression language.

The book's key driver for purchase is that it is authored by seasoned Microsoft BI experts who exploit PowerPivot for Excel's analytical capabilities to the max. Who better to teach information workers about the advanced analytical capabilities of PowerPivot for Excel (which is driven internally by the in-memory Analysis Services Vertipaq engine) than those who've used past incarnations of similar technology for similar purposes? While I agree that PowerPivot for Excel 100% does not require information workers to be familiar with Analysis Services concepts, the author's background serves them well for the aspects of PowerPivot they choose to attack.

The manual begins with a nice introduction on classic Excel Pivot Tables and then demonstrates how PowerPivot for Excel clearly overcomes the limitations of the older pivot table & VLOOKUP technology. In chapters two and three the book explores PowerPivot for Excel introductory features including an introduction to DAX. The authors then introduce you to the concept of PowerPivot data models in chapter four with the loading of PowerPivot data models being covered in chapter five. Chapter six is where the authors expertise really begins to shine with a treatment of DAX's Evaluation Context and specifically the CALCULATE function.

Chapter seven hones in on using DAX for common time intelligence calculations. Date and time calculations are the crux of any analytical solution. Common expressions such as year-to-date, year-over-year, and beginning/closing balances are covered in detail. You are then taken into a chapter that shows you how to master Excel 2010 Pivot Tables including Classic Pivot Tables, OLAP Pivot Tables, and PowerPivot Pivot Tables.

Chapters nine and ten focus on DAX and data model patterns. SSBI users will find both of these chapters are extremely well tailored for them addressing common analytical challenges such as ratio calculations, ranking calculations, banding, and even a demonstration of how to overcome unsupported relationships with DAX. The manual concludes with chapter eleven covering the publishing of PowerPivot for Excel workbooks including a primer on PowerPivot for SharePoint via SharePoint data refresh settings & configuration.

Microsoft PowerPivot for Excel 2010 is without question the best book on PowerPivot for Excel I've read to date. The authors have executed well on a no-holds-barred approach to exploiting PowerPivot for Excel and everything that the client-experience can provide users. Both information workers and business intelligence professionals alike who use or intend to use PowerPivot for Excel should consider the book as required reading. Additionally, due to the sheer volume of DAX coverage, readers should retain the book as a must-have DAX reference.

Bravo!
Derek Comingore, Microsoft SQL/BI MVP
7 von 8 Kunden fanden die folgende Rezension hilfreich
Interesting but sometimes it is hard to use 30. Mai 2011
Von MAD - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
Most of the book is well written, it would be nice to have some application exercises so you could do the process step by step and later check the answer. Otherwise it is too much theory.
3 von 3 Kunden fanden die folgende Rezension hilfreich
Very hard to understand. 27. Juni 2013
Von J. Polacek - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
This book is not a follow along instruction guide. Author often states PivotTaable limitations. AdventureWorks Sample Database is missing files. It is impossible to complete a chart or table with missing files. You cannot move on to the next exercise.
2 von 2 Kunden fanden die folgende Rezension hilfreich
Excel users in business settings will find this a 'must' 16. Februar 2011
Von Midwest Book Review - Veröffentlicht auf Amazon.com
Format: Taschenbuch
A DVD of workbook examples and an Access version of the book's sample database accompanies a fine survey of data analysis skills in Microsoft PowerPivot for Excel 2010: Give Your Data Meaning. Any Excel collection catering to advanced users should have this: it teaches how to apply Excel's formulas to the Power Pivot language DAX, how to manipulate, sort and understand calculations and data results, and how to perform sophisticated functions such as using PivotTables and charts. Excel users in business settings will find this a 'must'.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.

Ähnliche Artikel finden