Login  |  Register


You are here :: Home Sunday, February 1, 2015






 Welcome to VanPASS!

If you are new to this site the first thing to know is that membership and attendance to any meeting is absolutely free.  All that we ask is that you RSVP for any meeting so we can get enough pizza for everyone.   Also, to recieve any of the newsletters and updates on meetings please register starting at the top right-hand corner.  Any questions can be address to me, Richard Baumet, at rbaumet@shaw.ca .  Thanks for dropping by!

 Vancouver IT Community


Vancouver BI 
PASS Chapter


 Vancouver Chapter of The Data Warehouse Institute                

 Vancouver SharePoint User Group                              


.NET User Group of British Columbia, Canada - netbc.ca                        

Canadian Information Processing Society, Vancovuer Chapter - vancouver.cips.ca                          

PMI, Canadian West Coast Chapter - pmi.bc.ca                                           

 Vancouver BC Chapter of the IIBA - vancouver.theiiba.org


Data Mashups Recipes using Power Query 

Presentation Abstract

Potatoes, cream and butter not required!

Power Query has been around for a little while now, but I can’t say that it has been selling like hot cakes, well… because it is FREE!   Not many people know that you can have your cake and eat it too – Data can come from various sources and you can bring it together and reshape it in Excel for your analytic needs.  Whether you are grabbing Open Data, Public Data, Social Data, Private Data, or Corporate Data, Power Query is up for the job.

It’s the Holiday Season, and everyone is cooking & baking, so why don’t we cook up some data!  No need to muddle your way through it, Scott will show you the ropes.  We will follow some recipes to get you started with this Swiss Army Knife of Personal, Self-Service ETL Add-in for Excel.

Of course Power Query is just one piece of the new Microsoft Power BI offering, which includes Power Pivot, Power Map, Power BI Q&A, but let’s not bite off more that we can chew!

Power Query leverages a powerful functional language called “M”, and it is available for Excel 2010 & 2013 in both 32 and 64 bit version.  And it is FREE…  What a great present.  But wait, there’s more.  The Power Query Team a Microsoft cranks out a new features every 4 week!  I know, right! 

Come chew the fat with us on Wednesday December 17th at our usual haunt.  Come see what some have called the best designed tools that Microsoft has ever made – Power Query

We will be heading over to Cactus Club afterwards for those interested in some “Holiday Cheer”***Cover your own bill**** 

Pizza at the event sponsored by SoftLanding


Scott Stauffer

Scott is an independent consultant working out of the Metro Vancouver Area assisting clients with data systems solutions to their business challenges. He has worked in IT for over 15 years, and although Scott has managed systems with early version SQL Server on OS/2, he really started digging deep into SQL Server with the release of SQL Server 6.5. With a keen interest in continuous learning, sharing knowledge, and building community, Scott founded the Vancouver PASS Chapter (http://Vancouver.SQLPASS.org) back in September 2004. Although he has taken the step into the .NET paradigm with an Intro to VB.NET & C# courses, Scott really feels most at home in the world of SQL Server.

Wednesday, 2014/12/17, 5:30pm-7pm  (Cactus Club after)
  • Meeting Room - 550 Burrard St, Vancouver, BC V6C







Home | Meetings | Resources
Privacy Statement  |  Terms Of Use
Copyright 2008 by Vancouver PASS Chapter