Microsoft Power Query

Data Integration

Includes integration of data from multiple sources, merging systems, transforming data and capture data to form a unified view of a company's data assets

Data Connectors and Data Mashup

Connect to, merge and clean data from multiple diverse data sources.

Data Access

Ability to access data from various sources on-prem and in the cloud and of various type: structured, unstructured, and semi-structured, real-time, etc.

Data Pre-Processing

Ability to wrangle or pre-process data to ready it for model training.

Data Enrichment

Includes the enhancement of the value of internally held data by appending related attributes from external sources .

Data Profiling

Includes statistical analysis of data values to evaluate the frequency, distribution and completeness of data.

Cataloging

Interactive graphical exploratory data analysis through immersive interfaces.

Data Cleansing

Includes data auditing, workflow specification, post-processing, and controlling. such as address standardization and the correction of known invalid values.

Data Packaging

Creating technology-specific data repository design optimized for a consumption use case, e.g.: time-series database, muti-dimensional cube, graph database, etc

Data Modelling Tools

Includes ability to model complex relationships between internal application sources and other parties.

Ease of Data Integration

Use this data to determine whether the product will cause headaches or make data integration easy.

Ease of Implementation

Successfully implementing new software is necessary to realize its full value and promote end user adoption. This data indicates whether or not the product is easy to implement.

Business Value Created

Software needs to create value for employees, customers, partners, and, ultimately, shareholders. This data expresses user satisfaction - or lack thereof - with the product's business value.

Ease of IT Administration

This data indicates whether IT personnel will be able to resolve issues and perform configurations efficiently and effectively.

Quality of Features

Feature quality is just as important as quantity. Use this data to determine if this product will do what you're purchasing it to do, easily, intuitively, reliably, and effectively.

Availability and Quality of Training

Effective and readily available training enables users to get the most out of the software you've chosen. Use this section to make sure your vendor's training programs and materials measure up.

Usability and Intuitiveness

End user learning curves cost the organization money. Pay attention to your end users' technical ability to determine how important UX is in your purchase.

Product Strategy and Rate of Improvement

Vendors who don't stay on top of emerging needs and trends won't enable you to meet your business goals. Use this data to separate innovators from imposters.

Breadth of Features

Users prefer feature rich software that enables them to perform diverse series of tasks. This data expresses user satisfaction with the product's breadth of features.

Ease of Customization

Don't get bogged down in a difficult customization; use this data to make sure you can easily achieve the functionality you need for your particular situation.

Vendor Support

The importance of vendor support will vary for each organization depending on internal capabilities, but there will always be issues that only the vendor can resolve.