Power Query for Excel


Overview


With Power Query, you can:

  • Find and connect data across a wide variety of sources.

  • Merge and shape data sources to match your data analysis requirements or prepare it for further analysis and modeling by tools such as Power Pivot and Power View.

  • Create custom views over data.

  • Use the JSON parser to create data visualizations over Big Data and Azure HD Insight.

  • Perform data cleansing operations.

  • Import data from multiple log files.

  • Pull data into Power Pivot from new data sources, such as XML, and File Folders as refreshable connections.

  • With Power Query 2.10 and later, you can share and manage queries as well as search data within your organization

Samples for using Power Query in humanitarian context