Sharepoint 2010 Business Intelligence 24-hour Trainer

by Jorgensen, Adam; Stacey, Mark; Knight, Devin; LeBlanc, Patrick; Schacht, Brad

• ISBN13: 9781118026427
• ISBN10: 111802642X
• Format: Paperback
• Copyright: 2011-05-10
• Publisher: Wrox

Summary

The book shows how to successfully build and deliver Business Intelligence (BI) applications using SharePoint 2010. It does not assume previous SharePoint experience, since many new users come from database and other backgrounds. Topics include: Introduction to what SharePoint will do for your business intelligence and information management capabilities; BI projects include: i. PerformancePoint dashboards ii. Interactive reporting with excel iii. Power Pivot advanced analytics iv. Visio strategy maps and heat map analytics Information management projects include: i. Report and document sharing for collaborative reporting ii. Using SharePoint lists and libraries for data sources repositories in business intelligence projects iii. How to control sprawl of data sources, reports and business intelligence content with permissions and workflow approvals. iv. Connecting your data sources with Business Connectivity Services. Best practices for configuring and securing SharePoint 2010 business intelligence applications. Integrating Office 2010 and SharePoint for intelligent reporting. This specifically will cover how the Office user or analyst can create reports and dashboards right from within MS Office 2007 and 2010 and publish them to SharePoint. Implementing advanced analytics through PerformancePoint and business connectivity services. These analytics will provide time based analysis, forecasting, mapping, drill through and other advanced visualizations. Tuning and scaling SharePoint SQL databases and applications to support the new load that the reports, analytics and dashboards will place on the system. I am unaware of any book that covers this topic. Best practices for planning and implementing your SharePoint business intelligence project plan. This is a 24 hour trainer book, so it will have an explanation of the topics in each lesson along with a walkthrough. Each specific lesson is targeted to take about an hour each and accompanied by a video walking the reader through the lesson and the step by step "Try It" section at the end of the lesson.

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.