關於 SQL Server Analysis ServicesAbout SQL Server Analysis Services

Analysis Services 是用於決策支援和商業分析的分析資料引擎。Analysis Services is an analytical data engine used in decision support and business analytics. 它提供企業級語意資料模型報表和用戶端應用程式,例如 Power BI、 Excel、 Reporting Services 報表和其他資料視覺效果工具。It provides enterprise-grade semantic data models for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

一般工作流程包含在 Visual Studio 中建立表格式或多維度資料模型專案、 將模型部署為資料庫的伺服器執行個體、 設定週期性的資料處理和指派權限以允許由使用者進行資料存取。A typical workflow includes creating a tabular or multidimensional data model project in Visual Studio, deploying the model as a database to a server instance, setting up recurring data processing, and assigning permissions to allow data access by end-users. 準備就緒時,就可以存取語意資料模型支援 Analysis Services 做為資料來源的用戶端應用程式。When it's ready to go, your semantic data model can be accessed by client applications supporting Analysis Services as a data source.

Analysis Services 會在兩個不同的平台:Analysis Services is available in two different platforms:

Azure Analysis Services -支援 1200年和更高的相容性層級的表格式模型。Azure Analysis Services - Supports tabular models at the 1200 and higher compatibility levels. DirectQuery、資料分割、資料列層級安全性、雙向關聯性和翻譯全都支援。DirectQuery, partitions, row-level security, bi-directional relationships, and translations are all supported. 若要進一步了解,請參閱Azure Analysis ServicesTo learn more, see Azure Analysis Services.

SQL Server Analysis Services -支援表格式模型在所有相容性層級、 多維度模型、 資料採礦和 Power Pivot for SharePoint。SQL Server Analysis Services - Supports tabular models at all compatibility levels, multidimensional models, data mining, and Power Pivot for SharePoint.

依區域列出的文件Documentation by area

一般情況下, Azure Analysis Services 文件隨附 Azure 文件。In general, Azure Analysis Services documentation is included with Azure documentation. 如果您想要在雲端中有您的表格式模型,最好是從該文開始。If you're interested in having your tabular models in the cloud, it's best to start there. 此發行項與本節中的文件主要是用於 SQL Server Analysis Services。This article and documentation in this section is mostly for SQL Server Analysis Services. 不過,至少針對表格式模型,如何建立及部署表格式模型專案是不變,不論您使用的平台。However, at least for tabular models, how you create and deploy your tabular model projects is much the same, regardless of the platform you're using. 請檢查下列各節,若要深入了解:Check out these sections to learn more:

另請參閱See also

Azure Analysis Services 文件 Azure Analysis Services documentation
SQL Server 文件SQL Server Documentation