SharePoint 2010 Business Intelligence 24-Hour Trainer
- 4h 12m
- Adam Jorgensen, Brad Schacht, Devin Knight, Mark Stacey, Patrick LeBlanc
- John Wiley & Sons (US)
- 2011
Learn to build and deliver SharePoint BI applications
Written by a team of leading SharePoint and Business Intelligence (BI) experts, this unique book 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 covers 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.
- 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.
About the Authors
ADAM JORGENSEN, MBA, is an SQL Server MVP and the President of Pragmatic Works. He focuses on mentoring senior executives and technical teams, helping them realize the potential in their organizational data and improve operational execution. Adam is also a regional mentor for the Greater Southeast chapter of SQLPASS and the co-founder and editor of BIDN.com (Business Intelligence Developer Network). Adam co-hosts SQL Lunch, a weekly live presentation series on SQL Server technology, with co-author Patrick LeBlanc. He co-chairs the SQLPASS Virtual Chapter for Business Intelligence and serves on other industry groups and boards. Adam has authored several books, whitepapers, and publications on business intelligence, management, and successful program implementation.
MARK STACEY has 10 years in data management and another 5 years in visualisation and information management. Mark has a vision for the enterprise - integrated information and data flow, collaborative and intelligent tools, and above all, productive people. He brings this vision about by using SharePoint, and he took one of the very first SharePoint 2010 for BI implementations in the world live.
DEVIN KNIGHT is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author on the books Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services and Knight's Microsoft Business Intelligence 24-Hour Trainer. Devin has spoken at past conferences like PASS, SQL Saturdays, and Code Camps. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, Florida, Devin is the Vice President of the local users' group (JSSUG).
PATRICK LEBLANC, SQL Server MVP and author, is currently a Business Intelligence Architect, trainer, and consultant for Pragmatic Works. He has worked as an SQL Server DBA for the past 11 years. His experience includes working in the Educational, Advertising, Mortgage, Medical, and Financial Industries. He is also the founder of TSQLScripts.com, SQLLunch.com, and the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events, including SQL Saturday's, PASS, SQL Rally, User Groups, and the SQL Lunch.
BRAD SCHACHT is currently a Business Intelligence consultant and trainer with Pragmatic Works Consulting in Jacksonville, Florida. He has helped numerous customers in successfully developing and implementing new business intelligence solutions into their organizations. He has presented at events, including SQL Saturdays, Code Camps, SQL Lunch, and SQL Server User Groups. Brad is an active member of his local SQL Server user group in Jacksonville, Florida (JSSUG). He is also a contributor on the community site BIDN.com.
In this Book
-
Introduction
-
Why SharePoint for Business Intelligence?
-
SharePoint 2010 Technical Overview
-
SharePoint Central Administration Overview
-
Data Security Overview in SharePoint 2010
-
Creating and Configuring Excel Services Applications
-
Creating and Configuring PerformancePoint Services Applications
-
Creating and Configuring Visio Services Applications
-
Creating and Configuring PowerPivot for SharePoint Services Applications
-
Creating Your First SharePoint Site for Business Intelligence
-
Configuring Reporting Services for SharePoint Integration
-
Implementing Business Connectivity Services in SharePoint
-
Developing and Deploying Excel Services Analytics Applications
-
Developing and Deploying PowerPivot Analytics Applications
-
Developing and Deploying Visio Services Analytics Applications
-
Implementing Data Refresh in Excel Services and PowerPivot
-
Developing and Deploying PerformancePoint Analytic Reports
-
Developing and Deploying PerformancePoint Scorecards
-
Creating and Deploying PerformancePoint Dashboards
-
Developing and Deploying PerformancePoint and SharePoint Filters
-
Strategy Mapping with Visio and PerformancePoint
-
Developing and Deploying Reporting Services Reports to SharePoint
-
Theming and Personalizing Your Business Intelligence Site
-
Using SharePoint Designer to Customize Master Pages
-
Controlling Your Reporting with Versioning, Auditing, and Content Expiration
-
Managing Report Approval with SharePoint Workflow
-
Setting up SharePoint Search to Catalog Analytics and Reports
-
Managing and Optimizing SharePoint SQL Server Databases
-
Tuning and Scaling SharePoint Service Applications
-
Planning Your SharePoint Business Intelligence Project
-
Preparing Your Business Intelligence Implementation
-
Creating Your SharePoint Project Checklist and Kickoff Plan
