Monthly Archives: August 2017

Another 7 Things to Consider for #SQLSaturdayVancouver

Yesterday I sent a message entitled Six things to consider for #SQLSaturdayVancouver which I re-posted on my blog in case you couldn’t find it in your email…

But, here are 7 MORE things to consider!

  1. Sign up for “Power BI: Dashboard in an Hour!”
    1. Register on the Eventbrite site to reserve a seat –

https://www.eventbrite.com/e/power-bi-dashboard-in-an-hour-presented-by-sophie-marchand-tickets-37301476721

  1. Bring your notebook
  2. Install Power BI Desktop

 

  1. Cellular Signal / Roaming / WiFi

WiFi at the venue is LEGENDARY!  Really, it is excellent.  Please don’t be a bandwidth hog though…  watch you Power BI YouTube videos at home or at the office. 😉

 

  1. Getting To #SQLSaturdayVancouverhttp://robsonsquare.ubc.ca/find-us/
    1. Additional info on Parking impark lot (0110)  $6.00 for the day  (6AM – 6 PM)  –
      1. Parkopedia: https://www.parkopedia.mobi/parking/underground/robson_square_lot_110/v6z/vancouver/?arriving=201708230030&leaving=201708230230
      2. Impark site: https://lots.impark.com/imp#details=1,110
  • You can pay with cash by credit card or with the PayByPhone Mobile App
  1. You need to know your license plate when you park, not a stall, so nothing needs to go back on your dash
  2. Take elevator to lower Classroom level

 

  1. Floor Map for SQLSat at UBC Robson Square  http://scottstaufferdotca.azurewebsites.net/wp-content/uploads/2017/08/UBC-Robson-Square-SQLSat-Setup.png

 

  1. Bring a water bottle – there are watercoolers in most rooms – hydrate people!

 

  1. Bring a friend – Learning is more fun when you can share the experience with a friend or coworkers.  Get them to register too!  –  http://www.sqlsaturday.com/635/RegisterNow.aspx

 

  1. There are plenty of Prizes – Make sure you visit the Sponsor booth and insert your SpeedPASS raffle tickets in the box.  You have to be there during the draw at the end of the day to win!

Want Lunch for SQLSaturdayVancouver?

I sent the following earlier this week:

Buy the Lunch – Invest in the lunch to feed your body while we feed your mind!
There will be conferences in town and 4 cruise ships – street food vendors will have line-ups and you will miss out.

  1. We have Lunch time vendor sessions!  AWS, Microsoft & CozyRoc
     – You don’t want to be out looking for something to eat and miss these sessions! 
  2. PayPal $15 – easy
  3. Boxed lunches include a Sandwich, Salad, Cookie and Drink
  4. We will send out a link to purchase if you initially chose not to purchase the lunch, but you changed your mind and would like to do so.

 

Soooo… In order to buy lunch, you will need to:

    1. Click this link – https://www.pass.org/MYPASS.aspx?viewctl=MySQLSaturday
    2. Log in
    3. Under Event Registration; Show Upcoming Events; SQL Saturday #635 – Vancouver 2017
    4. There will be a button at the bottom to “Pay Lunch Fee”
    5. You will be re-directed to PayPal to finish the transaction

 

Six things to consider for #SQLSaturdayVancouver

Six things to consider for #SQLSaturdayVancouver

  1. Register for the All-day Friday Power BI Pre-con
    1. Discount Offer – Save 10% with discount code! (Saturday is Free, Friday is paid) http://scottstaufferdotca.azurewebsites.net/2017/08/14/master-your-data-for-power-bi-sqlsaturday-vancouver-pre-con-session/
    2. Further Details https://www.excelguru.ca/content.php?303-Master-Your-Data-Power-BI
    3. Register (make sure you use discount code SQLSAT) –  https://www.e-junkie.com/ecom/gb.php?c=cart&ejc=2&cl=160142&i=1545452
  2. Buy the Lunch – Invest in the lunch to feed your body while we feed your mind!
    There will be conferences in town and 4 cruise ships – street food vendors will have line-ups and you will miss out.

    1. We have Lunch time vendor sessions!  AWS, Microsoft & CozyRoc
       – You don’t want to be out looking for something to eat and miss these sessions! 
    2. PayPal $15 – easy
    3. Boxed lunches include Sandwich, Salad, Cookie and Drink
    4. We will send out a link to purchase if you initially chose not to purchase the lunch, but you changed your mind and would like to do so.
  3. Bring your SpeedPASS – This makes Registration a breeze! 
    We email you a link to a PDF file which contains a registration ticket, lunch ticket, raffle tickets and name badge for you badge and lanyard we provide to you at registration

    1. Download it, Print it out, cut it up, bring it along;
    2. “Scissors of Shame Table” is available if you’ve printed it but didn’t get around to cutting
    3. $2 donations to BC Children’s Hospital for having your SpeedPASS printed by us!
       – fee is optional, but MUCH appreciated.
    4. Link to your personal SpeedPASS will be mailed shortly
  4. Sign-up to Volunteer
    Give back to the community volunteer a little bit of time – Earn Karma Points!

  5. Plan your day; Build your schedule – on the day, check back for last minute changes.
    You can plan your day so that you won’t be racing around on the day!

  6. Download the PASS Events Mobile app (for IOS and Android; by Guidebook)
    You can see the schedule and plan which sessions to attend, display abstracts and speaker bios and more!

Master Your Data for Power BI – SQLSaturday Vancouver Pre-Con Session

One of the local Sponsors to SQLSaturday #635 – Vancouver, BC is Excelguru.

Ken, founder of Excelguru, will be delivering a “Pre-Conference” session on Power BI!  Here are some of the details, and a link to further details and a registration page.

Friday, August 25, 2017

The sad reality is that not all data we need for our reports is stored in nicely curated databases. While some of the data may be, the reality is that we also need to piece together data provided in text files, Excel files, web pages and even the body of emails in order to build the complete business intelligence solutions we need. Until now this has been a painful process with a great deal of cutting and pasting into Excel files. Updates have been tedious and error prone, if the solution isn’t abandoned outright. That stops today.

This course is about Data. It’s about getting, transforming, cleaning and reshaping your data. It’s about turning awkward data into shiny golden tables that are perfect for analysis.

You’ll learn how Power BI can clean up, reshape and combine your data with ease – no matter where it comes from. And the best part? While we’ll be focusing on these techniques in Power BI desktop, they are also 100% portable to Excel 2010 or higher via the Power Query add-in.

In this hands-on workshop, Ken will cover:

  • A quick review of Power BI report basis
  • Importing basic data
  • Appending and merging tables
  • Pivoting, un-pivoting, and transposing data
  • Conditional logic, and
  • Other techniques such as structuring and grouping queries, and understanding query folding and the formula firewall

Register Today and Save:

As an exclusive offer for the SQL Saturday Vancouver mailing list, register before 6:00pm on Friday, August 18, 2017 and save 10% on the registration price! Simply enter discount code SQLSAT at check-out to redeem this offer.

Full course details and registration at http://xlguru.ca/datamaster.