Business Intelligence & Analytics · Azure Synapse Analytics

Azure Synapse Analytics

Enterprise-scale warehousing and big-data analytics in one service — provision only the compute you need, query the lake in place, and land the results in Power BI.

Capabilities

For estates that need warehouse-grade control over compute, storage and orchestration.

01

Dedicated SQL pools

A massively parallel warehouse for large, predictable workloads — scale the compute up for month-end and back down afterwards.

02

Serverless SQL

Query files sitting in the data lake with T-SQL and pay per query, with no cluster to provision.

03

Apache Spark pools

Managed Spark for preparation, machine learning and processing of semi-structured data.

04

Synapse Pipelines

Orchestrate ingestion and transformation across on-premises and cloud sources with the Azure Data Factory engine and its connector library.

05

Azure Synapse Link

Near real-time analytics over Dataverse and Cosmos DB without building or maintaining ETL.

06

Data Lake Storage

ADLS Gen2 as the common landing zone, with hierarchical namespaces and fine-grained access.

07

Synapse Studio

One workspace for SQL, Spark, pipelines and monitoring.

08

Power BI integration

Connect the warehouse straight into Power BI datasets and reports.

Ready to scale your analytics platform?

Talk to Our Experts
Back to home