Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

358



LESSON 38 Deploying anD Using excel services

12. To deploy this Excel workbook to SharePoint use the File tab and click Share or Save & Send.

13. Pick Save to SharePoint and select “Browse for a location,” as shown in Figure 38-6.

FIGURE 386

14. Type the SharePoint URL for the Knights24HourBI that you created in the previous lesson

for the folder location. If you are starting first on this lesson, just create a new site using the

Business Intelligence Center template.

15. Select the Documents document library and save the workbook as Knights24HourBI.xlsx.

16. With the workbook saved, open Internet Explorer and navigate to the SharePoint site to

which you just deployed the file. You should find it in the Documents document library.

17. Open the workbook in SharePoint and notice that it has the look and feel of Excel but is

built into SharePoint, as shown in Figure 38-7. You can interact with the pivot table just as

you would in Excel and drill down deeper into each hierarchy.

Congratulations! You just deployed your first Excel workbook to SharePoint. Now you can share all

current and future workbooks with the rest of your company.

889633c38.indd 358 8/16/10 9:11:33 PM

Try It



359

FIGURE 387

Please select Lesson 38 on the DVD to view the video that accompanies this

lesson. ...