This class will teach you:

• SharePoint as a BI Platform
• Administration and Server Architecture
• The Report Center Template
• Creating an Enterprise Report Center
• The Business Data Catalog
• Building Key Performance Indicators
• Creating Digital Dashboards
• PerformancePoint Integrated Features
• SQL Reporting Services
• Incorporating External Business Data
• Monitoring/Best Practice Techniques

Receive a bonus CD: Those attending receive an instructor-developed CD loaded with resources for building a solid knowledge management program – A great reference back at work.

Integrate the best of BI Tools with the power of SharePoint to create a solid Business Intelligence and Knowledge Management Program!

SharePoint has proven to be a great management tool for thousands of companies and organizations. Flexibility and easy customization have made it a true winner for a host of applications. Now you can take full advantage of SharePoint as the premier platform for dynamic business intelligence and knowledge management in your organization. With this two day program, you will identify and examine the key BI tools that are available in your Microsoft suite, and which will work best for you integrated within a SharePoint Business Intelligence platform. Your efforts will pay off with better document management, security, external data integration and information dissemination – in a systematic and well organized environment.

Detailed “how to” labs drive home the key technical issues and hurdles you may face. Leave class with real-world solutions.

If you’re using SharePoint as a platform in your organization, you have what you need to create a successful and productive Knowledge Management System and Business Intelligence Platform. You have the tools: SQL Server, SharePoint and Office 2007, Excel, PerformancePoint, Integration services, and more. This program is chock full of hands-on labs that show you these tools in action: how they will integrate, and how they will work in your environment. Through expert technical direction and a “learn by doing” environment, you will leave this class with a plan of action in place and the ability to follow through.

Immediate Benefits of Attending this program:

1. Understand SharePoint’s Business intelligence feature set.
2. Accurately determine resource requirements both technical and managerial.
3. How to deploy SharePoint BI applications that meet specific business needs.
4. Understand SharePoint’s Excel Services and its benefits/limitations.
5. Publish Excel Workbook data to users through Excel Web Services.
6. Use Key Performance Indicators (KPI’s) to display key business data.
7. Get to know the SharePoint Report Center template.
8. Understand the elements of PerformancePoint Server you will want to incorporate.
9. Understand the Business Data Catalog (BDC) and how it accesses external line-of-business applications.
10. Create a BDC application definition and get to know some tools to help automate the process.
11. Use Web parts to work with data that is stored in line-of-business systems outside of SharePoint.
12. Use external business data from within SharePoint lists.
13. Understand SharePoint Data Connection Libraries.
14. Access data connections from within SharePoint.
15. Learn to create digital dashboards for executive summaries of information.
16. Understand OLAP and its relationship and capabilities within SharePoint.
17. Cover best practices for Business Intelligence.
18. Work with the SQL Server Business Intelligence Development Studio.
19. Configure and optimize search to easily locate external business information.
20. Understand which technologies will work for your organization and when to use them.
21. Effectively deal with the glitches and problem areas of integration.
22. Work with SQL Server Reporting Services from within SharePoint and digital dashboards.

This is a results-oriented workshop!

Developing an ideal business intelligence environment requires the seamless meshing and integration of multiple data management and reporting tools. Not always so simple. In this dynamic workshop, your expert instructor will show you how to effectively engage those tools you already have in your environment, then fine tune a solid business intelligence and knowledge management platform. Step by step, discover:

• Why is a BI Program essential to growth and success?
• Why choose Sharepoint as your knowledge management platform?
• What to consider – where are the potential problems?
• Which BI tools from your suite make the most sense to incorporate?
• How to integrate these tools seamlessly
• What are the technical requirements to get it done right?
• Managing the BI and knowledge management platform
• With your information management tools and Resources, create a dynamic Business Intelligence Platform

You’ll examine and discuss every source you have available, their benefits and limitations - then judge which ones will work best for your needs.