Monthly Archives: February 2015

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

 

Day 1 of Dimensional Modeling in Depth and Loving it!

Wow! The end of an amazing Day #1 – Dimensional Modeling in Depth.

I frequently espouse the benefits of benefits of following the Kimball approach to clients. Sometimes they listen and send their people to the Kimball University Training, and sometimes they simply buy them the book and say, “Make it so, Number One!” [Think Captain Picard from Star Trek the Next Generation]. Now was the time to put my money where my mouth was. If I believe in it, I need to drink my own Kool-Aid. Ya know, it’s kinda tasty! Apparently, with the number of the people in the room, others like the taste too… 72 attendees! WHAT? Yes, and 44 are from the state of Texas – there are also other from Canada too. Overall, I was a little shocked, but delighted to see the room and all the people.

They course isn’t simply a re-hash of the book, there are different conversations, and with 72 people, we get a lot of great questions. I wouldn’t necessarily ask some of them, but I’ve been intrigued by some of the answers and conversation that comes from them the comments and questions.

Margy is a Rock Star. Truly. She downplays here role saying that people are waiting to see and hear Ralph speak, but honestly, I’m getting more than my money’s worth from Margy. It’s just so damn sad that they are retiring. We have to entrap all of them and keep them out of retirement. Really, we can make it happen… Okay, I’m just getting tired and punchy… time to hit the hay so that I’m refreshed for Day 2.

Oh, and I almost forgot – I will also be attending the North Texas SQL Server User Group on Thursday, because, “Hey, it’s in the same building!” – How cool is that.  Who will I be seeing present?  None other than the infamous Mindy Curnutt!  She will be speaking on “Tracing and Extended Events – 3 Methods to end the Madness” – It’s like I won the lottery TWICE in one week!

P.S. – The POST process failed last night in WordPress and fell off the Rocker… Luckily, I saved it in Word and could re-post today!

Kimball University Training all this week!

kg-dw-toolkit-new-202x250I have always been a fan of the Kimball Books for providing a playbook for how to do Data Warehousing and Business Intelligence (DW/BI), and I have always had an excuse for not biting the bullet and taking the course.  Now, my time is running out.  The team is retiring, as stated here.  I am taking the Dimensional Modeling in Depth this week, and then I am thinking Seattle in August might be a good time for the Lifecycle in Depth.  Of course I have all of their publication in both traditional paperback and e-book formats for a lighter backpack, but, I am hoping to fill in some of my blind spots and get some insight that you can only get when spending quality time with the industry leaders.  I am hoping the stories and conversations with the attendees will alsoKimball-Group-Logo be enlightening and I can gain insights that I may not get in other forums.

Here in Irving, Texas, a hop, skip and a jump from the Dallas Fort-Worth (DFW) Airport, I will be taking part in the class in the Microsoft Training Center (MTC).  I chose the NYLO Dallas/Las Colinas Hotel as it can see the MTC from the front door of the hotel.  No cab, not rental car, no hassle!  The hotel has also received good ratings on the travels sights, and it is a incredibly reasonable rate for what you get.

So, my goal… one post a night capturing the moments as I reflect upon each day of training.

But wait there is more… I have so many other things to talk about, you may just be subjected to a few other posts this week, as I struggle to get some exciting news out the door on events in the Vancouver area in relation to IT and Data focused events in particular.

Until we next cross paths,

Scott