Custom cover image
Professional Microsoft PowerPivot for Excel and SharePoint / Sivakumar Harinath; Ron Pihlgren Denny Guang-Yeu Lee
Contributor(s): Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Series: Wrox professional guides | Wrox programmer to programmerPublisher: Indianapolis, Ind : Wiley Pub., Inc, c2010Edition: Online-AusgDescription: Online-Ressource (1 online resource (xxvi, 358 p.)) : illISBN:- 9781282643291
- 1282643290
- 9780470912416
- 0470587377
- Microsoft PowerPivot for Excel and SharePoint
- Excel 2010
- SharePoint 2010
- SQL Server 2008 Reporting Services
- Pivot-Operation
- Microsoft SharePoint (Electronic resource)
- Microsoft Excel (Computer file)
- SQL server
- Client/server computing
- Business intelligence
- Business intelligence ; Computer programs
- Microsoft Excel (Computer file)
- Microsoft SharePoint (Electronic resource)
- SQL server
- Electronic books
- 005.7565
- HF5548.4.M523
Contents:
Summary: 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.Summary: 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 -- 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.PPN: PPN: 808911430Package identifier: Produktsigel: ZDB-26-MYL | ZDB-38-EBR | ZDB-30-PAD | ZDB-30-PBE | ZDB-30-PQE
""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
No physical items for this record