Course Description
SharePoint 2010 for Business Intelligence
The Best of BI Tools Partnered with the Power of SharePoint
With this three-day SharePoint BI training course, 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.
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 2010, Excel, PerformancePoint, Integration services, and more. This course is loaded with 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 SharePoint BI training course with a plan of action in place and the ability to follow through.
What You Will Learn:
- Understand SharePoint's Business Intelligence feature set.
- How to deploy SharePoint BI applications that meet specific business needs.
- Understand SharePoint's Excel Services and its benefits/limitations.
- Publish Excel Workbook data to users through Excel Web Services.
- Get to know the SharePoint Business Intelligence Center template.
- Understand the elements of PerformancePoint Server you will want to incorporate.
- Understand Business Connectivity Services (BCS) and how they access external line-of-business applications.
- Use external business data from within SharePoint lists.
- Learn to create digital dashboards for executive summaries of information.
- Understand OLAP and its relationship and capabilities within SharePoint.
- Work with the SQL Server Business Intelligence Development Studio.
- Configure and optimize search to easily locate external business information.
- Work with SQL Server Reporting Services within SharePoint and digital dashboards.
Immediate Benefits of Attending this SharePoint BI Training Course:
- Understand SharePoint's Business intelligence feature set.
- Accurately determine resource requirements both technical and managerial.
- How to deploy SharePoint BI applications that meet specific business needs.
- Understand SharePoint's Excel Services and its benefits/limitations.
- Publish Excel Workbook data to users through Excel Web Services.
- Get to know the SharePoint Report Center template.
- Understand the elements of PerformancePoint Server you will want to
- incorporate.
- Understand the Business Data Catalog (BDC) and how it accesses external line-of-business applications.
- Create a BDC application definition and get to know some tools to help automate the process.
- Use Web parts to work with data that is stored in line-of-business systems outside of SharePoint.
- Use external business data from within SharePoint lists.
- Understand SharePoint Data Connection Libraries.
- Access data connections from within SharePoint.
- Learn to create digital dashboards for executive summaries of information.
- Understand OLAP and its relationship and capabilities within SharePoint.
- Cover best practices for Business Intelligence.
- Work with the SQL Server Business Intelligence Development Studio.
- Configure and optimize search to easily locate external business information.
- Understand which technologies will work for your organization and when to use them.
- Effectively deal with the glitches and problem areas of integration.
- 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
Substitution & Cancellation Policy:
You may cancel or reschedule up to 21 days prior to the start date of the class at no penalty. For any cancellation or reschedule requests within 21 days, the full course tuition is still due and not eligible for refund. Any paid tuition will be credited towards a future class and must be used within 12 months.
*Partner delivered courses may be subject to different cancellation terms