Azure Synapse Analytics

The ultimate data platform: Unlimited scaling, lightning-quick – and financially attractive.

A quick overview: What is Azure Synapse Analytics?

Azure Synapse Analytics is an analysis service which combines big Data Warehouses with Big Data Analytics, and the product is an evolution of Azure SQL Data Warehouse. You can make data queries in your data lake – either with serverless resources or resources ready for use – on a large scale. It is primarily when we talk about large scale (more than 1 terabyte of data in your Data Warehouse) that Synapse makes sense for you.

Azure Synapse Analytics merges these two worlds into one experience that prepares, administrates and serves data relatively quickly, to be used, for instance, in Business Intelligence and Machine Learning.

With Azure Synapse Analytics, both relational and non-relational data can be queried using the known SQL language. This can be done either with serverless on-demand-queries for data exploration and ad hoc analyses or resources ready for use for the most demanding needs for data storage. In other words, one simple platform regardless of needs.

With Azure Synapse Analytics, you get:

  • Unlimited scaling
    Insight into all your data across sources – lighting-quick.
  • One consolidated analysis service
    One of the main strengths of Azure Synapse Analytics is that you can use one single analysis service and thus gain overview quicker. Development of analysis services is handled quickly and in one consolidated experience.
  • Always the newest data
    Get virtually instant insight into your company’s data across sources (e.g. Cosmos DB) with Synapse Link.
  • Unmatched security
    Your data is protected with the most advanced functions, e.g. dynamic data masking.

Understand what it is and what it can do.

Functions in Azure Synapse Analytics

With Azure Synapse, you gain quick insight into your data across Data Warehouses and Big Data analysis systems. You have the option to send queries for all kinds of data in petabyte scale using Microsoft’s SQL language, and with intelligent administration of workloads, it is easy to optimise performance for all queries. If you have many concurrent users, you should, however, be aware this will quickly increase the price.

Azure Synapse is integrated with Power BI, so that it is easy to gain insight into all your data. Development time for Business Intelligence projects is reduced through an unlimited analysis service.

With Azure Synapse Studio, you get a consolidated work area for data administration, data warehousing, data preparation, big data and AI. The Data Scientist can administrate data pipelines using a code-free, visual environment. The Data Administrator can automate the optimisation of the query. And the Business Analysts can gain secure access to the data set for use in Power BI – all in one consolidated analysis service.

With a local HTAP implementation using Synapse Link, you can remove the barriers between the Azure Cosmos database and Azure Synapse. This means that you always have insight into your operating data stores, which run almost in real-time. Your entire company can run pipelines for BI, analysis and Machine Learning – without a reduction in performance for the work processes on the Azure Cosmos database.

Azure has the most advanced functions for security and protection of personal data on the market. These functions are integrated in Azure Synapse. With detailed access control, it offers column-level security and integrated security at the row-level as well as dynamic data masking for automatic protection of confidential data in real-time.

Read more about security here.

Who is Azure Synapse Analytics developed for – and what can they use it for?

Business Analysts

Get quick, secure access to data sets and use Power BI to construct dashboards that are accessible in Synapse. The possibility to write T-SQL queries using SQL on-demand. In addition, you can work with data directly in the browser.

Data Scientists

Generate Proof of Concept in a few minutes and easily construct or adjust end-to-end solutions. Prepare resources for use as needed or send queries to existing server resource across enormous quantities of data. Choose your computer language, e.g. Python, R, .Net, Spark SQL or Scala.

Database administrators

Protect and administrate your organisation’s data more effectively and enforce GDPR requirements using data masking as well as row-level and column-level security. Azure Synapse Analytics is integrated with Azure Active Directory, which makes it easy to handle security since it is controlled through Azure Active Directory by way of the Data Lake as well as relationally on the SQL database. Synapse Analytics helps you match your growing responsibility for Data Warehouses and Data Lakes. You can run as many workloads as you want and allocate resources for escalating critical workloads.

Data Engineers

Synapse makes it simpler to extract more data types from more sources. A code-free and visual environment makes it easy to establish a connection to data sources, so that you can transform and place your data in your Data Lake and Synapse Analytics. It includes integration with the Azure Data Factory tool, so everything is in one place.

Do you want delve deeper into Azure Synapse Analytics?

Follow in the footsteps of a long list of Denmark’s ambitious companies: Complete the form or contact Søren – and we can chat about your challenges and dreams.

Søren Toft Joensen
Partner & CCO
+45 26 30 90 01
stj@kapacity.dk