derrierloisirs.fr
» » Professional Microsoft PowerPivot for Excel and SharePoint

Download Professional Microsoft PowerPivot for Excel and SharePoint ePub

by Sivakumar Harinath

Download Professional Microsoft PowerPivot for Excel and SharePoint ePub
  • ISBN 0470587377
  • ISBN13 978-0470587379
  • Language English
  • Author Sivakumar Harinath
  • Publisher Wrox; 1 edition (June 15, 2010)
  • Pages 384
  • Formats lit mobi lrf azw
  • Category Technology
  • Subcategory Programming
  • Size ePub 1482 kb
  • Size Fb2 1700 kb
  • Rating: 4.9
  • Votes: 356

With PowerPivot, Microsoft brings the power of Microsoft's businessintelligence tools to Excel and SharePoint users. Self-servicebusiness intelligence today augments traditional BI methods,allowing faster response time and greater flexibility. If you're abusiness decision-maker who uses Microsoft Office or an ITprofessional responsible for deploying and managing yourorganization's business intelligence systems, this guide will helpyou make the most of PowerPivot.

Professional Microsoft PowerPivot for Excel andSharePoint describes all aspects of PowerPivot and showsyou how to use each of its major features. By the time you arefinished with this book, you will be well on your way to becoming aPowerPivot expert.

This book is for people who want to learn about PowerPivot fromend to end. You should have some rudimentary knowledge of databasesand data analysis. Familiarity with Microsoft Excel and MicrosoftSharePoint is helpful, since PowerPivot builds on those twoproducts.

This book covers the first version of PowerPivot, which shipswith SQL Server 2008 R2 and enhances Microsoft Office 2010. Itprovides an overview of PowerPivot and a detailed look its twocomponents: PowerPivot for Excel and PowerPivot for SharePoint. Itexplains the technologies that make up these two components, andgives some insight into why these components were implemented theway they were. Through an extended example, it shows how to build aPowerPivot application from end to end.

The companion Web site includes all the sample applications andreports discussed.


Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. If you're a business decision-maker who uses Microsoft Office or an IT professional responsible for deploying and managing your organization's business intelligence systems, this guide will help you make the most of PowerPivot.

Authored by key members of the Microsoft team that built the product, this book will guide you through the use of in-memory BI server technology, data analytics eXpressions, and report gallery. To read this book, upload an EPUB or FB2 file to Bookmate.

This book covers the first version of PowerPivot, which ships with SQL Server 2008 R2 and enhances Microsoft Office 2010. It explains the technologies that make up these two components, and gives some insight into why these components were implemented the way they were

Author: Denny Guang-Yeu Lee, Ron Pihlgren, Sivakumar Harinath.

Author: Denny Guang-Yeu Lee, Ron Pihlgren, Sivakumar Harinath. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility.

Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility.

App Inventor for Android.

Microsoft Excel 2016 Step by Step is designed for use as a learning and reference resource by home Mic. Microsoft Excel 2013: Building. Data Models with PowerPivot. Microsoft Excel 2013: Building Data Models with PowerPivot. 64 MB·2,333 Downloads. Statistics and probability for engineering applications with Microsoft Excel. 94 MB·75,575 Downloads·New! of Excel In addition, the book provides an "engineering problem solver" section that directs the reade.

Professional Microsoft SQL Server Analysis Services 2008 with MDX (Wrox Programmer to Programmer).

Sivakumar Harinath, Ron Pihlgren, Denny Guang-Yeu Lee. Category: Компьютеры, Программы, Офисные программы. 2. 7 Mb. Professional Microsoft SQL Server Analysis Services 2008 with MDX (Wrox Programmer to Programmer). Sivakumar Harinath, Robert Zare, Sethu Meenakshisundaram, Matt Carroll, Denny Guang-Yeu Lee. Category: Компьютеры, Программирование. 1. 1 Mb. MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase.

Talk about Professional Microsoft PowerPivot for Excel and SharePoint


Kalv
This past month I purchased both of the PowerPivot books that were available. The first one I got was the Professional Microsoft PowerPivot for Excel and SharePoint (wow, that was a mouthful). I would have to say that this book is geared more toward the IT Professional where it does a great job covering the installation setup on the server side, managing and troubleshooting techniques, and going over some of the development.

The other part that I really like about this product was the additional insights that were provided by the product team members talking about how the product came to life and the different paths that were explored initially (originally MS Access was looked at...phew). The exercises that were provided were helpful and the troubleshooting section was very useful, especially coming from the IT side of the world. All-in-all I would highly recommend this book to the IT Pro and would give this book 5 out of 5 stars. Definitely worth the $$$.
hardy
The new free add-on for Excel 2010, PowerPivot, allows users to do more self-service BI than having to go through the time consuming process of getting database administrators to create time consuming cubes. This book does a great job of walking the reader through creating powerful BI solutions with just Excel, the free PowerPivot add-on for Excel and an understanding of your data.
Vital Beast
Professional Microsoft PowerPivot is an excellent manual authored by key members of the Analysis Services & SQLCAT teams. With topics including introductions of the PowerPivot technology, self-service analytical construction, and server configuration & management the book provides solid content for all PowerPivot audiences. Additionally, the authors walk you thru a step-by-step exercise of building a sample PowerPivot application in parallel with progressive content. If you are serious about mastering the new self-service BI technology you should consider the manual as required reading.
Rayli
Between this book and the blog they mention in the book, this was a worth the money spent. Some of raw details in the book leave something to be desired, but the troubleshooting was worth it all.

If you don't already know, PowerPivot for SharePoint integration is a real bear to install and configure unless you're starting from scratch. Even then things don't go smoothly. This book had some great pointers and resolutions in the later chapter on how PowerPivot works inside the SharePoint environment and helped me figure out what services needed to be running and other details that just aren't explained elsewhere.

If you're having trouble installing and configuring PowerPivot for SharePoint 2010, then this is a must have resource and reference book.
Nicearad
I am a fan of the Wrox Professional series of computer books because they are direct and comprehensive. This one disappointed me. It deviated from their normal "talk to you like you are a professional" format into a "hold your hand and walk you through a bunch of disjointed tasks step by step" format. If I wanted PowerPivot for dummies, I would have looked for that. Worse, the step-by-step tutorials are poorly written and missing key steps.

I was very disappointed in this book.
Inabel
I bought the book and read it during the weekend, even if I have worked a lot with PowerPivot I learnt some things. The printed version is weak on the PowerPivot for Excel part. It mainly goes through how to create a sample app in Excel. The part about PowerPivot for Sharepoint have more depth though. However to be fair the download page for the book has a pdf with the best DAX reference that I have seen.

I would recommend people to buy and read this book.

//Simon
Purestone
(This is a condensed version of my full review at [...])

What the book is NOT

1) It is not the first book an Excel pro should pick up. It covers too much, and comes from a perspective that might seem a bit foreign. Start with Bill's book if this is your background.

2) Like Bill's book, it is only a light treatment of DAX. Again, this is wise, because DAX really deserves its own book. Those seeking a detailed DAX book should look forward to an upcoming title from Marco Russo.

3) It does not cover the real-world gotchas encountered in a full adoption of a PowerPivot system. After a full year of applying PowerPivot to real-world problems - six months as a product team member in exile (in Cleveland), and the last six months putting the full system into action at Pivotstream, I can say that there are a number of "gotchas" that you have to look out for in PowerPivot v1. They are not fatal - Pivotstream's PowerPivot platform is very much thriving - but you only discover them, and learn to avoid/overcome them, via real-world practice.

Anyway, for a just-released product, it's not like we can expect ANY book to cover that kind of thing. There's probably room for a book like "PowerPivot in the Trenches" but someone else needs to volunteer, as I, um, rarely get out of my trench :)

What the book IS - Consistently readable and info-rich

1) Great Information Density, but High Readability - When I finished the book, I immediately dropped an email to Denny/Ron/Siva and told them how impressed I was with the balance between density and clarity. As a de facto tech writer myself throughout my career, I can say that I struggle with this, and typically end up jamming in too much at the expense of readability, or a 50-page doc with so much whitespace that 20 pages would have covered it. Perhaps you have noticed.

It's hard to put my finger on how the book strikes such a nice balance - perhaps it's the editing, or the layout style - but I consistently noted how MUCH was conveyed on each page, while at the same time, it felt like a light read. That's saying a lot considering the list of topics covered.

2) Benefits of Three Product Team Authors - When you include all of the folks from teams like SharePoint, Excel, SSRS and others that contributed to PowerPivot, it's probably safe to say that the product reflects the efforts of 200+ people for several years. No one human being could possibly span all of that, and it only gets harder if you weren't directly involved in that process.

These three guys were working on the book for a long time, while the product was still in development. They all had different areas of focus, both in terms of natural affinities and in terms of dividing up their assignments. They then had a lot of time, and access to the people who were building the product, to refine the content.

The benefits of this authorship approach are evident in the book. You'll see what I mean - I always expect some "uneveness" in a tech book of this length because the talents and endurance of a single author are themselves uneven. Chapter to chapter, the red book's quality remains consistent.

Overall Recommendation

If you fit any of the following descriptions, I rate this book as a must-read:

- Anyone leading or contemplating a PowerPivot deployment (the total system, as opposed to just viewing it as Excel 2010++)

- Excel pros who have read Bill's book and want to expand their expertise - I suspect a lot of you will decide, correctly, that a full PowerPivot system makes your talents a lot more valuable and visible, and will find yourselves on point for test deployments

-BI or SharePoint pros who are ramping up on PowerPivot (or evaluating PowerPivot's impact on their work)

Rob Collie
PowerPivotPro