Azure Analysis Services Purchase the entire course

21 December 2018 · · 150 views

Power BI Course

Azure Analysis Services

This video introduces Azure Analysis Services: a cloud-based version of SQL Server Analysis Services, which is essentially the same database engine that Power BI uses but available as a separate service. For enterprise Power BI customers there is a difficult decision to make around whether to use Power BI Premium, Azure Analysis Services or both, made more complex by Microsoft’s stated intention to make Power BI Premium a superset of Azure Analysis Services in terms of functionality.

Creation and configuration of an Azure Analysis Services instance takes place in the Azure Portal and requires an Azure subscription. When choosing a service tier you will need to consider how much CPU capacity you will need which is expressed in QPUs, how much memory, and also whether you are using Import mode or DirectQuery mode. Development of Tabular models for Azure Analysis Services takes place in SQL Server Data Tools (SSDT), although there is also a very basic web-based development environment.

When deciding whether Azure Analysis Services or Power BI Premium is right for your organisation, you need to take into account several factors. First of all, developing in SSDT has some advantages over developing in Power BI Desktop. You also need to consider whether a centralised model such as Azure Analysis Services is a better fit for the way you work than multiple de-centralised models, which is generally how things turn out in a pure Power BI implementation. You also have to consider that Azure Analysis Services places no limits on the size of a model or on how often you can refresh data, and has more sophisticated security functionality. All of this comes at the cost of additional complexity when developing and managing Azure Analysis Services. Also bear in mind that Power BI Premium offers a lot more functionality than Azure Analysis Services, which is just a database.

Finally, pricing for Azure Analysis Services can be difficult to determine because you can scale-up and scale-out on demand, depending on your requirements. You will need to consider what resources you will need and when in order to get an accurate idea of how much Azure Analysis Services will cost.

Purchase this course to learn not only about Azure Analysis Services, but also about the entire Microsoft Power BI.

Log in or purchase access to play the video.

  • Power BI New Features and Course Updates 1-min Free—Watch Now

  • What is Power BI? 59-min Watch with Free Subscription

  • Licensing 8-min

  • Connecting to Data Sources 42-min

  • Connecting to Data Sources (2018 Updates) 23-min

  • Data Import Concepts 55-min

  • Transforming Data with the Query Editor 1-hour 20-min

  • Transforming Data with the Query Editor (2018 Updates) 13-min

  • Advanced Data Loading 49-min

  • Modelling Data 1-hour 10-min

  • Modelling Data (2018 Updates) 14-min

  • DAX and the Data Model 31-min

  • DAX and the Data Model (2018 Updates) 10-min

  • Power BI Desktop vs Excel 37-min

  • Cloud and Desktop Power BI Dashboards and Reports 45-min

  • Power BI Reports (2018 Updates) 40-min

  • Building Reports in Excel 32-min

  • Sharing, Distribution, and Security 42-min

  • Data Refresh 8-min Free—Watch Now

  • Administration and Auditing 11-min Watch with Free Subscription

  • Azure Analysis Services 1-hour 3-min

  • Power BI Premium and Power BI Embedded 36-min Watch with Free Subscription

Purchase a Full Access Subscription

Individual Subscription


Access all content on this site for 1 year.
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo