Monday, November 7, 2011

SQL Saturday #86 BI Edition Recap

Unleash The Tablix Tour

While I was on the plane flight home to Sacramento from SQL Saturday #86 BI Edition in Tampa FL, I thought I'd write about some highlights for me about this awesome event that Jose Chinchilla (Twitter | Blog) and an amazing team from the Tampa Bay BI User Group successfully organized. It was a rough trip getting there, but so worth it in the end. Many speakers that came are the "who's who" in the Microsoft BI world. It felt amazing to be among so many talented folks: Adam Jorgensen, Mark Tabladillo, Rob Collie, Melissa Coates, Joe Celko, Dustin Ryan, Jen Underwood, Sanjay Joshi, Andy Warren and many new faces. Everyone in attendance was great and very nice indeed. One attendee whom I met during lunch gave me the 2nd most important line I've ever heard in my life: "Don't wait too long." We were talking about family trips cross-country in an RV, but in the moment that this gentlemen said this over lunch, I knew we were speaking about life in general.
Bay Area BI User Group - Unleash the Tablix

The trip to Tampa was a little hectic, but ended up being totally worth it. It started after presenting Unleash the Tablix to the Bay Area BI User Group Thursday night which went great. Fifty people attended and with the help of Mark Ginnebaugh (Twitter|Blog) and Will Brown, we were able to deliver the meeting after a last-minute room switch.

After the presentation, I hopped on a BART train to SFO airport to catch a red-eye to Ft Lauderdale. I underestimated the time it took to get to SFO on BART, and ended up running to the gate while hearing them call my name on the loudspeaker. Once that flight landed in Ft Lauderdale at 6:30AM, I had 45 minutes to get from Terminal 1 to Terminal 2 to switch airlines and catch my flight to Tampa. It was muggy and warm, but I made it with some time to spare. Folks in Florida had warned me about the humidity, and it wasn't even summer anymore. Phew! I made it to Tampa at 7:30 AM, but had to wait for a shuttle to take me to the rental car company which put me at the pre-con with Adam Jorgensen at 8:45 AM. Amidst running in the humid morning in Ft. Lauderdale... running to my gate at SFO... battling with BART ticket machines, and hearing my name on loudspeaker, I had made it. Victory at last.

The pre-con was packed, and Pragmatic Works delivered as promised. Adam Jorgensen, SSAS Maestro and Vice President of PW, delivered the goods. The BI Bootcamp covered everything related to Analysis Services that you need to know to set it up, tune it, reporting clients, and even more interesting, PowerPivot. I jotted down a great reference for MDX called "MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook" and heard about a great Excel utility called the OLAP PivotTable Extension which exposes the resulting MDX from constructing PivotTables in Excel. I've been writing MDX for a year now, but hearing what an SSAS Maestro considers the "greatest MDX book" and "useful utilties" sort of makes you want to go out and buy it or download the stuff right away. The PowerPivot material was also just a pre-cursor to what was to become the highlight of my trip here in Tampa.

After the pre-con, we got together for the speaker dinner at the Tampa Bay Brewing Company in Ybor City. Good food and great company kept me going even though I was feeling tired from lack of sleep and the time difference on the east coast. I soon got my second wind as I caught up with my friends at Pragmatic Works and met a few new people over dinner like Rob Collie, Melissa Coates, and Mark Tabladillo. I called it a night at about 10PM as I was one of the fortunate ones to be first to speak the next day at 8AM.

The following morning, I presented "Unleash the Tablix" to a good size audience at KForce training facility at 8AM. After a couple cups of Dunkin' Donuts coffee and of course, a donut, I got into my talk in which I describe the differences of Table, Matrix and List plus Visualization tips. The content of my presentation is on another blog post. All in all, there was good interaction with the audience and together we addressed a couple business problems to a very common business process: Purchasing. I was happy with the feedback and look forward to receiving questions and/or comments to any of the content. I also have some additions to make to my blog post, so look out for an update to the post on Twitter.

For the next time slot, I attended a presentation which made a big impact on me personally in my career. I went to Rob Collie's presentation on PowerPivot: BI with massive data. In it, he showed his approach in using PowerPivot. Rob emphasized the fact that he knows no T-SQL, has never written an SSIS package, and has never setup an SSAS cube in BIDS. Yet, with PowerPivot, he was able to perform the same functions using the native tool he's used to using: Excel. I was flabergasted! Rob went on to talk about the powerful DAX expression editor, how to setup multiple column keys in the data model, and also the top 4 DAX functions he thinks we should all get to know when using PowerPivot: CALCULATE(), ALL(), COUNTROWS(), and DISTINCT(). What was most impressive about Rob's demo was the data: he got his hands on tons of NFL stats for the past few years. With one slicer click and a sort change later, he showed statistical analysis showing how Brett Farve was really really good one year and totally slumped the following year.. AND nobody talked about it! I don't know how true it was, but it sure made for a great demo and grabbed my attention. He did all this with no T-SQL! SSIS! or SSAS! This definitely has me curious about what PowerPivot can do for business users.

Jose Chinchilla thanking sponsors, speakers, and attendees

Another important take away I had was after lunch (which was a fantastic latin meal i can't remember the name of) during the "Ask the Expert" Panel discussion when we were discussing SQL Azure. During a time when we have so many options in licensing models, SQL Server Editions, and hardware platforms, I was eager to hear what the experts had to say about the SQL Azure model and where it fits in. Brian Mitchell said part 1 of the great answer which was if you need a database which connects across many mobile devices, then its a good fit. Another Microsoft engineer there said part 2 of the answer which is when you care more about the design of the database rather than the infrastructure to maintain it, then SQL Azure is the best route to go. Both two really excellent points which in summary are if you meet this criteria, then you're ready for SQL Azure: 1) Mobile 2) Design/Architecture 3)Virtually no maintenance.

The other excellent presentations I caught were:
  1. Reporting on a Cube by Dustin Ryan
  2. Page and Row Compression with Bradley Ball
  3. Dashboards... Which BI Tool to use? by Melissa Coates
  4. BI in the Cloud with Marc Miller
  5. Social Networking with Mark Tabladillo
Every one of these presentations was helpful in raising my level of expertise in the BI stack. Dustin's talk helped me to realize how Date Range parameters To/From can be set in the Query Designer. Brad's talk gave me some DBCC commands and considerations for tables that make good candidates for Page and/or Row compression. Melissa's talk helped me see how flexible SSRS is in terms of visualization and functionality as compared to other Microsoft reporting clients. Marc's talk helped give me a glimpse of what's to come with SQL Azure, Reporting Services Azure, and Windows Azure. Mark Taladillo's talk on Social networking was a lot of fun, and the whole group interacted on topics such as Wordpress blogs, LinkedIn profiles, and Twitter feeds. With these talks, I caught a glimpse of how I can further my career as a BI consultant, speaker, and mentor.

The after party for SQL Saturday #86 was back at the Tampa Bay Brewing Company. Even after the event was finished, I still had plenty of opportunity to grow as I got to talk to Todd Davis and James McAuilliffe from Convergence Consulting one-on-one about business and the value consultants bring to the marketplace. We shared how hard work pays off and the phenomenal growth in BI in just recent years. We were all very excited about how the event turned out and the possibilities for upcoming BI Edition SQL Saturdays.

Being the only speaker/attendee from California, I received the same comment a lot: "you came all the way out here for this?" To which I would always respond, "Absolutely, why wouldn't I?" I was surprised not to see the venue overflowing from people all around the US, but one thing was for certain, there were lots of top-notch companies looking to hire BI developers. So the real question now is, will you be there at the next one? If its BI Edition, and you're a BI developer in any area of the BI Stack, you should. I really believe that anyone who is a BI professional ought to attend, speak, and come hang out with the incredible talent out at the BI Edition SQL Saturdays. Lots of opportunities to network and get hired. Demand for BI talent is growing at a very healthy pace, and from what I hear, the supply is not meeting that demand. So maybe I'll see you at the next one. Hope so anyway.

Thanks again to the SQL Saturday #86 team for all the hard work they put into it. To the sponsors of the event, thank you also. Without you guys, this event could not be made possible.

Goodbye Tampa! Hope to see you again soon.Downtown Tampa


  1. Angel, thanks for making it to our event across the country. We got great feedback from your session and look forward to have you at our next event.

  2. Nice piece! I have liked this on Facebook. Bye!