Business Intelligence in Microsoft® SharePoint® 2010
by Mariano Teixeira Neto Norman P. Warren John Campbell, and Stacia Misner
Business Intelligence in Microsoft® SharePoint® 2010
- Business Intelligence in Microsoft® SharePoint® 2010
- A Note Regarding Supplemental Files
- Introduction
- Which Tool Do I Use?
- Who Should Read This Book
- Scope of This Book
- Organization of This Book
- Chapter 1, Business Intelligence in SharePoint
- Chapter 2, Choosing the Right BI Tool
- Chapter 3, Getting to Trusted Data
- Chapter 4, Excel Services
- Chapter 5, PowerPivot for Excel and SharePoint
- Chapter 6, Visio and Visio Services
- Chapter 7, PerformancePoint Services
- Chapter 8, Bringing It All Together
- Appendix A: Virtual Machine Setup and SharePoint Configuration
- Appendix B: DAX Function Reference
- Appendix C: SharePoint As a Service—“Office 365”
- Finding Your Best Starting Point in This Book
- What’s Not in This Book
- Conventions Used in This Book
- Acknowledgments
- Errata and Book Support
- 1. Business Intelligence in SharePoint
- Introduction
- Leading Up to Business Intelligence
- Beware of Losing Sight of What Matters Most
- What Is BI?
- The Need for Business Intelligence Today
- Microsoft’s Vision for BI
- What SharePoint Does for BI
- The BI Stack: SQL Server + SharePoint + Office
- Authoring in Microsoft BI Tools
- Some Examples of BI in SharePoint 2010
- Summary
- 2. Choosing the Right BI Tool
- 3. Getting to Trusted Data
- Introduction to Trusted Data
- SQL Server 2008 R2 + SharePoint 2010 + Office 2010
- BI in SQL Server2008 R2
- Life Cycle of a BI Implementation
- Create a Cube from Data in SalesContosoDM
- Summary
- 4. Excel Services
- Excel Services Overview
- Configuration
- Create the Workbook
- Viewing and Editing Workbooks in Excel Services
- Extending Excel Services
- Summary
- 5. PowerPivot for Excel and SharePoint
- Introduction
- A Brief History of PowerPivot
- When Do I Use PowerPivot for Excel?
- When Do I Use PowerPivot for SharePoint?
- Getting Started
- Enhancing and Analyzing the Data
- Publishing to SharePoint
- PowerPivot Gallery
- Scheduling Data Refreshes
- Monitoring with PowerPivot for SharePoint
- Summary
- 6. Visio and Visio Services
- Introduction
- A Brief History of Visio
- What’s New in Visio 2010 and Visio Services
- When Do I Use Visio and Visio Services for BI?
- Configuration (Visio Services)
- Planning and Architecture (Visio Services)
- Creating the Visio Diagram
- Connecting to External Data and Display Data on the Shapes
- Publishing a Visio Diagram
- Visio Drawing Web Parts
- Summary
- 7. PerformancePoint Services
- Introduction
- History of PerformancePoint Services
- Overview of PerformancePoint Services Components
- What’s New in PerformancePoint Services
- When to Use PerformancePoint Services
- PerformancePoint Services Architecture
- PerformancePoint Services Configuration
- Providing a Performance Solution
- Design the KPIs, Scorecards, Reports, and Dashboard
- Create a Simple Dashboard
- Summary
- Quick Reference
- 8. Bringing It All Together
- Introduction
- Dashboards
- Dashboard (Web Part) Pages in SharePoint
- Use Excel Services in the Dashboard
- Add a SharePoint Filter to the Page
- Summary
- Quick Reference
- A. Virtual Machine Setup and SharePoint Configuration
- Options for Software Installation and Configuration
- Overview of Hyper-V, for Both Options
- Option 1: Set Up a Pre-configured VM
- Option 2: Set Up Your Own VMs on Windows 2008 R2
- SharePoint 2010 Installation and Configuration
- Security for the Services Dedicated to BI
- Conclusion
- B. DAX Function Reference
- C. SharePoint As a Service—“Office 365”
- Index
- D. About the Authors
- About the Authors
- Copyright
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.