Microsoft Reviews, Ratings & Features 2026 | Gartner Peer Insights

Data preparation is an iterative and agile process for finding, combining, cleaning, transforming and sharing curated datasets for various data and analytics use cases including analytics/business intelligence (BI), data science/machine learning (ML) and self-service data integration.

Data preparation tools promise faster time to delivery of integrated and curated data by allowing business users including analysts, citizen integrators, data engineers and citizen data scientists to integrate internal and external datasets for their use cases. Furthermore, they allow users to identify anomalies and patterns and improve and review the data quality of their findings in a repeatable fashion. Some tools embed ML algorithms that augment and, in some cases, completely automate certain repeatable and mundane data preparation tasks. Reduced time to delivery of data and insight is at the heart of this market.

Active

Find the top Data Preparation Tools with Gartner. Compare and filter by verified product reviews and choose the software that’s right for your organization.

Data Preparation Tools

Microsoft Power BI

Microsoft Power Query

Microsoft Purview Audit

Microsoft

REMOTE MANAGED SERVICES SENIOR DIRECTOR

Tool is very nice if you are starting with data, intuitive at starting level and has everything you need in one place

50M - 250M USD

1B - 3B USD

500M - 1B USD

250M - 500M USD

3B - 10B USD

<50M USD

30B + USD

10B - 30B USD

Gov't/PS/ED <5,000 Employees

Gov't/PS/ED 5,000 - 50,000 Employees

Business Analyst

This is in my opinion very basic software for data analysys. One of it's biggest strenghts is community support, but software itself lacks in efficiency, especially with big data sets. 

Vice President

Microsoft Power BI is a great tool for data visualisation, as a matter of fact, it is one of the best available too

Salesforce (Tableau)

Qlik

Google

Alteryx

Salesforce (Informatica)

Strategy

Other...

Oracle

Datameer

Alteryx (ClearStory Data)

Siemens (Altair)

Amazon Web Services (AWS)

Qlik (Talend)

TIBCO

Hitachi Vantara

DataRobot

Minitab

Quest

EasyMorph

Zoho

Trifacta

Trinity Life Sciences

Cambridge Semantics

Unifi

Booz Allen Hamilton

Zaloni

Microsoft enables digital transformation for the era of an intelligent cloud and an intelligent edge. Its mission is to empower every person and every organization on the planet to achieve more. Microsoft is dedicated to advancing human and organizational achievement.

Microsoft Security helps protect people and data against cyberthreats to give peace of mind.


Every company has a mission. What's ours? To empower every person and every organization to achieve more. We believe technology can and should be a force for good and that meaningful innovation contributes to a brighter world in the future and today. Our culture doesn’t just encourage curiosity; it embraces it. Each day we make progress together by showing up as our authentic selves. We show up with a learn-it-all mentality. We show up cheering on others, knowing their success doesn't diminish our own. We show up every day open to learning our own biases, changing our behavior, and inviting in differences. When we show up, we achieve more together. 

Microsoft operates in 190 countries and is made up of more than 220,000 passionate employees worldwide.

Reviews

Ratings Overview

Overall experience with

Favorable Review

Power BI Simplifies Data Visualization But Faces Challenges With Large Data Sets

Critical Review

Summary of up and downsides of Power BI as Data Prep tool

Likes and dislikes about

likes

dislikes