Getting Started with Power Query - Part I

[Guest Server Tech]

Welcome the Excel and Power BI getting started series.

 

Today we're starting with the first step of the data analysis process: Discover and Get Data.

 

Power Query allows you to easily discover and connect to data from public and corporate data sources. This includes new data search capabilities to facilitate discovery, as well as capabilities to easily transform and merge data from multiple data sources, so you can analyze the data in Excel.

 

In the following video you'll learn how to:

 

1. Perform an Online Search, import public data results, and visualize these results in 3 easy steps with Excel
   
2. Apply some easy transformations to your newly gathered data with the Power Query editor
   
3. Connect to external Data Sources
   
   1. 
      
   2. Files
      
   3. Data Bases
      
   4. Web
      

[*]Perform more complex data transformations such as changing the data type, deleting columns and adding calculated fields while saving your steps on the Query editor

[*]Combine data from different sources and files

To start this tutorial you'll need:

1. Excel 2013
   
2. Download and Install the Power Query add-in
   

 

 

 

 

 

• Try Power BI
  
• See Power BI in action
  
• Follow @MicrosoftBI on Twitter
  

 

 

 

Continue reading...