Getting Started with Power Query - Part I

Getting Started with Power Query - Part I

Rate This
  • Comments 4

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. Files
    2. Data Bases
    3. Web
  4. 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
  5. Combine data from different sources and files
To start this tutorial you'll need:

 

 

 

Leave a Comment
  • Please add 8 and 3 and type the answer here:
  • Post
  • very good demo.

  • Excellent...I suppose none of this works with Excell 2010.  I really want to use some BI against the SCOM DB's.

  • Check out this blog: Analyzing Facebook Data using Power BI

    ashishrj.blogspot.in/.../analyzing-facebook-data-using-power-bi.html

  • thank you

Page 1 of 1 (4 items)