Azure Analysis Services: The Missing Piece to a Complete BI Solution in Azure

On October 25, 2016, Microsoft announced the public preview of Azure Analysis Services which enables an entirely Azure-based BI solution and provides the ability to analyze your company’s data to every user, not just IT and data scientists.

The Case for a Semantic Layer in Your BI Solution

To understand the benefits of leveraging Azure Analysis Services, you must first understand Analysis Services and semantic layers in general.  Data access and use is needed everywhere, and as the amount of data within organizations grows, IT and/or Data Analyst resources are continually strained to deliver critical data to the end-users so they can leverage it to make decisions.

These layers:

  • are developed, secured, deployed and managed by IT teams.
  • allow end users to consume and query the data easily, without the need for technical expertise.
  • store calculations and KPIs in-memory, along with the tabular data, providing an extremely quick experience for the end-user retrieving insights from the data.
  • are developed in a familiar environment: SQL Server Data Tools in Visual Studio.


1 Grinslade, Bret. Digital image. Announcing Azure Analysis Services Preview. Microsoft, 25 Oct. 2016. Web.

The Case for Consuming Analysis Services as a PaaS

Once the need for a BI semantic layer is agreed upon, the decision for leveraging Azure Analysis Services becomes a simple one.  Delivering a complete BI solution, from data warehouse, semantic layer and visualization, without managing a single virtual machine is now possible.

  • You only need to pay for the level of services you need, which can be scaled and paused based off your specific needs.
  • You no longer need to focus on maintaining virtual machines to host your solutions, allowing you to devote your precious resources to making your data accurate and available.

Microsoft has added an important piece to the Azure puzzle with Azure Analysis Services. Microsoft continues to add important components that help IT professionals meet the demands of the ever-changing BI landscape.

Want more information? Email We are happy to help.

By |2019-04-23T10:52:12-05:00December 7th, 2016|Business Intelligence, Collaboration|Comments Off on Azure Analysis Services: The Missing Piece to a Complete BI Solution in Azure

About the Author:

With our expert IT team and technology, Peters & Associates provides full-service IT consulting, managed IT services, and IT security solutions in the Chicago area. Our award-winning work and proven successes help drive businesses forward. We solve challenges and build bridges to a better future with secure, scalable IT solutions aligned with your business needs and goals. A full service Chicago IT consulting firm, Peters & Associates has been successfully serving businesses in the Chicago area for over three decades with award-winning managed IT services and IT solutions for business, education, finance, manufacturing, and health care.