Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 26 Next »

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

A step by step manual on how to use Power Query in excel and apply it in humanitarian context can be downloaded here.

Samples for using Power Query in humanitarian context


  • No labels