St. Louis SQL Server User Group

Welcome to the St. Louis SQL Server User Group (STLSSUG)   

Join Our Group Online!
http://groups.yahoo.com/group/stlssug

PASS Summit 2019 Seattle, WA November 6-8
Use code LGDIS7RW6 to receive a $150 discount off your PASS Summit 2019 registration

 

EventDisplay

Next Meeting

Tuesday,

July

10

STLSSUG & BI July 10, 2018 - Using Power Query M to Scrape The Web

  • In-Person @ 3 City Place Drive, 11th Floor, Room #2 St. Louis, Missouri, United States (map)
  • 18:00 - 19:30 Central Daylight Time
  • Language: English

St. Louis SQL Server & BI User Group Meeting

July 10th 5:45 pm- 7:30 pm

  

Registration

Register online to be included in the lunch count at:

https://www.eventbrite.com/e/using-power-query-m-to-scrape-the-web-with-alex-powers-tickets-47837787109

  

Location:

Daugherty Business Solutions (www.daugherty.com)

3 City Place Drive, 11th Floor

Creve Coeur, MO 63141

  

Sponsor & Host: Daugherty Business Solutions (www.daugherty.com)

  

Agenda
5:45 – 6:00 pm         Registration - Dinner
6:00 – 6:05 pm         Welcome, PASS News
6:05 pm – 7:15 pm   “Using Power Query M to Scrape The Web”, Alex Powers
7:15 pm – 7:30 pm   Evaluations and Raffle Drawing

  

Abstract - Using Power Query M to Scrape The Web

The process of monitoring-exporting-cleansing-importing online information is now a thing of the past using Microsoft's Power Query M formula language (Power BI, Excel). In this presentation you will learn how to leverage the GUI in combination with the Advanced Editor, write your own custom functions, navigate the HTML Document Object Model and manage recursive events using online information. A basic understanding of programming is recommended though not required, internet access is required for those who wish to follow along.

  

About Alex Powers

From financial services to felines, the World Wide Web to wrestling - Alex Powers has an affinity for the conventional and unconventional when it comes to transforming information. A self-proclaimed Excel Enthusiast Alex Powers enjoys contributing to online forums, writing blog posts (http://www.itsnotaboutthecell.com) and sharing his passion for empowering others using Microsoft Excel and Power BI.

  

Join us online

Join Skype Meeting       Trouble Joining? Try Skype Web App

https://meet.lync.com/handicare-com/gary.polinsky/4YMMR6G3

PASSChapterLogo.jpg

sql_micro_sm.gif

sql_ca_sm.gif

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids