Microsoft Office Tutorials and References
In Depth Information
Create an Excel Services Report
Microsoft Excel is one of the most widely used packages for doing numerical analysis. As a file-based desktop
application, however, it is limited in its ability to reach a large audience and integrate with other solutions. As you
saw in Chapter 5, SharePoint Server 2013 incorporates Excel Services to address these issues by creating a server
environment for storing, processing, and delivering Excel content. With PerformancePoint Services, you have the
opportunity to leverage Excel’s analytical abilities and familiar user interface to integrate rich reports into your
PPS solutions.
In this section, we will create a simple Excel Services spreadsheet and deploy it to SharePoint. Then, we will
integrate the elements of that spreadsheet into our existing dashboard as a pair of new reports on a new page.
The new page will allow us to view a grid and a chart with a breakdown of our sales figures by Sales Territory.
Be prepared, there ar quite a few steps.
1.
Launch Excel 2013, and create a new blank workbook.
2.
On the ribbon menu, select Data From Other Sources From Analysis Services.
3.
Enter the name of the SSAS server containing the Adventure Works DW database
as shown in Figure 6-97 .
Figure 6-97. Selecting the database server to connect to
4.
Click Next.
5.
Select the Adventure Works DW database.
6.
Select the Adventure Works cube.
7.
Click Next.
8.
Enter “AWExcel.odc” for the File Name. (See Figure 6-98 .)
 
Search JabSto ::




Custom Search