Data Mashups Recipes using Power Query

Potatoes, cream and butter not required!

Tomorrow evening I will be delivering a presentation to the Vancouver PASS Chapter the Vancouver BI PASS Chapter and invitations have gone out to various other local UGs as I will be covering a few different areas.

Power Query is a pretty slick tool and I will add details here, but they will also be in the Slide Deck that I will include later in this post at a link to my SlideShare account.

This page will have some links to other important places that you might want to explore, such as OpenDataBC.  OpenDataBC has a MeetUp group that just ramped up in November for Vancouver.  It’s sister Meetup in Victoria has been meeting for quite a while, but when one of the key organizers moved to Vancouver for a new role, she decided to make things happen here too.  Thanks for the hard work Gillian!

Looking to learn more about the recent updates?  Check out the PowerBI MSDN blog, and see post like this:

http://blogs.msdn.com/b/powerbi/archive/2014/11/25/5-new-updates-in-power-query.aspx

I LOVE how Miguel Llopis does a detailed blog post with screen shots, but also takes the time to also showcase each new feature to the realease in a short screencast – Microsoft, take note, people DO like this – Please encourages this… give that man a raise!

Looking to Download the Power Query Add-in… Likely the best place to go for the December update is:

http://www.microsoft.com/en-ca/download/details.aspx?id=39379

Power Query release cadence – monthly sprints!  I LOVE it – something new to touch EVERY MONTH…

What will I be doing in the session?

  1. Showing you how to get the tools
  2. Showing you around the tool
  3. Doing some fun stuff with public data
  4. Scraping data from websites
  5. Creating a Do… WHILE construct to iterate over a website.

Afterwards, BELLINIS!  The Cactus Club is just around the corner from our Venue, so why wouldn’t we

 

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.