商務智慧功能的 Excel Service (SharePoint Server 2013)Business intelligence capabilities in Excel Service (SharePoint Server 2013)

摘要:Excel 2013 提供各種商務智慧功能。了解 Excel Services (內部部署) 支援哪些功能。Summary: Excel 2013 offers a wide range of business intelligence capabilities. Learn which capabilities are supported in Excel Services (on premises).

Excel 會提供特定的商務智慧功能可方便比以往來瀏覽與分析資料。Excel Services 支援許多功能。請閱讀本文以了解有哪些 SharePoint Server 2013 與 Office Web Apps Server 支援在 Excel 中的功能。Excel offers certain business intelligence capabilities that make it easier than ever to explore and analyze data. Many of these features are supported by Excel Services. Read this article to learn about which capabilities in Excel are supported in SharePoint Server 2013 and Office Web Apps Server.

重要

本文資訊適用於內部部署 SharePoint Server 2013。如果您要尋找 Office 365 中的商務智慧的相關資訊,請參閱Excel、 SharePoint Online 和 Power BI for Office 365 的商務智慧功能The information in this article applies to on-premises deployments of SharePoint Server 2013. If you're looking for information about business intelligence in Office 365, see Business intelligence capabilities in Excel, SharePoint Online, and Power BI for Office 365.

Excel 2013 的商務智慧功能Business intelligence capabilities in Excel 2013

使用 Excel 2016,您可以建立強大的報表、 計分卡和儀表板。您可以將資料匯入 Excel、 排序、 和組織的資料,以及使用它來建立報表與計分卡。您也可以虛擬化及探索資料在 Excel 中使用強大的分析功能。下表說明在 Excel 中的商務智慧功能。Using Excel 2016, you can create powerful reports, scorecards, and dashboards. You can bring data into Excel, sort, and organize data, and use it to create reports and scorecards. You can also use powerful analytic capabilities in Excel to visualize and explore data. The following table describes business intelligence features in Excel.

表: Excel 2013 中的商務智慧功能概觀Table: Overview of business intelligence capabilities in Excel 2013

工作區Task area 功能Capability 描述Description
取得資料Get data
原生資料Native data
原生資料是已匯入 Excel 和 Excel 中的生活不需維持外部資料連線的資料。這是適用於使用靜態資料、 使用手動、 更新及建立發佈位置不支援外部資料連線的活頁簿的資料。Native data is data that was imported into Excel and lives in Excel without maintaining an external data connection. This is useful for working with static data, working with data that is updated manually, and creating workbooks that are published in locations where external data connections are not supported.
取得資料Get data
外部資料External data
外部資料是位於另一部電腦上及透過一或多個外部資料連線來存取 Excel 中的資料。Excel 可以連線到許多種資料來源。External data is data that resides on another computer and is accessed in Excel through one or more external data connections. Excel can connect to many kinds of data sources.
使用資料Work with data
資料模型Data Models
資料模型是包含多個資料表的資料集。您可以使用資料模型資料結合來自不同資料庫並建立資料表的資料之間的關係。您可以使用做為來源的資料模型的報表、 計分卡和儀表板。如需詳細資訊,請參閱PowerPivot: 強大的資料分析與 Excel 中的資料模型A Data Model is a dataset that consists of multiple tables. You can use Data Models to bring together data from different databases and create relationships between tables of data. You can use a Data Model as a source for reports, scorecards, and dashboards. For more information, see PowerPivot: Powerful data analysis and data modeling in Excel.
使用資料Work with data
快速填入Flash Fill
快閃填滿格式是可讓您快速又輕鬆地格式化資料顯示在 Excel 中的資料表中的功能。例如,假設您已將 Excel 匯入資料和已列出日期與時間、 欄和您只想要使用的日期。您可以插入新欄、 輸入您要使用的格式中的第一個項目對應的日期,然後使用閃爍填滿自動執行這項作業的表格中的所有列。Flash Fill is functionality that enables you to quickly and easily format data that is displayed in a table in Excel. For example, suppose that you have imported data into Excel and you have a column that lists dates and times, and you only want to use dates. You can insert a new column, type the date that corresponds to the first item in the format that you want to use, and then use Flash Fill to automatically do this for all the rows in your table.
建立報表Create reports
快速分析Quick Analysis
快速分析是功能可讓您選取的資料範圍,然後顯示該資訊的建議的方式。當您使用快速分析時,您可以看到功能圖表或資料表會類似之前實際上選取所要使用之圖表類型。Quick Analysis is functionality that enables you to select a range of data and see recommended ways to visualize that information. When you use Quick Analysis, you can see what your chart or table will resemble before actually selecting which chart type to use.
建立報表Create reports
報表Reports
報告可以包含表格、 線條圖、 橫條圖、 散佈圖繪圖、 雷達圖表及許多其他種類的圖表。您可以使用 Excel 建立強大的互動式樞紐分析圖與樞紐分析表顯示使用大量的資料來源的相關資訊。Reports can include tables, line charts, bar charts, scatter plots, radar charts, and many other kinds of charts. You can use Excel to create powerful, interactive PivotChart reports and PivotTable reports to display relevant information by using lots of data sources.
建立報表Create reports
計分卡Scorecards
計分卡是報告的一種特殊的設計用來顯示效能是否在-或關閉-目標一覽的一或多個衡量標準。計分卡通常會包含一或多個關鍵效能指標 (Kpi 的比較實際值與目標值,並使用圖形標記,例如色彩或符號一覽顯示的效能)。Scorecards are a special kind of report designed to show whether performance is on- or off-target for one or more metrics at a glance. Scorecards typically contain one or more key performance indicators (KPIs) that compare actual values to target values and use a graphical indicator, such as colors or symbols, to show performance at a glance.
在 Excel 中,您可以使用外部資料庫中所定義的 Kpi 或使用 Power Pivot 建立自己的 Kpi。In Excel, you can use KPIs that were defined in an external database or use Power Pivot to create your own KPIs.
建立報表Create reports
Power ViewPower View
Power View 是可用來建立具有高度互動檢視 excel 增益集。Power View 可讓您快速又輕鬆地建立報表、 計分卡和儀表板。您可以在檢視中的項目之間的連線設定一個報表中的值可以做為參數用於檢視中其他報告。如需 Power View 的詳細資訊,請參閱Power View: 探索、 視覺化,並呈現資料Power View is an add-in for Excel that you can use to create highly interactive views. Power View enables you to quickly and easily create reports, scorecards, and dashboards. You can configure connections between items in a view so that values in one report can be used as parameters for other reports in the view. For more information about Power View, see Power View: Explore, visualize, and present your data.
建立或編輯報表Create or edit reports
欄位清單與井字型欄位Field List and Field Well
當您建立樞紐分析圖或樞紐分析表報表時,您可以使用 [欄位] 區段來指定要在報表中顯示資訊。[欄位] 區段中包含的欄位清單井字型欄位]When you create a PivotChart or PivotTable report, you use the Fields section to specify what information to display in the reports. The Fields section contains the Field List and Field Well.
欄位清單會列出維度和成員從您要用於樞紐分析圖或樞紐分析表報告的資料來源等項目。您也可以使用 [欄位] 清單來判定您所要使用原生資料或外部資料。The Field List lists items such as dimensions and members from the data source that you are using for the PivotChart or PivotTable report. You can also use the Field List to determine whether you are using native data or external data.
井字型欄位]會顯示報表中顯示欄位] 清單中的項目。您可以變更哪些資訊會顯示在樞紐分析圖或樞紐分析表報表中所選取 (或清除) 不同的項目與量值。The Field Well shows which items from the Field List are displayed in the report. You can change what information is displayed in a PivotChart or PivotTable report by selecting (or clearing) different items and measures.
套用篩選Apply filters
時間表控制項Timeline control
時間表控制項是一種特殊的時間篩選器,您可以在 Excel 中使用。若要新增到工作表的時間表控制項,至少一個工作表上的報表必須使用包含行事曆日期/時間階層的資料。您可以使用時間表控制項以選取在單一的時間期間或時間範圍並連線至時間表任何報表會自動更新以顯示該時段的資訊。The Timeline control is a special kind of time filter that you can use in Excel. To add a timeline control to a worksheet, at least one report on the worksheet must use data that contains a calendar date/time hierarchy. You can use the timeline control to select a single time period or a range of time, and any reports that are connected to the timeline are automatically updated to show information for that time period.
套用篩選Apply filters
交叉分析篩選器Slicers
交叉分析篩選器會為您可以使用選取的一或多個項目做為篩選條件用於報告及計分卡在工作表中的篩選的類型。例如,假設您想要查看的項目,例如貴公司的上衣銷售資訊不同的色彩。您可建立列出衣色彩交叉分析篩選器、 連線至銷售報表,並再使用交叉分析篩選器檢視銷售資訊的交叉分析篩選器中選取的色彩。Slicers are a kind of filter that you can use to select one or more items to use as a filter for reports and scorecards in a worksheet. For example, suppose that you want to see sales information for different colors of items, such as shirts that your company carries. You can create a slicer that lists shirt colors, connect it to a sales report, and then use the slicer to view sales information for the colors that are selected in the slicer.
瀏覽與分析資料Explore and analyze data
快速探索Quick Explore
快速瀏覽是可讓您按一下 [使用 SQL Server Analysis Services 資料或 Power Pivot 資料的樞紐分析圖或樞紐分析表報表中的值,然後再查看該值會顯示圖表類型的其他資訊的功能。您也可以使用快速探索向下的切入向上 (或向下) 若要檢視較高 (或較低) 層級的樞紐分析圖或樞紐分析表報表中的詳細資料。Quick Explore is functionality that enables you to click a value in a PivotChart or PivotTable report that uses SQL Server Analysis Services data or Power Pivot data, and then see additional information about that value displayed as a chart type. You can also use Quick Explore to drill up (or down) to view higher (or lower) levels of detail in a PivotChart or PivotTable report.
使用進階的分析功能Use advanced analytic capabilities
導出成員與導出量值Calculated Members and Calculated Measures
導出成員與導出量值是您可以定義多維度運算式 (MDX) 查詢 Excel 中使用的項目。您可以建立導出的成員與導出量值對於使用儲存在 Analysis Services 中的多維度資料的樞紐分析圖或樞紐分析表報表。Calculated Members and Calculated Measures are items that you can define by using Multidimensional Expressions (MDX) queries in Excel. You can create calculated members and calculated measures for PivotChart or PivotTable reports that use multidimensional data that is stored in Analysis Services.
> [!IMPORTANT]> 導出成員與導出量值不計算欄位為相同的事項。您只能建立計算成員與導出量值時您已建立樞紐分析表報表] 或 [使用儲存在 Analysis Services 資料的樞紐分析圖報表。若要建立導出的成員或導出量值,您應該先熟悉使用的資料庫和必須精通撰寫 MDX 查詢。> [!IMPORTANT]> Calculated Members and Calculated Measures are not the same things as Calculated Fields. You can only create Calculated Members and Calculated Measures when you have created a PivotTable report or a PivotChart report that uses data that is stored in Analysis Services. To create calculated members or calculated measures, you should be familiar with the database that you are using and be proficient in writing MDX queries.
使用進階的分析功能Use advanced analytic capabilities
導出欄位Calculated Fields
導出的欄位可讓您變更使用 Power Pivot 建立資料模型。當您建立計算欄位時、 自訂欄新增至資料模型。這些資料行然後可用在您使用該資料模型建立的報告。Calculated Fields enable you to change a Data Model that was created by using Power Pivot. When you create Calculated Fields, custom columns are added to the Data Model. You can then use those columns in reports that you create using that Data Model.
> [!NOTE]> 若要建立導出的欄位,您應該先熟悉使用的資料庫和必須精通寫入資料分析運算式 (DAX)。> [!NOTE]> To create calculated fields, you should be familiar with the database that you are using and be proficient in writing Data Analysis Expressions (DAX).

SharePoint Server 中 Excel Services 支援的商務智慧功能Business intelligence capabilities supported in Excel Services in SharePoint Server

您已建立的報表、 計分卡和儀表板使用 Excel 後,您可以發佈這些項目至 SharePoint Server 2013,使其能在組織中的人。下表摘要說明 Excel Services (內部) 所支援的商務智慧功能。After you have created reports, scorecards, and dashboards using Excel, you can publish those items to SharePoint Server 2013 to make them available to people in your organization. The following table summarizes which business intelligence features are supported by Excel Services (on premises).

表: Excel Services 的商務智慧功能概觀Table: Overview of business intelligence capabilities in Excel Services

項目Item 在 SharePoint Server 2013 內部部署版本支援的 Excel services 吗?Supported in Excel Services in the on-premises version of SharePoint Server 2013?
外部資料連線External data connections
Excel Services 支援最外部資料連線。Excel Services 支援 SQL Server Analysis Services (SSAS)、 SQL Server 資料庫以及 OLE DB 和 ODBC 資料來源。如需詳細資訊,請參閱 < Data authentication for Excel Services (SharePoint Server 2013)Most external data connections are supported in Excel Services. Excel Services supports SQL Server Analysis Services (SSAS), SQL Server databases, and OLE DB and ODBC data sources. For more information, see Data authentication for Excel Services (SharePoint Server 2013).
資料模型Data Models
為 SQL Server Analysis Services 執行個體指定 Excel Services 的 Excel Services 中支援的資料模型。如需詳細資訊,請參閱 < SharePoint Server 2013 中的規劃 Excel Services 資料模型設定Data Models are supported in Excel Services as long as an instance of SQL Server Analysis Services is specified for Excel Services. For more information, see Plan Excel Services Data Model settings in SharePoint Server 2013.
快速填入Flash Fill
在瀏覽器視窗中檢視活頁簿時不支援快閃填滿格式。您可以編輯 Excel 活頁簿中使用閃爍填滿。Flash Fill is not supported when you view a workbook in a browser window. You can edit a workbook in Excel to use Flash Fill.
快速分析Quick Analysis
快速分析不支援在瀏覽器視窗中檢視活頁簿時。您可以編輯 Excel 活頁簿中使用快速分析。Quick Analysis is not supported when you view a workbook in a browser window. You can edit a workbook in Excel to use Quick Analysis.
報表與計分卡Reports and scorecards
Excel Services 支援的報表、 計分卡和儀表板使用 Excel 建立的。您可以檢視、 排序、 篩選和互動樞紐分析表、 以及瀏覽器視窗中的樞紐分析圖報表更加等一樣使用 Excel 用戶端。這包括使用 Power View 所建立的檢視。Reports, scorecards, and dashboards that were created by using Excel are supported in Excel Services. You can view, sort, filter, and interact with PivotTable reports and PivotChart reports in a browser window much such as you would by using the Excel client. This includes views that were created by using Power View.
欄位清單] 與 [井字型欄位] (適用於 PivotChart 與 PivotTable 報表)Field List and Field Well (for PivotChart and PivotTable reports)
Excel Services 支援開啟與使用 [欄位清單井字型欄位]瀏覽器視窗中的功能。The ability to open and use the Field List and Field Well in a browser window is supported in Excel Services.
時間表控制項Timeline control
Excel Services 支援使用現有的時間表控制項的能力。不過,若要新增到活頁簿的時間表控制項,您必須使用 Excel 用戶端。The ability to use an existing timeline control is supported in Excel Services. However, to add a timeline control to a workbook, you must use the Excel client.
交叉分析篩選器Slicers
Excel Services 支援使用現有的交叉分析篩選器的能力。不過,若要新增到活頁簿的交叉分析篩選器,您必須使用 Excel 用戶端。The ability to use existing slicers is supported in Excel Services. However, to add slicers to a workbook, you must use the Excel client.
快速探索Quick Explore
Excel Services 支援使用快速探索功能。您可以使用快速探索切入指及下檢視較高或較低層級的資訊。不過,您無法建立新的檢視使用瀏覽器視窗中的 [快速探索。The ability to use Quick Explore is supported in Excel Services. You can use Quick Explore to drill up and down to view higher or lower levels of information. However, you can't create new views using Quick Explore in a browser window.
導出成員與導出量值Calculated Members and Calculated Measures
Excel Services 支援使用現有的導出的成員與導出量值的能力。不過,若要建立導出的成員與導出量值,您必須使用 Excel 用戶端。The ability to use existing calculated members and calculated measures is supported in Excel Services. However, to create calculated members and calculated measures, you must use the Excel client.
導出欄位Calculated Fields
Excel Services 支援使用現有的計算的欄位的能力。不過,若要建立導出的欄位,您必須使用 Power Pivot for Excel。The ability to use existing calculated fields is supported in Excel Services. However, to create calculated fields, you must use Power Pivot for Excel.
商務智慧中心Business Intelligence Center
使用 SharePoint Server 2013 中的商務智慧中心網站範本。這可讓您建立做為儲存商務智慧內容,例如報表、 計分卡和儀表板的集中位置的網站。如需詳細資訊,請參閱 < Configure SharePoint Server 2013 的商務智慧中心A Business Intelligence Center site template is available in SharePoint Server 2013. This enables you to create a site that serves as a central location to store business intelligence content, such as reports, scorecards, and dashboards. For more information, see Configure a Business Intelligence Center in SharePoint Server 2013.
Excel Web Access 網頁組件Excel Web Access Web Part
在 SharePoint Server 2013 中使用 Excel Web Access 網頁組件。這可讓您顯示全部或部分的 Excel 活頁簿發佈至 SharePoint Server 2013。如需如何使用 Excel Web Access 網頁組件的詳細資訊,請參閱在 Excel Web Access 網頁組件中的顯示 Excel 內容An Excel Web Access Web Part is available in SharePoint Server 2013. This enables you to display all or part of an Excel workbook that was published to SharePoint Server 2013. For more information about how to use the Excel Web Access Web Part, see Display Excel content in an Excel Web Access Web Part.

Office Web Apps Server 2013 與 SharePoint Server 2013 支援的商務智慧功能Business intelligence capabilities supported in Office Web Apps Server 2013 and SharePoint Server 2013

Office Web Apps Server 是線上隨附的 Office Word、 Excel、 PowerPoint 和 OneNote 的應用程式。Office Web Apps Server 讓使用者瀏覽器檢視和編輯功能所提供的 Office 文件在瀏覽器中呈現。具有 SharePoint Server 2013 的組織可能也會使用 Office Web Apps Server,並具有特定的瀏覽器視窗中支援的商務智慧功能的影響。Office Web Apps Server is the online companion to Office Word, Excel, PowerPoint, and OneNote applications. Office Web Apps Server gives users a browser-based viewing and editing experience by providing a representation of an Office document in the browser. Organizations that have SharePoint Server 2013 might also be using Office Web Apps Server, and that has certain implications for which business intelligence capabilities are supported in a browser window.

重要

如果您的組織使用 SharePoint Server 2013 與 Office Web Apps Server,您的組織可以使用 Office Web Apps Server 或 SharePoint Server 2013 顯示活頁簿。此決策會影響在瀏覽器視窗中所支援的商務智慧功能。> 若要啟用使用者互動操作活頁簿包含資料模型或瀏覽器視窗中的 Power View 檢視,設定 Excel Services in SharePoint Server 2013 顯示活頁簿。這需要 SharePoint 管理員在 SharePoint Server 2013 中安裝所在的伺服器上執行新增 SPWOPISupressionSetting指令程式。如需詳細資訊,請參閱New-spwopisuppressionsettingIf your organization is using Office Web Apps Server together with SharePoint Server 2013, then your organization can use either Office Web Apps Server or SharePoint Server 2013 to display workbooks. This decision affects which business intelligence capabilities are supported in a browser window. > To enable people to interact with workbooks that contain a Data Model or Power View views in a browser window, configure Excel Services in SharePoint Server 2013 to display workbooks. This requires a SharePoint administrator to run the New-SPWOPISupressionSetting cmdlet on the server where SharePoint Server 2013 in installed. For more information, see New-SPWOPISuppressionSetting.

下表摘要說明 Office Web Apps Server 與 SharePoint Server 2013 所支援的商務智慧功能。The following table summarizes the business intelligence features that are supported by Office Web Apps Server and by SharePoint Server 2013.

表: Office Web Apps Server 與 SharePoint Server 的商務智慧功能概觀Table: Overview of business intelligence capabilities in Office Web Apps Server and SharePoint Server

Excel 功能Excel Capability Office Web Apps Server 用於顯示活頁簿時所支援的功能What's supported when Office Web Apps Server is used to display workbooks SharePoint Server 2013 用於顯示活頁簿時所支援的功能What's supported when SharePoint Server 2013 is used to display workbooks
外部資料連線與驗證方法External data connections and authentication methods
Office Web Apps Server 支援某些,但不是所有安全的外部資料連線類型。為 SharePoint Server 2013 設定為使用這些方法支援使用 Secure Store Service 或自動的服務帳戶的資料連線。Office Web Apps Server supports some, but not all, kinds of secure external data connections. Data connections that use Secure Store Service or an unattended service account are supported as long as SharePoint Server 2013 is configured to use these methods.
SharePoint Server 2013 支援大多數種外部資料連線。這些包括 SQL Server Analysis Services (SSAS)、 SQL Server 資料庫以及 OLE DB 和 ODBC 資料來源。SharePoint Server 2013 supports most kinds of external data connections. These include SQL Server Analysis Services (SSAS), SQL Server databases, and OLE DB and ODBC data sources.
如需驗證方法的詳細資訊,請參閱 < SharePoint Server 2013 中的 Excel Services 資料驗證For more information about authentication methods, see Data authentication for Excel Services in SharePoint Server 2013 .
資料模型Data Models
Office Web Apps Server 可讓您檢視活頁簿包含使用原生資料的資料模型。不過,您無法探索樞紐分析表報表、 樞紐分析圖報表,以及作為資料來源的資料模型的時間表控制項等項目中的資料。Office Web Apps Server enables you to view workbooks that contain Data Models that use native data. However, you can't explore data in items such as PivotTable reports, PivotChart reports, and timeline controls that use a Data Model as the data source.
SharePoint Server 2013 可讓您檢視、 互動,以及重新整理活頁簿包含使用原生或外部資料的資料模型。這包括探索樞紐分析圖和樞紐分析表報表中的資料,以及時間表控制項使用瀏覽器視窗中的功能。SharePoint Server 2013 enables you to view, interact with, and refresh workbooks that contain Data Models using native or external data. This includes the ability to explore data in PivotChart reports and PivotTable reports and to use timeline controls in a browser window.
快速填入Flash Fill
Office Web Apps Server 不支援使用閃爍填滿編輯瀏覽器視窗中的活頁簿時。不過,您可以使用閃爍填滿的 Excel 中開啟活頁簿。Office Web Apps Server does not support using Flash Fill when you edit a workbook in a browser window. However, you can open the workbook in Excel to use Flash Fill.
SharePoint Server 2013 時不支援閃爍填滿瀏覽器視窗中檢視活頁簿。不過,您可以使用閃爍填滿的 Excel 中開啟活頁簿。SharePoint Server 2013 does not support Flash Fill when you view a workbook in a browser window. However, you can open the workbook in Excel to use Flash Fill.
快速分析Quick Analysis
Office Web Apps Server 不支援使用快速分析編輯瀏覽器視窗中的活頁簿時。不過,您可以使用在 Excel 使用快速分析中開啟活頁簿。Office Web Apps Server does not support using Quick Analysis when you edit a workbook in a browser window. However, you can use open the workbook in Excel to use Quick Analysis.
SharePoint Server 2013 瀏覽器視窗中檢視活頁簿時,不支援快速分析。SharePoint Server 2013 does not support Quick Analysis when you view a workbook in a browser window.
報表與計分卡Reports and scorecards
Office Web Apps Server 可讓您以檢視、 排序及篩選報表、 計分卡和使用 Excel 所建立的儀表板。不過,Office Web Apps Server 不支援使用 Power View 所建立的檢視。Office Web Apps Server enables you to view, sort, and filter reports, scorecards, and dashboards that were created by using Excel. However, Office Web Apps Server does not support views that were created by using Power View.
SharePoint Server 2013 可讓您以檢視、 排序及篩選報表、 計分卡和使用 Excel 所建立的儀表板。這包括使用 Power View 所建立的檢視。SharePoint Server 2013 enables you to view, sort, and filter reports, scorecards, and dashboards that were created by using Excel. This includes views that were created by using Power View.
欄位清單] 與 [井字型欄位] (適用於 PivotChart 與 PivotTable 報表)Field List and Field Well (for PivotChart and PivotTable reports)
Office Web Apps Server 可讓您開啟與使用 [欄位清單井字型欄位]瀏覽器視窗中。Office Web Apps Server enables you to open and use the Field List and Field Well in a browser window.
SharePoint Server 2013 可讓您開啟與使用 [欄位清單井字型欄位]瀏覽器視窗中。SharePoint Server 2013 enables you to open and use the Field List and Field Well in a browser window.
時間表控制項Timeline control
Office Web Apps Server 可讓您可以使用現有的時間表控制項。您必須將時間表控制項新增到活頁簿使用 Excel 用戶端。Office Web Apps Server enables you to use an existing timeline control. To add a timeline control to a workbook you must use the Excel client.
SharePoint Server 2013 可讓您可以使用現有的時間表控制項。您必須將時間表控制項新增到活頁簿使用 Excel 用戶端。SharePoint Server 2013 enables you to use an existing timeline control. To add a timeline control to a workbook you must use the Excel client.
交叉分析篩選器Slicers
Office Web Apps Server 可讓您使用交叉分析篩選器。Office Web Apps Server enables you to use slicers.
SharePoint Server 2013 可讓您使用交叉分析篩選器。SharePoint Server 2013 enables you to use slicers.
快速探索Quick Explore
Office Web Apps Server 可讓您使用快速探索。Office Web Apps Server enables you to use Quick Explore.
SharePoint Server 2013 可讓您使用快速探索。SharePoint Server 2013 enables you to use Quick Explore.
導出成員與導出量值Calculated Members and Calculated Measures
Office Web Apps Server 支援包含計算的成員與導出量值的活頁簿。不過,若要建立導出的成員與導出量值,您必須使用 Excel 用戶端。Office Web Apps Server supports workbooks that contain calculated members and calculated measures. However, to create calculated members and calculated measures, you must use the Excel client.
SharePoint Server 2013 可讓您可以使用現有的導出的成員與導出量值。不過,若要建立導出的成員與導出量值,您必須使用 Excel 用戶端。SharePoint Server 2013 enables you to use existing calculated members and calculated measures. However, to create calculated members and calculated measures, you must use the Excel client.
導出欄位Calculated Fields
Office Web Apps Server 不支援導出的欄位。Office Web Apps Server does not support calculated fields.
SharePoint Server 2013 可讓您可以使用現有的計算的欄位。不過,若要建立導出的欄位,您必須使用 Power Pivot for Excel。SharePoint Server 2013 enables you to use existing calculated fields. However, to create calculated fields, you must use Power Pivot for Excel.
商務智慧中心Business Intelligence Center
您可以使用商務智慧中心網站範本來建立儲存商務智慧內容,例如報表、 計分卡和儀表板的集中位置。如需詳細資訊,請參閱 < Configure SharePoint Server 2013 的商務智慧中心You can use the Business Intelligence Center site template to create a central location to store business intelligence content, such as reports, scorecards, and dashboards. For more information, see Configure a Business Intelligence Center in SharePoint Server 2013.
您可以使用商務智慧中心網站範本來建立儲存商務智慧內容,例如報表、 計分卡和儀表板的集中位置。如需詳細資訊,請參閱 < Configure SharePoint Server 2013 的商務智慧中心You can use the Business Intelligence Center site template to create a central location to store business intelligence content, such as reports, scorecards, and dashboards. For more information, see Configure a Business Intelligence Center in SharePoint Server 2013.
Excel Web Access 網頁組件Excel Web Access Web Part
Excel Web Access 網頁組件在 SharePoint Server 2013 中可用的可讓您顯示全部或部分的 Excel 活頁簿發佈至 SharePoint] 頁面上的網頁組件中的 SharePoint 文件庫。即使 Office Web Apps Server 用來在瀏覽器視窗中顯示活頁簿、 Excel Web Access 網頁組件使用 Excel Services in SharePoint Server 2013 的網頁組件中顯示的內容。The Excel Web Access Web Part that is available in SharePoint Server 2013 enables you to display all or part of an Excel workbook that was published to a SharePoint library in a Web Part on a SharePoint page. Even if Office Web Apps Server is used to display workbooks in a browser window, the Excel Web Access Web Part uses Excel Services in SharePoint Server 2013 to display content in that Web Part.
如需如何使用 Excel Web Access 網頁組件的詳細資訊,請參閱在 Excel Web Access 網頁組件中的顯示 Excel 內容For more information about how to use the Excel Web Access Web Part, see Display Excel content in an Excel Web Access Web Part.
Excel Web Access 網頁組件在 SharePoint Server 2013 中可用的可讓您顯示全部或部分的 Excel 活頁簿發佈至 SharePoint] 頁面上的網頁組件中的 SharePoint 文件庫。The Excel Web Access Web Part that is available in SharePoint Server 2013 enables you to display all or part of an Excel workbook that was published to a SharePoint library in a Web Part on a SharePoint page.
如需如何使用 Excel Web Access 網頁組件的詳細資訊,請參閱在 Excel Web Access 網頁組件中的顯示 Excel 內容For more information about how to use the Excel Web Access Web Part, see Display Excel content in an Excel Web Access Web Part.

若要深入了解 Office Web Apps Server,請參閱 < Overview of Office Web Apps Server To learn more about Office Web Apps Server, see Overview of Office Web Apps Server .

另請參閱See also

概念Concepts

在 SharePoint Server 2013 中的 Excel Services 概觀Overview of Excel Services in SharePoint Server 2013

其他資源Other Resources

SharePoint Server 2013 的商務智慧新功能What's new in business intelligence in SharePoint Server 2013

Office Web AppsOffice Web Apps

Excel 和 SharePoint Online 中的商務智慧功能Business intelligence capabilities in Excel and SharePoint Online