Power Query can connect to a wide range of data sources. Databases such as SQL Server, Oracle, Text files, Big data and Hadoop data sources, online searches and OData feeds, Cloud storage, Facebook, SharePoint and many other types of data storage. Power Query extracts the data from sources and does transformations such as splitting columns, data conversions, lookups, merge, append, data cleansing and many other data transformations AUTOMATICALLY without the use of VBA. Power Query introduced a new expression language called “M” for data transformations. Power Query is simply the best transformation and data manipulation tool for Excel and easier to use, understand and master than other tools.
- Import / connect to external data from multiple sources.
- Automate the data transformation & data cleansing processes.
- Combine data from multiple sources into a single source.
- Merging data without the need of formulas such as VLOOKUP, INDEX & MATCH.
- Perform calculation to aggregate
Excel Power Users, data analysts, business analysts, managers, MIS
professionals and BI Consultants / BI Developers