Scripting School Provides Ant Online Training , AngularJS Online Training, Backbone js Online Training , Node.Js Online Training , JavaScript Online Training, LUA Online Training, Groovy Scripts Online Training , Groovy on Grails Online Training , HTML5 Online Training , Maven Online Training , Perl Script Online Training , PowerShell Online Training , Python Online Training , PHP Online Training , Ruby Script Online Training , Ruby on Rails Online Training , R Scripts Online Training , TCL Script Online Training , Unix Shell Script Online Training , VBScript Online Training ,Hadoop Online Training, Advanced Java Online Training, Core Java Online Training, Hibernate Online Training, J2EE Online Training, Spring Online Training, .NET Online Training, Microsoft BI Online Training, Microsoft SSAS Online Training, Microsoft SSIS Online Training, Microsoft SSRS Online Training, SharePoint BI Online Training, SharePoint Online Training, Windows Server 2008 Admin Online Training, Cognos Online Training, Datastage Online Training, Informatica Online Training, OBIA Online Training, OBIEE Online Training, Teradata Online Training, Advanced Perl Online Training, Android Online Training, Drupal Online Training, Joomla Online Training, PHP Online Training, Python Online Training, Salesforce Online Training, SAS Clinical Online Training, SEO Online Training, Veritas Volume Manager Online Training, Web Designing Online Training.

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
SharePoint BI Online Training institute in Hyderabad