Session 1: Introducing Power Query (formerly known as Data Explorer)

Presented by: Tyler Chessman

Running Time: 43 min

Microsoft Power Query is a new self-service business intelligence (BI) tool that helps users find and prepare data for analysis. Available as an add-in for both Excel 2013 and Excel 2010, Power Query makes it easier to discover, combine, and refine both public and private data sources. In this session, we will look at how Power Query connects to traditional data sources – and how it brings Internet search capabilities into the realm of BI. We’ll then review the data refinement capabilities of Power Query, including its query formula language.