Azure Analysis Services
Being a PaaS or a completely managed platform as a service integrated in Azure data platform services, Azure Analysis Services enable data modeling in the cloud on the enterprise level. Using Azure Analysis Services, developers can mix and combine lots of data types from different sources, identify metrics, and protect their data in one semantic data model. This data model allows users to browse huge amounts of data using different client applications such as Reporting Services, Excel, Power BI as well as custom and third-party applications.
Azure Analysis Services features compatibility with the Enterprise Edition of SQL Server Analysis Services. It supports many useful features such as translations, bi-directional relationships, low-level security, partitions, and tabular models which ensure quick development and are very customizable.
Developers can build complex solutions because Azure Analysis Services can integrate with other Azure services.
- Azure Functions and Automation allow to write a custom code.
- Azure Data Factory makes easier loading data into the model.
- Azure Active Directory ensures security when users access their critical data.
Developers who have an Azure subscription can easily create a server in Azure portal because they don’t need to manage infrastructure. They can take advantage of using PowerShell or templates from Azure Resource Manager. A single declarative template allows developers to effectively use a variety of services and other Azure components like Azure Functions and storage accounts. Developers can create a tabular mode and connect to Azure SQL services or import a .pbix file from Power BI. They can also edit measures and the model.bim files from their browser in JSON format.
Users can choose plans within a tier and scale resources up or down to match their business needs. They can also visualize their data, using Visual Studio and use their existing tabular models by deploying them to the cloud.