Here it is!
Here it is!
This is just an assortment of learning resources for Power BI and associated technologies that I have found helpful.
Along with his YouTube Channel, they leverage Social Media to announce their new videos and, of course, have a fantastic website to complete the circle. https://GuyInACube.com
There are more to come, so check back here!
There are paid resources that provide a more holistic perspective, and potentially help you to focus on putting other things aside while you focus on your learning… because, Hey… You paid for it!
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!
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. 😉
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.
Soooo… In order to buy lunch, you will need to:
Six things to consider for #SQLSaturdayVancouver
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:
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.
This Summer, Vancouver data professionals welcome the 5th iteration of the global phenomenon that is SQLSaturday!
what? SQLSaturday #635 – Vancouver 2017
where? UBC Robson Square Downtown Campus – Vancouver, BC
when? Saturday, August 26th, 2017 (All day! – Schedule coming soon)
who? 500 attendees (it’s our goal!) – professionals who work with data
why? For the love of data!
how much? it’s FREE! – Purchase of a boxed lunch is optional ($15) after registration is complete, you will be directed to PayPal to purchase the lunch, if you want it.
Our goal this year is to break the 500 attendee ceiling. How do we do that? We open up more tracks and invite other technical communities to talk on data focused topics. The Azure community will have a track to talk on the current offerings that the Microsoft cloud offers in way of Data Platform capabilities. The Office 365 / SharePoint Community will also be invited to submit sessions on unique offering in the data space that their community can share. With MySQL and PostgreSQL now being offered in Azure, we may still see more presentations from OpenSource communities. In addition to “R” the statistical analysis language that is a key language of the Data Scientist community, we can also expect to see presentations on Python as both “R” and Python now able to be called from T-SQL Stored Procedures.
Vancouver was the first SQLSaturday outside the USA back in 2011 with SQLSaturday #65. It was an event held the weekend before the Microsoft MVP Summit in Bellevue Washington, so the event was infused with speakers from around the Globe. The event took place at a swanky hotel in the heart of downtown Vancouver. The event was a smashing success. Michael Lato was the main organizer, but Rich Baumet and I did a lot to make the event successful as Michael was on the other side of the country.
Vancouver’s 2nd SQLSaturday (#114) found a new suburban home in BCIT’s Burnaby’s Campus. A more modest sized budget and with fewer attendees, the event was once again orchestrated by Michael Lato, and I popped by the day before the event to help out with the onsite event execution. Not being on the
There are a number of exceptional events taking place close to home (Vancouver, BC, Canada) over the next few weeks… here are just 5 Data-centric events to excite the senses!
September 28th (Wednesday Evening!)
Vancouver BI PASS Chapter presents (Free event):
by Sepand Gojgini, Lead Business Intelligent Developer DATATEAM services
Having a robust data warehouse and analytical platform is a great competitive advantage, however, many organizations lack one due to complexity and cost associated with developing and maintaining one. In this session, we will share a, proven, new data warehousing approach that can help you take advantage of advancements in Microsoft SQL Server.
October 13th (Yup another Thursday Evening!)
Vancouver Power BI User Group Meeting & Vancouver BI PASS Chapter presents (Free event):
by Scott Stauffer, Independent Data Consultant
“How do I take my Power BI Solution and pass it over the wall to IT to manage? … How do we take what we’ve developed and make it more “-able”? … Come join us as we look at some solutions that we think might help transition your desktop solution to the enterprise.
for FULL details http://vancouverbi.sqlpass.org/Home.aspx?EventID=5948
Meetup Page: http://www.meetup.com/Vancouver-Power-BI-User-Group/events/234126999/
to RSVP: https://www.eventbrite.com/e/operationalize-power-bi-tickets-27937072536
October 25 – 28th (Starts on the 24th if you want to take in the preconference sessions)
4,000 of my closest friends get together each year to Connect, Share & Learn!
2 days of half and full day preconference sessions & 3 days of general sessions
Save $150 with the Chapter Discount Code: LC15CJQ9
October 31st – November 2nd (Monday – Wednesday)
This 3-day workshop put on by Niko Neugebauer (Data Platform MVP), of OH2data, will be just what your boss ordered to help improve your database performance!
Discover the two of the most important & revolutionary technologies for Data Warehousing, Operational Analytics and OLTP – the Columnstore Index and In-Memory Tables!
– Niko’s Columnstore blog series includes over 90 posts over the last 3 years!
Save $200 with the Chapter Discount Code: VANCANSQL16
Full details & to register: https://oh22workshop.eventbrite.com/
November 4th (Friday Afternoon)
This Free event is hosted by the DevTeach Community & Microsoft – Pizza & 4 technical SQL sessions by Rich, Scott, Florian and Jean-René on a Friday afternoon
for FULL details: http://www.devteach.com/Community/
to register: http://www.devteach.com/wconnect/wc.dll?FournierTransformation~1,26,1,46
Well, on June 1st, Microsoft delivered a new version of its “Enterprise Class” Database, SQL Server. Why should you upgrade? There are so many reasons that I can think of, but likely you’ll be interested because…
SQL Server Developer’s Edition is now FREE! … so why not take it for a spin…
Need resources to get you started… Yup, we can help there too…
tl;dr? – Make your way to the end to link to the resources 😉
Our sponsors threw some cash our way to feed the attendees with some snacks, coffee and boxed lunches. The Swim Team was helping out with registration and talking to you about career opportunities in the Vancouver area. PASS dropped off a load of DVDs “Top 10 Sessions of PASS Summit 2015.” These recorded sessions give you an idea of what you simply DO NOT want to miss out on… Are you sold on the PASS Summit? Go to Vancouver BI Chapter site and grab the discount code to save $150 on registration for the PASS Summit 2016 coming to Seattle in the fall.
Microsoft was at the SQL 2016 Community Launch Event too, represented by Andrew Boudreau. Andrew played double duty delivering 2 sessions – You Rock, Andrew! Andrew started the show off sharing the pieces of SQL Server that he is PASSionate about – Azure Data Warehouse and Polybase to name two. I followed up with “Visualization & Reporting Options on the Microsoft Data Platform” talking about what’s new with SSRS and a few things on Power BI too… Andrew, graciously agreed to fill the lunch slot and filled in the gaps that I left out on Power BI, in addition to launching into some Power BI demos to delight the audience.
After Lunch, Rich Baumet jumped into DBA enhancements and new features. [On a side note Rich is once again doing the Ride to Conquer Cancer. Why not make an investment in a Cancer free future… Click here to help him meet his fundraising goal!]
After Rich, Todd McDermid jumped into share some In-Memory topics, along with some T-SQL features, Always Encrypted, and even a few SSIS pieces, because we asked him to…
A great day was had by all… It is tough to know exactly how many people showed, as some people only came for half a day and others didn’t register, they just slid in, but best estimates based on check-in is 125 – 130 attendees. Not bad for a community driven event. For the next SQL Launch, though… Microsoft Canada needs to step it up and have a bigger Launch event here in Vancouver.
Todd’s slide decks and demo files are available here:
My slide decks, in addition to Andrews, can be found here:
Here is a fancy poster to print out and hang in your office!