
PowerPivot for Business Intelligence using Excel and SharePoint
Barry Ralston - Collection The Expert's Voice in Office SharePoint
Résumé
PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files.
PowerPivot for Business Intelligence Using Excel and SharePoint is your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you'll encounter when using PowerPivot. Each chapter takes you through a solution technique that's been proven in the real world.
- Covers the leading technology for bringing data analytics to the desktop
- Presents real-world solutions to real-world scenarios
- Written by a Microsoft Virtual Technical Specialist (VTS) for Business Intelligence
What you'll learn
- Install and verify the PowerPivot software
- Integrated existing, available data to deliver business intelligence
- Leverage Time Intelligence to report change over time
- Write Data Analysis Expressions (DAX) to create custom measures
- Identify and implement solutions for role-playing dimensions
- Recognize and work-around PowerPivot's missing features
Who this book is for
PowerPivot Solutions for Excel and SharePoint is aimed at information workers and data analysts who typically use Excel to drive business decisions. The book shows how you can apply PowerPivot to problems typically addressed through complicated and arcane spreadsheet techniques. Business people without the time and interest in learning Excel arcane will especially appreciate how PowerPivot enables them to easily create models and perform analysis far in advance of anything they could do using Excel alone.
L'auteur - Barry Ralston
Barry Ralston is Chief Architect for Business Intelligence with Birmingham-based ComFrame Software. Barry is also Microsoft's Virtual Technical Specialist (VTS) for Business Intelligence, responsible for assisting in Alabama, Mississippi, and Northwest Florida in sales efforts including customer meetings, software demonstrations and Proof of Concept efforts. Barry's client successes include: American Cast Iron Pipe Company, Georgia Tech Research Institute, Bank of Hawaii, Honda Manufacturing of Alabama and Aflac.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Apress |
Auteur(s) | Barry Ralston |
Collection | The Expert's Voice in Office SharePoint |
Parution | 30/03/2011 |
Nb. de pages | 304 |
Format | 18 x 23 |
Couverture | Broché |
Poids | 522g |
Intérieur | Noir et Blanc |
EAN13 | 9781430233800 |
ISBN13 | 978-1-4302-3380-0 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
- Informatique Bases de données
- Informatique Bases de données Produits SGBD SQL Server
- Informatique Informatique d'entreprise Groupware, workflow
- Informatique Bureautique Logiciels bureautiques Office
- Informatique Bureautique Logiciels bureautiques Excel
- Informatique Développement d'applications Programmation .NET
- Informatique Développement d'applications Conception et développement web
- Informatique Développement d'applications Langages ASP.NET
- Informatique Certifications Microsoft