SharePoint BI Online Training Hyderabad India

Click Here For Course Content.

1). What is SharePoint 2010 BI and what includes?

  • SharePoint 2010 features
  • Performance point services (PPS 2010)
  • Power Pivot in SharePoint 2010
  • Sql reports in SharePoint 2010
  • Business connectivity services (BCS)
  • Visio Services in SharePoint 2010

2). SharePoint 2010 Installation

  • Software pre-requisites for SharePoint 2010 installation
  • Hardware pre-requisites for SharePoint 2010 installation
  • Standalone installation
  • server farm installation

3). Configuring SharePoint 2010

  • Configuring database server and verifying SharePoint databases in SSMS
  • Configuring SharePoint central administration
  • Start the required services in central administration
  • Configuring Business intelligence related services

4). Creating web application

  • Creating and configuring  web application
  • Creating site collection
  • Creating sub sites and procedure to create subsites
  • Creating Business intelligence site

5). Performance point services 2010

  • What is PPS and what are the versions?
  • Starting the PPS website and navigations to dashboard
  • PPS dashboard designer overview
  • Connecting external databases to PPS
  • Creating Dashboard, scorecards, KPI, Analytical Grid/chart and Filters
  • Sample dashboard with all objects including Visio diagrams
  • Publishing dashboard to SharePoint 2010
  • Verifying the dashboard in SharePoint and changing filter values
  • Verifying decomposition tree feature

6). SQL server reports in SharePoint 2010

  • Installing the SQL server reporting services in SharePoint mode
  • Configuring and verifying report server properties in SharePoint
  • Open the report builder 3.0 from SharePoint
  • Creating sample reports with report builder 3.0 and deploying to SharePoint
  • Uploading existing reports to SharePoint

7). Excel Power pivot in SharePoint 2010

  • Installing SQL server analysis services in power pivot mode
  • Creating a power pivot site in SharePoint
  • Connecting cube to power pivot and creating pivot reports
  • Working with slicers and dicers
  • Publishing reports to SharePoint
  • Providing reports access to SharePoint users

8). Visio services in SharePoint 2010

  • Creating diagrams in Visio and connecting to database
  • Publishing diagrams to SharePoint
  • Verifying the diagrams in SharePoint

9). Business connectivity services in SharePoint 2010

  • What is BCS and what are the versions?
  • Connecting legacy databases to SharePoint 2010
  • Sample on connecting SAP/Mainframes database to SharePoint

Training Enquiry

If you are unable to reach our contact number, Please fill the above Enquiry Form, otherwise send an email to for quick response.