PowerPoint Broadcast site – SharePoint 2010

Some basic concept related to new feature - PowerPoint broadcast site

• Its new service in SharePoint 2010 which will allow user to broadcast presentation online (it is same like if we are giving webex/NetMeeting session) in which we have presenter and attends for each online meeting.
• We can see “broadcast this PowerPoint” as one of the option in PowerPoint 2010.
• For broadcasting any PowerPoint we need to have PowerPoint broadcast service enabled into any site.
• We can create PowerPoint broadcast site from central admin site collection and that site URL we can use in PowerPoint 2010 for broadcasting any PowerPoint file.
• We need to add presenter and attends users into sharepoint group for them to see broadcast.

Reference Link: http://www.sharepointedutech.com/2011/01/31/sharepoint-2010-and-powerpoint-2010-broadcast/

How to install Office web app for SharePoint 2010

• Office Web Apps is an online version of Microsoft Word, Excel, PowerPoint and OneNote application, which allowing users to access these all Microsoft applications and their respective documents from any Internet connection and any web browsers.
• It is same like Google documents; in which we don’t require to have Microsoft application installed on our local desktop to browse/access any Google documents from internet.
• Once we successfully deploy Office Web Apps on SharePoint farm, it will add the following service applications into farm.

• Word Viewing Service Application
• Excel Calculation Service
• PowerPoint Service Application

Reference Link: http://sharepointgeorge.com/2010/installing-office-web-apps-for-sharepoint-2010/

How to configure PDF search in SharePoint 2010

By default SharePoint won’t search PDF contents in any SharePoint site (same like MOSS 2007)

So we need to install Adobe iFilter on server and follow configuration steps as per below link to able to successfully crawl and search PDF documents and contents.

Link: http://www.sharepointsharon.com/2010/03/sharepoint-2010-and-adobe-pdf/

Installation of SharePoint 2010 on stand alone machine

Reference Link: http://sharepoint2010blog.blogspot.com/search/label/SharePoint%202010%20Installation

Overall steps:

1) Run SharePoint.exe for SharePoint 2010

2) Install pre-requisite from menu option

3) Restart the computer

4) Enter the product key for SharePoint 2010

5) Select standalone or server farm for installation and follow the Microsoft pattern installation wizard.

6) After successful installation, system will ask to create default web site at port 80 (central admin site is created automatically based on the setting we choose during installation)

How to Install PowerPivot for SharePoint on an Existing SharePoint Server

I have followed this Microsoft MSDN Link http://msdn.microsoft.com/en-us/library/ee210616.aspx for PowerPivot installation. Believe me its very good link, it has good amount of information, I have followed same steps and able to successfully installed PowerPivot on server.

Here are brief points which needed for PowerPivot installation.

Prerequisites: we need to have server farm installation on SharePoint 2010 server to install Powerpivot.

Overall Steps:

1) Run SQL Server 2008 R2 setup to add “PowerPivot for SharePoint” to Sharepoint farm.

• During installation, select “new installation/add features” option.
• Select “SQL Server Powerpivot for SharePoint” option.
• As per the requirement, select “Add Powerpivot for SharePoint - existing farm”.
• Complete the Powerpivot installation from SQL Server install file by following installation wizard.

2) Deploy the PowerPivot Solution Package from central admin to respective web application

• There are two separate solution packages: powerpivotfarm.wsp and powerpivotwebapp.wsp. The first solution (powerpivotfarm.wsp) is deployed when we install the first PowerPivot for SharePoint instance and never needs to be deployed again. The second solution (powerpivotwebapp.wsp) is deployed for Central Administration, but we must need to deploy this solution manually for each SharePoint web application that will support PowerPivot data access

3) Start Services on the Server:

• Start the Claims to Windows Token Service.
• Start Excel Calculation Services.
• Start Secure Store Service.

4) Verify that both SQL Server Analysis Services and SQL Server PowerPivot System Service are started.

5) Create a PowerPivot Service Application (SQL Server PowerPivot Service Application) from Manage service applications option.

6) Enable Excel Services

7) Enable Secure Store Service and Configure Data Refresh

8) Configure the Unattended PowerPivot Data Refresh Account

9) Configure Usage Data Collection

10) Activate PowerPivot Feature Integration for Site Collections

How to verify Installation:

1) In Libraries, we can see new options called “Data Feed Library” and “PowerPivot Gallery”. These library templates are provided by the PowerPivot feature and will be visible in the Libraries list if the feature is integrated correctly.

2) We can create sample excel book which has PowerPivot data and upload same excel into "PowerPivot gallery" library to check about PowerPivot features working fine or not.

NOTE: Once we create/upload any PowerPivot excel book into "PowerPivot gallery" library, behind the scene system is creating separate database for uploaded excel book (we can check this thing by going to SQL Server Management studio and select Analysis Services and in Server Name, need to enter <server-name>\powerpivot to see created database)

We can create PowerPivot data from Excel 2010, if we are not able to see "PowerPivot" as one of the option in excel 2010 ribbon, and then we need to install Add-ins PowerPivot for Excel 

Enjoy in installation!