Learn to build and deliver SharePoint BI applications Written by a team of leading SharePoint and Business Intelligence (BI) experts, this unique book-and-DVD package shows you how to successfully build and deliver BI applications using SharePoint 2010. Assuming no previous SharePoint experience, the authors deliver a clear explanation of what SharePoint will do for your BI and information management capabilities.
Each lesson in the book is reinforced with a helpful tutorial on the DVD and cover topics such as interactive reporting with Excel, document sharing for collaborative reporting, and controlling data sources. As you learn best practices for configuring and securing SharePoint 2010 BI applications and planning and implementing your SharePoint BI project plan, you'll be well on your way to gaining a solid foundation of understanding and working with SharePoint 2010 and BI.
- Provides an invaluable training book-and-DVD package that takes you through building and delivering BI applications using SharePoint 2010
- Features an accompanying video tutorial for each lesson covered in the book, along with a "Try It" section at the end of each lesson
- Covers interactive reporting with excel
- Covers Power Pivot advanced analytics
- Details report and document sharing for collaborative reporting Shows how to use SharePoint lists and libraries for data sources repositories in your BI projects
- Explains how to control data sources, reports and business intelligence content with permissions and workflow approvals.
With this unique book-and-DVD combo, you'll be well on your way to successfully building and delivering BI applications using SharePoint 2010.
Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.
Table of Contents:
INTRODUCTION. SECTION I: GETTING STARTED WITH SHAREPOINT 2010.
LESSON 1: WHY SHAREPOINT FOR BUSINESS INTELLIGENCE?
LESSON 2: SHAREPOINT 2010 TECHNICAL OVERVIEW.
LESSON 3: SHAREPOINT CENTRAL ADMINISTRATION OVERVIEW.
LESSON 4: DATA SECURITY OVERVIEW IN SHAREPOINT 2010.
SECTION II: CONFIGURING SHAREPOINT FOR BUSINESS INTELLIGENCE.
LESSON 5: CREATING AND CONFIGURING EXCEL SERVICES APPLICATIONS.
LESSON 6: CREATING AND CONFIGURING PERFORMANCEPOINT SERVICES APPLICATIONS.
LESSON 7: CREATING AND CONFIGURING VISIO SERVICES APPLICATIONS.
LESSON 8: CREATING AND CONFIGURING POWERPIVOT FOR SHAREPOINT SERVICES APPLICATIONS.
LESSON 9: CREATING YOUR FIRST SHAREPOINT SITE FOR BUSINESS INTELLIGENCE.
LESSON 10: CONFIGURING REPORTING SERVICES FOR SHAREPOINT INTEGRATION.
LESSON 11: IMPLEMENTING BUSINESS CONNECTIVITY SERVICES IN SHAREPOINT.
SECTION III: APPLYING SHAREPOINT 2010 BUSINESS INTELLIGENCE IN OFFICE.
LESSON 12: DEVELOPING AND DEPLOYING EXCEL SERVICES ANALYTICS APPLICATIONS.
LESSON 13: DEVELOPING AND DEPLOYING POWERPIVOT ANALYTICS APPLICATIONS.
LESSON 14: DEVELOPING AND DEPLOYING VISIO SERVICES ANALYTICS APPLICATIONS.
SECTION IV: CREATING ADVANCED ANALYTICS IN SHAREPOINT.
LESSON 15: IMPLEMENTING DATA REFRESH IN EXCEL SERVICES AND POWERPIVOT.
LESSON 16: DEVELOPING AND DEPLOYING PERFORMANCEPOINT ANALYTIC REPORTS.
LESSON 17: DEVELOPING AND DEPLOYING PERFORMANCEPOINT SCORECARDS.
LESSON 18: CREATING AND DEPLOYING PERFORMANCEPOINT DASHBOARDS.
LESSON 19: DEVELOPING AND DEPLOYING PERFORMANCEPOINT AND SHAREPOINT FILTERS.
LESSON 20: STRATEGY MAPPING WITH VISIO AND PERFORMANCEPOINT.
LESSON 21: DEVELOPING AND DEPLOYING REPORTING SERVICES REPORTS TO SHAREPOINT.
SECTION V: BRANDING AND MANAGING ORGANIZATIONAL BUSINESS INTELLIGENCE.
LESSON 22: THEMING AND PERSONALIZING YOUR BUSINESS INTELLIGENCE SITE.
LESSON 23: USING SHAREPOINT DESIGNER TO CUSTOMIZE MASTER PAGES.
LESSON 24: CONTROLLING YOUR REPORTING WITH VERSIONING, AUDITING, AND CONTENT EXPIRATION.
LESSON 25: MANAGING REPORT APPROVAL WITH SHAREPOINT WORKFLOW.
LESSON 26: SETTING UP SHAREPOINT SEARCH TO CATALOG ANALYTICS AND REPORTS.
SECTION VI: SCALING SHAREPOINT 2010 BUSINESS INTELLIGENCE.
LESSON 27: MANAGING AND OPTIMIZING SHAREPOINT SQL SERVER DATABASES.
LESSON 28: TUNING AND SCALING SHAREPOINT SERVICE APPLICATIONS.
SECTION VII: IMPLEMENTING SHAREPOINT BUSINESS INTELLIGENCE IN YOUR ORGANIZATION.
LESSON 29: PLANNING YOUR SHAREPOINT BUSINESS INTELLIGENCE PROJECT.
LESSON 30: PREPARING YOUR BUSINESS INTELLIGENCE IMPLEMENTATION.
LESSON 31: CREATING YOUR SHAREPOINT PROJECT CHECKLIST AND KICKOFF PLAN.
APPENDIX: WHAT’S ON THE DVD?
INDEX.
