Power BI Azure Synapse Analytics

Power BI is a well known and widely used Business Intelligence software tool.

It is widely used often because many users have Power BI because they’re Windows users and Power BI comes with Windows. It’s probably fair to say that users of the Power BI platform often don’t always fully assess the BI tools market since they mostly have what they need in Power BI

Despite Microsoft’s ability to update the Power BI platform on an almost constant basis, its capabilities aren’t always viewed as the most innovative on the market.

This could be about to change with Microsofts introduction of Power BI Azure Synapse Analytics.

Power BI Azure Synapse Analytics aims to integrate data warehousing and data analytics in a single BI cloud service that provides the functionality and tooling from both Microsoft Power BI and Azure Machine Learning.

Azure Synapse Analytics

ASA can be summarised as the next step in the evolution of Azure SQL Data Warehouse as the diagram below illustrates

Power BI Azure Synapse Analytics

What is Azure Synapse Analytics?

Azure Synapse is a limitless analytics service from Microsoft that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on  using either serverless on-demand or provisioned resources and the ability scale up or down as demand, performance and sizing dictates.

Azure Synapse Analytics combines Azure Data Factory with Azure SQL Data Warehouse.

You can still “buy” Azure Data Factory standalone but Azure SQL Data Warehouse is now Azure Synapse Analytics.

Micrsoft does not include Power BI or Azure Machine Learning into the Azure Synapse Analytics service directly, integrations are built-in at the metadata and user interface levels, so toolsets and functionality of PBI and machibne learning are available to users.

However whilst Power BI and Azure Machine Learning are treated as integration services in the longer run it seems logical that Microsoft will bundle them into Azure Synapse.

Speak Your Mind