Complete Understanding of SharePoint Architecture and its real time usage in the Current IT Industry of Business Intelligence Reports like Score Cards, Dashboards, Performance Point Services , KPI's and etc.

Topics Covered

Introduction to SharePoint Business Intelligence? * What is SharePoint Business Intelligence * Overview of SharePoint Business and Features Overview of SharePoint Service Applications * What is SharePoint Service Applications & Architecture * Explain about of Business Intelligence associated SA’s * Configuring Business Intelligence for SharePoint 2010 Excel Services * Configuring Excel Services * Hands-On Exercise on Excel Services Reporting Services for SharePoint * Introduction to SQL Server SSRS * Installing and Configuring SSRS for SharePoint * Configuring SSRS for SharePoint from Central Administration * Organizing Reports in SharePoint * Hands-On Exercise on Excel Services Performance Point Services * Introduction PPS * Configuring PPS for SharePoint * Hands On Exercises Power Pivot Services * Introduction PowerPiviot Services * Configuring Power Pivot for SharePoint * Hands On Exercises Business Connectivity Services * Introduction to BCS Services * Creating External Content Types using SP Designer * Configuring BCS Service Application & Administration * Using BDC OOB Web parts for Business Application Data * Hands On Exercises Visio Services * Introduction to Visio Services * Configuring Visio Services for SharePoint * Hands On Exercises SharePoint Business Intelligence Sites & Customization * SharePoint Business Intelligence Site Template * Customizing BI Sites * Deploying all BI Tools * Managing & Administration & Security of SharePoint Business Intelligence Applications. Advanced Techniques * Optimizing SharePoint Databases * Tuning SharePoint Business Service Applications. SharePoint BI Best Practices

Who should attend

SharePoint Administrator , SharePoint Developer & MSBI Analyst

Pre-requisites

SharePoint Basic Knowledge, MSBI Basic Knowledge

What you need to bring

NA"

Key Takeaways

Create All SharePoint out of Box features and Custom components Able to Configure and create the various Reports using BI and render on SharePoint site. Generate Powerful Reports using SSRS Design & Develop the Key Performance Indicators Quick Configuration of Excel APIs