PowerPivot for business intelligence using Excel and SharePoint
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 so...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
United States :
Apress
2011.
|
| Edición: | 1st ed. 2011. |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627741606719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Chapter 1 Getting Started with PowerPivot for Excel; Filling the Gap with PowerPivot for Excel; What You Will Need; The 64-bit Decision; Installing the Add-In; A Brief Tour of PowerPivot for Excel; A Trivial Test Case; The Test Report; Summary; Chapter 2 Hello World, PowerPivot Style; The Business Scenario; Assembling the Solution; Behind the Scenes in PowerPivot for Excel; Summary; Chapter 3 Combining Data Sources; The Business Scenario; Summary
- Chapter 4 Data Analysis ExpressionsFundamentals of DAX; Calculated Columns; Table Relationships; Calculated Measures from Multiple Data Sources; Filter Context; Summary; Chapter 5 A Method to the Madness; Justification for a Method; Principles; Practices; Summary; Chapter 6 Installing PowerPivot for SharePoint; Getting Started; Existing SharePoint 2010 Installation; Virtual Success; Running PowerPivot for SharePoint on Windows 7; Fun with PowerPivot and SharePoint; Potential Errors; Summary; Chapter 7 Collaboration, Version Control, and Management; Sharing Solutions; Publishing
- Web Usage ScenariosPowerPivot Management Dashboard; Summary; Chapter 8 PowerPivot As a Data Source; PowerPivot As a Data Source for PowerPivot; PowerPivot Management Dashboard As a Data Source; PowerPivot and PerformancePoint Dashboards; Summary; Chapter 9 PowerPivot and SQL Server Reporting Services; Consuming SSRS As a PowerPivot Data Source; Using PowerPivot As an SSRS Data Source; Summary; Chapter 10 PowerPivot and Predictive Analytics; Introducing the Data Mining Add-In for Excel; Installing the Data Mining Add-In; Locating the Table Analysis Tools; Creating a SSAS Connection
- Preparing Data with PowerPivotMining Some Data; Taking Data Mining to the Cloud with Predixion Software; Summary; Chapter 11 Tips, Tricks, and Traps; PowerPivot Annoyances; User Experience for PowerPivot Solutions; Tuning PowerPivot Performance; Summary; Index
