+
+

Related Products

  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • TIMi
    68 Ratings
    Visit Website
  • AnalyticsCreator
    46 Ratings
    Visit Website
  • SCIKIQ
    14 Ratings
    Visit Website
  • Denodo
    388 Ratings
    Visit Website
  • DataBuck
    6 Ratings
    Visit Website
  • Google Cloud Platform
    61,066 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • DbVisualizer
    593 Ratings
    Visit Website
  • Plauti
    123 Ratings
    Visit Website

About

Azure Synapse is Azure SQL Data Warehouse evolved. Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless or provisioned resources—at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.

About

Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources. Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data. Microsoft’s Data Connectivity and Data Preparation technology that lets you seamlessly access data stored in hundreds of sources and reshape it to fit your needs—all with an easy to use, engaging, no-code experience. Power Query supports hundreds of data sources with built-in connectors, generic interfaces (such as REST APIs, ODBC, OLE, DB and OData) and the Power Query SDK to build your own connectors.

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Supported
Mac Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

IT and data teams searching for a powerful Data Warehouse solution

Audience

Businesses that need a data transformation and data preparation engine to improve their data analysis and decision-making

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported

API

Offers API Not Supported

API

Offers API Supported

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version Not Supported
Free Trial Supported

Pricing

No information available.
Free Version Not Supported
Free Trial Not Supported

Reviews/Ratings

Overall 3.0 / 5
ease 3.0 / 5
features 2.0 / 5
design 4.0 / 5
support 2.0 / 5

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Pros & Cons from Real Users

Pros

  • It feels familiar because we use a lot of Azure services and is good for data storage and for data warehousing.

Cons

  • Limited functionality in terms of prep and blend and a reliance on sql coding.

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Company Information

Microsoft
Founded: 1975
United States
azure.microsoft.com/en-us/services/synapse-analytics/

Company Information

Microsoft
Founded: 1975
United States
powerquery.microsoft.com/en-us/

Alternatives

Alternatives

FastQueryBuilder

FastQueryBuilder

Fast Reports
TROCCO

TROCCO

primeNumber Inc
CData Sync

CData Sync

CData Software

Categories

Big Data Supported
Columnar Databases Supported
Data Analysis Supported
Data Engineering Supported
Data Management Supported
Data Preparation Supported
Data Science Supported
Data Warehouse Supported
Database Supported
ETL Supported
OLAP Databases Supported

Categories

Data Integration Supported
Data Preparation Supported
ETL Supported

Data Warehouse Features

Ad hoc Query Not Supported
Analytics Supported
Data Integration Not Supported
Data Migration Not Supported
Data Quality Control Not Supported
ETL - Extract / Transfer / Load Not Supported
In-Memory Processing Not Supported
Match & Merge Supported

Integrations

Azure Data Lake Supported
data.world Supported
Appfigures Not Supported
CData Sync Supported
Cherwell Software Not Supported
Dasera Supported
DataClarity Unlimited Analytics Supported
Gravity Data Supported
InterSystems IRIS Not Supported
Mode Supported
PostgreSQL Not Supported
Precisely Connect Supported
Pyramid Analytics Supported
Qlik Data Integration Supported
QuickBooks Online Not Supported
Salesforce Data 360 Supported
Satori Supported
Secoda Supported
Siteimprove Not Supported
SurveyMonkey Not Supported

Integrations

Azure Data Lake Supported
data.world Supported
Appfigures Supported
CData Sync Not Supported
Cherwell Software Supported
Dasera Not Supported
DataClarity Unlimited Analytics Not Supported
Gravity Data Not Supported
InterSystems IRIS Supported
Mode Not Supported
PostgreSQL Supported
Precisely Connect Not Supported
Pyramid Analytics Not Supported
Qlik Data Integration Not Supported
QuickBooks Online Supported
Salesforce Data 360 Not Supported
Satori Not Supported
Secoda Not Supported
Siteimprove Supported
SurveyMonkey Supported
Claim Azure Synapse Analytics and update features and information
Claim Azure Synapse Analytics and update features and information
Claim Microsoft Power Query and update features and information
Claim Microsoft Power Query and update features and information