Search SSWUG.ORG:

LEARNING EVENTS AND COURSES

David Dye 
9/17/2014
Introduction to Power Query
By David Dye
(Show Details)  

       

Wednesday, September 17th, 2014, 1:00 PM Eastern


Webcast Overview
 

For years, Microsoft Excel has been the primary tool for report writers and business analyst providing a means to collect, analyze, and present data. In 2010 Microsoft released Power Query (originally called Data Explorer), a free add on to Excel. You can use Power Query to extend Excel's capabilities by providing a way to extract data from a number of different sources and present them natively in Excel or used as a data model. Power Query is now part of the Microsoft Power BI (Business Intelligence) tools to help deliver self-service business intelligence from within Excel and Microsoft SharePoint. This learning event focuses on Power Query and its ability to import data from numerous different sources such as Facebook, web services, and databases and provides information on how you can present the data within Excel and Microsoft Power Pivot.

Learning Objectives:

Each attendee will leave with the knowledge and toolset necessary to:

  1. Connect to different data source including:
    • Web services
    • Facebook
    • SQL
  2. Import data into Excel or a data model
  3. Transform data using Power Query
  4. Use the imported data in a Power Pivot project

SSWUG hosts many free events. Check out our upcoming free events.

Need more information about this webcast’s topic? Head over to our 
learning page and search for more! Don’t miss our full-length online courses, too!

Webcast Structure and Cost

Upon registration, you will receive an email with instructions on how to test your system in order to view the webcast, as well as a link that will remain active for the seven-day, on-demand period.

The webcast is completely free. The cost of the DVD with registration or purchase of the webcast is an additional $20.00.

To save on future virtual content from SSWUG.ORG, you can become an annual member for $55.00. Memberships can be purchased on the webcast registration page.