PowerPivot for the Data Analyst: Microsoft Excel 2010 und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr


oder
Loggen Sie sich ein, um 1-Click® einzuschalten.
oder
Mit kostenloser Probeteilnahme bei Amazon Prime. Melden Sie sich während des Bestellvorgangs an.
Jetzt eintauschen
und EUR 3,15 Gutschein erhalten
Eintausch
Alle Angebote
Möchten Sie verkaufen? Hier verkaufen
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Farbe:
Keine Abbildung vorhanden

 
Beginnen Sie mit dem Lesen von PowerPivot for the Data Analyst auf Ihrem Kindle in weniger als einer Minute.

Sie haben keinen Kindle? Hier kaufen oder eine gratis Kindle Lese-App herunterladen.

PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library) [Englisch] [Taschenbuch]

Bill Jelen
5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
Preis: EUR 25,40 kostenlose Lieferung. Siehe Details.
  Alle Preisangaben inkl. MwSt.
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Nur noch 2 auf Lager (mehr ist unterwegs).
Verkauf und Versand durch Amazon. Geschenkverpackung verfügbar.
Lieferung bis Mittwoch, 30. Juli: Wählen Sie an der Kasse Morning-Express. Siehe Details.

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 12,97  
Taschenbuch EUR 25,40  

Kurzbeschreibung

23. April 2010 MrExcel Library
ANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY! Use Microsoft's free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time! Simple, step-by-step instructions walk you through installing PowerPivot, importing data, using PivotTables with PowerPivot, using super-powerful DAX functions and measures, reporting to print or SharePoint, and a whole lot more. Whatever your Excel data analysis experience, this book will help you use PowerPivot to get the right answers, right now-without IT's help! * Import and integrate data from spreadsheets, SQL Server, Access, Oracle, text files, Atom data feeds, and other sources * Analyze multiple tables together, without complicated VLOOKUPs * Format, sort, and filter data in the PowerPivot window * Add calculated columns using new DAX functions * Create powerful reports from PowerPivot data-and format them so executives instantly get your point * Discover PivotTable tricks that work even better in PowerPivot * Control multiple PivotTable elements on one worksheet, with one set of Excel 2010 Slicers * Use DAX Measures to quickly perform tasks that were difficult or impossible with Calculated Fields * Compare today's sales to yesterday's-or to sales from the parallel period last fiscal year. * Use Named Sets to prepare asymmetric reports, show actuals for past months and plan for future months. About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will * Dramatically increase your productivity-saving you 50 hours a year, or more * Present proven, creative strategies for solving real-world problems * Show you how to get great results, no matter how much data you have * Help you avoid critical mistakes that even experienced users make

Hinweise und Aktionen

  • Amazon Trade-In: Tauschen Sie Ihre gebrauchten Bücher gegen einen Amazon.de Gutschein ein - wir übernehmen die Versandkosten. Mehr erfahren


Wird oft zusammen gekauft

PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library) + DAX Formulas for PowerPivot: The Excel Pro's Guide to Mastering DAX + Microsoft Excel 2013 Building Data Models with Powerpivot (Business Skills)
Preis für alle drei: EUR 72,50

Die ausgewählten Artikel zusammen kaufen


Produktinformation

  • Taschenbuch: 311 Seiten
  • Verlag: Que Corp; Auflage: 1 (23. April 2010)
  • Sprache: Englisch
  • ISBN-10: 0789743159
  • ISBN-13: 978-0789743152
  • Größe und/oder Gewicht: 23,4 x 17,8 x 1,8 cm
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: Nr. 44.178 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
  • Komplettes Inhaltsverzeichnis ansehen

Mehr über den Autor

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

Produktbeschreibungen

Über den Autor und weitere Mitwirkende

Bill Jelen , Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 30 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. You will most frequently find Bill taking his show on the road, doing half-day Power Excel seminars wherever he can find a room full of accountants or Excellers. Before founding MrExcel.com, Jelen spent 12 years in the trenches working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary, Ellen and his sons, Josh and Zeke.

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


In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis
Hier reinlesen und suchen:

Kundenrezensionen

4 Sterne
0
3 Sterne
0
2 Sterne
0
1 Sterne
0
5.0 von 5 Sternen
5.0 von 5 Sternen
Die hilfreichsten Kundenrezensionen
5.0 von 5 Sternen Jede Menge Basics + Tipps/Tricks 6. Juli 2010
Von JochenJ
Format:Taschenbuch
Super Buch von MrExcel! Sehr locker/gut lesbar geschrieben und bietet einen vollständigen Überblick für Einsteiger in Excel/PowerPivot! Aber auch fortgeschrittene Anwender finden jede Menge Tipps/Tricks zum Arbeiten mit Excel/PivotTabellen im Allgemeinen und zu den Hintergründen von PowerPivot. Zusammengefasst absolut lesenswert!
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com: 4.2 von 5 Sternen  35 Rezensionen
17 von 17 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Good intro to PowerPivot 29. Juli 2010
Von Bill Draper - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Verifizierter Kauf
The good:
* Excellent information on new features and capabilities of PowerPivot tables. Lots of good examples.
* Good compare & contrast with base PivotTables.
* Good documentation of some of the v1 PowerPivot limitations.
* The prose is very easy to read.

The gaps:
* The book was written before the final product was delivered. It would be good to see some errata/revisions covering changes made in the mean time for early buyers.
* Probably somewhat related to the above, the discussion of DAX is fairly limited. DAX is the real key feature that makes PowerPivot more powerful than base PivotTables. (The best reference source I've seen so far is the MS "Data Analysis Expressions in PowerPivot for Excel 2010" document.)
* It would have been nice to explain some considerations when moving models from PivotTables to PowerPivot. For example, PivotTables by definition have to have everything in one giant table. PowerPivot models end up working better with separated lookup (dimension) tables in my experience so far.
14 von 16 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Best starting point for an Excel Pro 24. August 2010
Von Rob Collie - Veröffentlicht auf Amazon.com
Format:Taschenbuch
Excerpt from my full review at PowerPivotPro:

My biggest overall conclusion after reading Bill's book is that Excel users will be hard-pressed to find a better place to start their PowerPivot journey. Bill is not a SQL guy and he is not an MS employee - he has been building spreadsheets in the wild since before Pivots even existed. And for many years now he has made his living simply teaching others to get the most out of Excel.

That history and perspective shows through in the book. Reading it is VERY different from reading any of the MS documentation on PowerPivot for instance - that MS content is excellent at describing PowerPivot, but it just isn't written by a multi-decade Excel maestro, so it doesn't tell Excel users, in detail, what will be familiar to them and what will be new.

What the book is NOT

Clocking in at 294 pages, this book doesn't try to do everything, which I think is wise. I don't think any Excel pro wants to pick up, as a starting point, a 1200 page bible. This book is an excellent intro and you will hit the ground running fast, but at some point later, you will eventually go looking for:

- An in-depth guide to high-powered DAX measures
- An in-depth guide to the implications of various table structures and relationships
- Performance-tuning reference
- A how-to reference for deploying PowerPivot for SharePoint
- List of best practices, tips and tricks, workarounds for Excel Services on SharePoint

Like I said, as an Excel pro, you are MUCH better off NOT trying to tackle those up front. You can get incredible mileage out of PowerPivot without once touching those topics. You will want to someday, but you don't NEED to, so I highly recommend Excel pros pick up this book as their starting point.

-Rob Collie
PowerPivotPro
7 von 8 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen Sample Files hard to follow 2. Juni 2011
Von barnkb - Veröffentlicht auf Amazon.com
Format:Taschenbuch
This is the first book I have used written by Mr. Jelen. It is obvious he knows his stuff and I can envision that he is very adept at the art of teaching. However, this book is written in a manner similar to other "How To" books in the sense that he describes step-by-step how to achieve a desired result in understanding a concept. Unfortunately the supporting sample files do not lend themselves well to the examples given in the book. First, it took a bit of sluething to even find the files (the link provided in the book was not a valid link) and then after the file was finally discovered, the naming of those files had almost no correlation with the book exercises. After some poking around and guesswork, you can usually find the file you're seeking but it should be much more obvious than it is. Also, the sample files should contain two states, the raw file to use so you can do the exercise and then a solution file. I wonder if everyone involved in this book had the goal to get it out early and just didn't want to take the time to make following the exercises a little more student friendly.

On one other unrelated note.... I have purchased other books that are accompanied by a CD that contain a searchable PDF of the book. This is a very much appreciated and useful companion to the hard copy. If producing a CD is problematic for the publisher for whatever reason they have, perhaps an online version could be made available?
3 von 3 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Excellent introduction to PowerPivot 29. Oktober 2010
Von Max Woodhead - Veröffentlicht auf Amazon.com
Format:Taschenbuch
This book examines in detail PowerPivot which is a free add-in for Excel 2010. It makes possible the analysis of very large amounts of data normally beyond the capability of Excel. PowerPivot is not for the faint hearted and is aimed at experienced users of Excel who are familiar and comfortable with lookup functions, pivot tables and databases.

To take full advantage of the book, you will need to download PowerPivot from [...] and also the author's example files from [...] There are 32-bit and 64-bit versions of PowerPivot and it is essential that you choose the one which matches your 32-bit or 64-bit version of Excel 2010.
The introductory chapter is a personal and interesting account which puts PowerPivot into context and shows the enthusiasm that Mr Excel has for his subject. After discussing how to obtain and install PowerPivot the book then begins to go into detail about how and when to use this application. Whilst it is clear that the author is a passionate advocate of PowerPivot, he is also critical of what he sees as shortcomings - for example, not easily being able to sort in month order - and he devotes a whole chapter to explaining the circumstances in which you might decide that a conventional pivot table might be a better approach.

The book gives detailed descriptions of the steps involved in many different tasks clearly illustrated with accompanying diagrams and supported by the exercise files that you can work through yourself. These include:
* Importing data
* Sorting
* Defining relationships between multiple tables
* Creating pivot tables using multiple sources
* Using the new DAX data analysis functions
* Using Slicers
* Creating charts

There are plenty of tips with two whole chapters on "cool tricks" separately devoted to working with conventional pivot tables and those created using PowerPivot. Advice on solving problems caused by "bad data" is included.

There are a few typographical errors in the text but the tasks are very well explained and so it is not difficult to work through the examples using the files provided to arrive at the required result.

In addition to the book and downloadable resources, there are 13 very watchable and informative You Tube videos in which the author demonstrates a topic from each chapter. These last only a few minutes each but give a good overview and may well be worth watching first before you attempt the exercises.
Overall, this is an excellent introduction to PowerPivot which takes you all the way from importing data to creating dashboards for the boardroom. If you are looking for a stimulating book to guide you towards a good knowledge of PowerPivot, choose this one.
2 von 2 Kunden fanden die folgende Rezension hilfreich
2.0 von 5 Sternen Author needs to make an effort to tie material to samples to the book 4. September 2012
Von Steve Nelson - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Verifizierter Kauf
The material covered is excellent. The effort it takes to use the sample files is a distraction, to say the least.
Poorly planned and little effort was given to this area.
JWalk has you beat hands down on this.
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
Thema:
Erster Beitrag:
Eingabe des Log-ins
 

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen
   


Ähnliche Artikel finden


Ihr Kommentar