Professional Microsoft PowerPivot for Excel and SharePoint

Sivakumar Harinath; Ron Pihlgren Denny Guang-Yeu Lee

The next wave of business intelligence, Self-Service BI, seeks to meet the demands of powerful hardware and shorter decision time frames. This book introduces PowerPivot for Excel and SharePoint, showing you how to use this innovative software for self-service analytics and reporting. 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. The book also discusses how to deploy and manage sandbox servers, and a companion website provides sample reports and applications.

MoreLess

Alternative title:	Microsoft PowerPivot for Excel and SharePoint
Year of publication:	c2010 ; Online-Ausg.
Authors:	Harinath, Sivakumar ; Pihlgren, Ron ; Lee, Denny Guang-Yeu
Publisher:	Indianapolis, Ind : Wiley Pub., Inc
Subject:	Softwareindustrie \| Software industry \| Software \| Kartellrecht \| Antitrust law \| Excel 2010 \| SharePoint 2010 \| SQL Server 2008 Reporting Services \| Pivot-Operation
Description of contents:	Table of Contents [gbv.de] ; Description [swbplus.bsz-bw.de]

Online Resource

Check full text access |

More access options

ebookcentral.proquest.com

Check Google Scholar

In libraries world-wide (WorldCat)

In German libraries (KVK)

subito order

I need help

Extent:	Online-Ressource (1 online resource (xxvi, 358 p.)) ill.
Series:	Wrox professional guides Wrox programmer to programmer
Type of publication:	Book / Working Paper
Language:	English
Notes:	Includes index. - "Wrox programmer to programmer"--Cover. - Description based on print version record Includes index ""Title Page""; ""Copyright""; ""Dedication""; ""About the Authors""; ""About the Technical Editor""; ""Credits""; ""Acknowledgments""; ""Introduction""; ""Who This Book Is For""; ""What This Book Covers""; ""How This Book Is Structured""; ""What You Need to Use This Book""; ""Conventions""; ""Source Code""; ""Errata""; ""p2p.wrox.com""; ""Part I: Introduction""; ""Chapter 1: Self-Service Business Intelligence and Microsoft PowerPivot""; ""SQL Server 2008 R2""; ""Self-Service Business Intelligence""; ""Power Pivot: Microsoftâ€™s Implementation of Self-Service BI""; ""Summary"" ""Chapter 2: A First Look at PowerPivot""""PowerPivot for Excel""; ""Setting the Stage""; ""PowerPivot for SharePoint""; ""Summary""; ""Part II: Creating Self-Service BI Applications Using PowerPivot""; ""Chapter 3: Assembling Data""; ""Importing Data""; ""Other Ways to Bring Data into PowerPivot""; ""The Healthcare Audit Application""; ""Assembling Data for the Healthcare Audit Application""; ""Summary""; ""Chapter 4: Enriching Data""; ""Exploring the PowerPivot Window""; ""Enriching Data for the Healthcare Audit Application""; ""Summary""; ""Chapter 5: Self-Service Analysis"" ""PivotTables and PivotCharts""""The PowerPivot Field List""; ""Slicers""; ""DAX Measures""; ""PowerPivot and Other Excel Features""; ""Analysis in the Healthcare Audit Application""; ""Summary""; ""Chapter 6: Self-Service Reporting""; ""Publishing PowerPivot Workbooks""; ""PowerPivot for SharePoint""; ""Adding Reporting to the SDR Healthcare Application""; ""Summary""; ""Part III: IT Professional""; ""Chapter 7: Preparing for SharePoint 2010""; ""SharePoint 2010""; ""Why Not SharePoint â€œLiteâ€� BI Edition?""; ""Excel Services""; ""Key Servers in PowerPivot for SharePoint"" ""Key Services in PowerPivot for SharePoint""""Services Architecture Workflow Scenarios""; ""Summary""; ""Chapter 8: PowerPivot for SharePoint Setup and Configuration""; ""Required Hardware and Software""; ""Setup and Configuration""; ""Multi-Server Farm Setup""; ""Verify the PowerPivot for SharePoint Setup""; ""Optional Setup Steps""; ""Summary""; ""Chapter 9: Troubleshooting, Monitoring, and Securing PowerPivot Services""; ""Troubleshooting Tools""; ""Troubleshooting Issues""; ""Monitoring PowerPivot Services""; ""Security""; ""Summary"" ""Chapter 10: Diving into the PowerPivot Architecture""""PowerPivot for Excel Architecture""; ""PowerPivot for SharePoint Architecture""; ""Summary""; ""Chapter 11: Enterprise Considerations""; ""Capacity Planning""; ""SharePoint WFEs""; ""SharePoint App Servers""; ""SharePoint Databases""; ""Upgrade and Patching Considerations""; ""Upload Considerations""; ""Summary""; ""Part IV: Appendix""; ""Appendix A: Setting Up the SDR Healthcare Application""; ""Setting Up the SQL Server Audit Database""; ""Setting Up the Database Group Name SharePoint List"" ""Setting Up the Client Address to State Report"" Professional Microsoft PowerPivot for Excel and SharePoint; About the Authors; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You need to uSe thIS book; conventIonS; Source code; errata; p2p.Wrox.com; Part I: Introduction; Chapter 1: Self-Service Business Intelligence and Microsoft PowerPivot; Chapter 2: A First Look at PowerPivot; Part II: Creating Self-Service BI Applications Using PowerPivot; Chapter 3: Assembling Data; Chapter 4: Enriching Data; Chapter 5: Self-Service Analysis; Chapter 6: Self-Service Reporting Part III: IT PROFESSIONALChapter 7: Preparing for SharePoint 2010; Chapter 8: PowerPivot for SharePoint Setup and Configuration; Chapter 9: Troubleshooting, Monitoring, and Securing PowerPivot Services; Chapter 10: Diving into the PowerPivot Architecture; Chapter 11: Enterprise Considerations; Part IV: Appendix; Appendix A: Up the SDR Healthcare Application; Index
ISBN:	978-1-282-64329-1 ; 1-282-64329-0 ; 978-0-470-91241-6 ; 0-470-58737-7 ; 0-470-58737-7 ; 978-0-470-91241-6 ; 978-0-470-58737-9 ; 0-8203-2755-7
Source:	ECONIS - Online Catalogue of the ZBW

Persistent link: https://www.econbiz.de/10012678604