Microsoft Data Platform Overview

  • Article

Update 2015-11-11: Updated the graphics to include Azure Data Catalog.

The variety of offerings in Microsoft's end-to-end analytics platform sometimes feels overwhelming, especially with the rapid evolution. For example, at the Build conference we announced the upcoming availability of Azure SQL DW and Azure Data Lake, while at the Ignite conference we presented the new functionality of SQL Server 2016.

To clarify our platform, here's three images that positions the different services. First here's a general overview of analytics platform capabilities. On the right hand and bottom side of the image you find traditional BI: OTLP sources, ETL, data warehouse and OLAP cubes. In the middle we add Big Data technologies and predictive analytics capabilities. Finally on the left side there's the technologies for real-time operational analytics in the world of the Internet of Things.

Next, here's how these capabilities map to the on-premises offerings:

Finally, here's how it maps to our Azure cloud services:

I hope these graphics help you position the different elements of the end-to-end Microsoft analytics platform!

Comments

  • Anonymous
    June 25, 2015
    Following up on my last post that provides an overview of Microsoft’s platform for analytics ,
  • Anonymous
    November 07, 2015
    Following the announcement of the reporting roadmap for SQL Server and Power BI at PASS 2015, I’ve
  • Anonymous
    December 01, 2015
    I’ve been presenting a lot on Big Data (specifically Hadoop) from the perspective of a SQL Server