SQL Saturday 86 BI Edition Tampa 2011: Afterthoughts

Wow! Just Wow! That’s all I can say to describe how great SQL Saturday 86 was on November 5th in Tampa, FL . I got so much positive feedback from every attendee, speaker and sponsor. Food was great, sessions were amazing, speakers were first class!  I have to say thanks to everyone for attending, speaking, sponsoring and helping out with these great event put together by the Tampa Bay Business Intelligence User Group officers and volunteers.

Organizing Committee & Volunteers

I cannot take personal credit for this event. It was truly a team effort. Somewhere I read that in order to be successful you need to surround yourself with talented & driven individuals that are committed to your same goals. Maybe I’m paraphrasing or simply making that up, but this has proven to work with running our local Tampa Bay Business Intelligence User Group and the SQL Saturday #86 BI Edition event.

The organizing committee was made up by:

• Jose Chinchilla, President (Twitter | LinkedIn | Blog)
• Andrew Brittain, Vice-President (Twitter | LinkedIn | Blog)
• David Liebman, Treasurer (Twitter | LinkedIn | Blog)
• Sanjeev Jha, Project Manager (Twitter | LinkedIn | Blog)
• Stephen Murphy, Event Coordinator
• Jeff Steffel, Event Coordinator (Twitter | LinkedIn)

The volunteers that participated in our event included:

• Randy Borys
• Gloria Salcedo
• Chris Richardson
• William Sanders
• Pam Shaw
• Richard Pyra
• Wes Helton
• Tom Totten
• Denis Desault
• David Greim
• Lena Pavlyuk
• Lyn Taylor

Speakers

Our speakers were world class speakers to say the least. The speaker roster included Microsoft MVPs, field engineers and evangelists and other professionals that committed their time and paid for their own travel to support our event. We had just a few speakers that cancelled for personal, health or work-related conflicts. We still want to express our appreciation to them for willing to support our event as well. Thankfully, we managed to secure alternate speakers who did a great job even though it was last minute. Thank your SQL Saturday #86 Speakers!

Sponsors

Our sponsors made our event a quality and epic event by sponsoring with cash, items and swag to giveaway. Thanks to them we were able to sponsor great Cuban food from LATAM restaurant, coffee and donuts throughout the day, swag and raffle prizes and provide our speakers with a thank you dinner.

• KForce provided their facilities for our event.
• Convergence Consulting Group (Twitter | Website) did an amazing job with our speaker and event organizers’ shirts.
• Quest Software (Twitter | Website) raffled an iPad and a $100 Amazon gift card.
• Redgate Software (Twitter | Website) offered a great variety of books to give away.
• Pragmatic Works offered a free training voucher for any of their online classes.
• LaSalle Computer Learning School offered a training voucher for any of their in-person SQL Server certification classes.
• Fusion-IO raffled an iPad.
• Idera raffled one their SQL Serve monitoring software suites and gift cards.
• Soaring Eagle, ElSavier and Wrox each provided SQL Server and Business Intelligence books to raffle.

To all our sponsors thank you for supporting our SQL Server and Business Intelligence Community!

Panel of Experts

In this event I decided to put together a panel of experts to discuss several topics relating to SQL Server and Business Intelligence as well as a discussion of what’s new in the upcoming release of SQL Server 2012. The Panel of Experts took place at LATAM restaurant right after lunch. Our panel of experts included:

• Adam Jorgensen, Pragmatic Works (Twitter | LinkedIn | Blog)
• Brian Mitchell, Microsoft (Twitter | LinkedIn | Blog)
• Sanjay Soni, Microsoft (Twitter | LinkedIn| Blog)
• Michael Antonovich, Orange County School District (Twitter | LinkedIn | Blog)
• Mark Tabladillo, SolidQ (Twitter | LinkedIn | Blog)

We invited our sponsors to briefly talk about their products and services and prizes they were giving away during the event. Following our sponsors I decided to recognize Andy Warren, MVP and PASS (Website) Board of Directors, for his contributions to the SQL Server community, SQL Saturday creation and 100 SQL Saturday milestone.

BI BootCamp pre-conference

Along with our free SQL Saturday #86 event we hosted a paid pre-conference titled “BI BootCamp” presented by SQL Server MVP and SSAS Maestro Instructor Adam Jorgensen. We exceeded our goal with 33 attendees paid attendees, all of which gave very positive feedback of Adam’s presentation. I did a star appearance, helping Adam present a section on SSRS Reports using OLAP cubes as a source.

Thanks to Mike Wells for (Twitter | LinkedIn | Blog) for taking pictures throughout the event. You can see more event pictures at:

https://picasaweb.google.com/116314811362928917852/SQLSat86

Advertisement

Todo lo que debes saber sobre SSIS en 1 hora!

Gracias a lo asistentes de mi charla Todo lo que debes saber sobre SSIS en 1 hora! en el evento 24HOP LATAM. La verdad me agrado mucho presentar en espanol. Aun cuando mi primera lengua es espanol, todas las presentaciones tecnicas en el pasado las he realizado en ingles.

Si deseas ver la presentacion PowerPoint puedes bajarla dando click en la imagen a continuacion.

Tambien puedes bajar el proyecto que utilize en mi presentacion dando click en la imagen a continuacion. Nota: Solo podras utilizar la base de datos y proyecto en SQL Server Denali, no servira en SQL Server 2008 o 2005.

Afterthoughts: SQL Saturday #79 South Florida 2011

This past Saturday August 13th I presented two sessions at SQL Saturday #79 hosted by the South Florida SQL Server User Group (SFSSUG) (Webpage | LinkedIn| Twitter). The first presentation was at 11:00am titled “So, What is BI Semantic Model and why should you care?” and the second one was at 3:00pm titled “Designing  and Optimizing Analysis Services Hierarchies.” I had an amazing time chatting with some old friends that made it to South Florida all the way from Charlotte, NC, Atlanta, GA and  several other Florida cities like Jacksonville, Pensacola, Orlando, and Tampa.

The Driving Adventure

It was an adventure to get there as I decided to make the 4-hour drive from Tampa, FL (about 500 miles round-trip) early in the morning. My original plan was to start my drive around 4:30am but due to being jet lagged from my midnight flight the day before, I woke up until I snoozed the alarm for the 3rd time around 6:30am. That gave me a 30 minute window to get there on time for my 11am session.

The Event

The event was well put together by it’s organizers and volunteers. The food was great and included a mix of Mexican goodies. The Nova Southeastern University Carl DeSantis Building was a great venue. I really liked the central atrium where everybody converged in between sessions and was more than ideal for having lunch and event wrap-up. Great choice of venue & food!

The Attendees

One Mountain Dew + a 5-hour energy bottle and a speeding ticket later, I managed to get there with 20 minutes to spare. My first session titled What is BI Semantic Model and why should you care? started on time and was packed. It was literally standing room only. I had a great time with the audience. They were very engaged and asked both technical and philosophical questions. A couple speakers and friends attended such as my “tweep” (tweeter peep) Phillip Rosen (LinkedIn | Twitter) whom I got to know him in person for the first time. Also, the amazing Data Mining expert and newly minted Microsoft MVP Mark Tabladillo, Ph.D. (Blog | LinkedIn | Twitter) with whom I exchanged a couple of good jokes and funny moments during the presentation. The most memorable being the conception of the term “Bingle” which is the abbreviation of Bing and Google.

Sanjay Soni, Microsoft TSP

One of the attendees was Sanjay Soni (LinkedIn), Microsoft’s new Data and BI Platform Technology Solution Professional (TSP) for the Greater Southeast District (Florida). Sanjay introduced himself after the presentation and was very kind to provide very positive feedback for my BISM presentation. We  spent some time chatting about opportunities to co-present and network some more. I’m very excited to assist Sanjay  as much as I can in his new role in Florida. I encourage for you to network with Sanjay as he is a very friendly and approachable guy. You will see him very soon at a user group or event near you!

At the end of my session several other attendees came up to introduce themselves personally. There were so many I almost ran out of business cards. I appreciate when attendees take a moment to chat with me after my sessions and get the opportunity to listen to their feedback and kind words. I feel truly honored to have been able to present to such a great crowd.

So, What is BI Semantic Model and why should you care?

In this presentation, I did an overview of the new Business Intelligence Semantic Model (BISM) and the new “flavor” of the Analysis Services Engine that Microsoft will release with SQL Server Codename Denali. I explained about the new focus on “Personal BI” with the PowerPivot add-in for Excel, “Workgroup BI” with PowerPivot for SharePoint and “Enterprise BI” with Analysis Services UDM and Tabular mode. I showcased the free PowerPivot add-in for Excel 2010 and later demonstrated how easily a PowerPivot workbook can now be turned into an enterprise grade Tabular database using the new Business Intelligence Development Studio in SQL Server Codename Denali and how simple it is to deploy them.

You can download the slides here or by clicking on the picture above.

Designing  and Optimizing Analysis Services Hierarchies

 

On my second presentation Designing and Optimizing Analysis Services Hierarchies I also had a great time interacting with the attendees. The session was designed as an intermediate session but changed it a little bit to more beginner level from the results of my skillset level audience survey. I had great questions and participation from the attendees.

You can download the slides here or by clicking the picture above.

Thanks to everyone who attended my sessions and to the organizers and volunteers that made SQL Saturday #79 a success!

Afterthoughts: SharePoint Saturday Tampa 2011

This past Saturday June 11th, 2011 I had the opportunity to co-present at SharePoint Saturday Tampa thanks to a special invitation by its main organizer Michael Hinckley (Twitter|Blog|LinkedIn). It was a great experience and a very well-organized event. I met several SharePoint professionals I follow on Twitter for the first time and learned more about them and others in the industry that are in a few words, Rockstars!

Speaker Dinner & Event Networking
As a speaker, I was invited to attend the speaker dinner at Donatello Restaurant (website) on Friday evening June 10th.  The place was a great choice as we had the lounge & bar area mostly for ourselves. Food was excellent. At the dinner party I had the opportunity to connect with several friends from the area, some which I had not seen personally for a while such as

Michael Antonovich  (Blog|Twitter|LinekdIn),
Assistant Director of Web Services at Orange County Public Schools

Landon Bass (Blog|LinkedIn),
Systems Engineer III – SharePoint Engineer at Raymond James

Chad Miller (Blog|Twitter|LinkedIn),
Sr Manager Database Administration at Raymond James

I also met some other cool guys like

Chris Schwab’s (Blog|Twitter|LinkedIn),
Sharepoint & PowerShell guru

David McNamee (Blog|Twitter|LinkedIn),
SharePoint Technology Specialist at Microsoft

Michael Oryszak (Blog|Twitter|LinkedIn)
Practice Manager at Intellinet, SharePoint Server MVP, MCITP

Marc D. Anderson (Blog|Twitter|LinkedIn),
Co-Founder and President at Sympraxis Consulting LLC

The Presentation
Michael Hinckley and I co-presented “Extending Business Intelligence Solutions with SharePoint 2010,” in which we did an overview of what SharePoint 2010 has to offer for Business Intelligence. Michael did a great job doing an overview of SharePoint 2010 covering deployment considerations, licensing and edition comparisons. I then proceeded to do quick overview of Business Intelligence, what it is and what it is not. The audience was very engaged and we spent at least 10 minutes discussing the BI self-delivery model and the governance necessary around it to ensure the “single version of the truth.”

Click here or on image above to download the presenation

David McNamee from Microsoft attended the presentation and contributed to the discussion regarding governance and the self-delivery model. He made a statement that resonated a lot with me as an IT professional regarding these politics and battles between IT and the business:

..if IT and the Business don’t talk and collaborate and the business does not consider IT as a strategic partner, then I’m in the wrong organization.

This is very true and agree 100% with David. As a matter of fact, a big reason why I left a past employer was because of these unhealthy politics.

At the end  of the presentation I showcased Excel Services, Performance Point Services and one of the coolest features in SharePoint 2010 Decomposition Trees. We got great feedback and hopefully Michael and I have an opportunity to co-present again at other events. I felt Michael and I had a good synergy co-presenting (even with no rehearsal).

This may be a taste of things to come between the synergy the Tampa Bay Business Intelligence User Group and the Tampa Bay SharePoint User Group.

 The Sessions I attended
I attended just a couple of sessions as I spent most of my time networking with attendees, speakers and sponsors and promoting our own upcoming SQL Saturday #86 BI Edition on November 5th.

While I am not a SharePoint Developer (yet), I really enjoyed Marc D. Anderson’s presentation “Developing in SharePoint’s Middle Tier.” I learned about his awesome SPServices jQuery library publicly available at Codeplex (http://spservices.codeplex.com/) and also about his SharePoint XSL templates also available at Codeplex (http://spxslt.codeplex.com). Through his jQuery library and XSL templates you can easily customize the user experience of SharePoint forms like cascading dropdown menus, selectable textbox word hints, real-time data validation and much more. Really cool stuff.

During lunch time I attended a session / discussion by Kathy Malone (Meetup) and Blain Barton (Blog|LinkedIn) titled “Building Social Media Communities; How SharePoint Fits In.” This was an interesting discussion as it involved one of my favorite topics: Social Media. We discussed Twitter and how it can help startups and technical communities. I added my two cents ($0.02) and explained how great the #sqlhelp hashtag helps a lot of SQL Professionals with immediate answers from experts around the world. We discussed that for SharePoint there is #sphelp available. I was able to walk away with a signed copy of “Office and SharePoint 2010 User’s Guide” authored by my good friend Michael Antonovich. You can buy his book here.

Another great session I attended was presented by Ryan Morgan (Blog|Twitter|LinkedIn) titled “Silverlight Dashboards in SharePoint 2010.” I have not developed anything at all with Silverlight but was interested to learn how complex or easy it was to create custom dashboards in SharePoint 2010 with Silverlight. It turned out it was very simple, or at list Ryan was very effective at simplifying things that even a Silverlight newb like me understood it. I also learned how easy it is to query SharePoint lists using the API’s available using jQuery and LINQ. Very cool stuff.

I look forward to speaking and attending another SharePoint Saturday. There is so much to learn from the experts that speak at this event that I can apply on my line of work which is Business Intelligence. As Michael Hinckley and I have discussed, there is so much overlap between SharePoint 2010, SQL Server and Business Intelligence and the fact that Microsoft is focusing its efforts to make SharePoint the preferred enterprise information management platform, that SQL/BI and SharePoint folks need to engage more and more.

Business Intelligence: Decaffeinated Please!

For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at the risk of failure. For this reason I put together a presentation titled Business Intelligence: Decaffeinated Please!

In this presentation I cover terms and acronyms associated with Business Intelligence and Data Warehousing. I make a differentiation of what Business Intelligence is and what it is not. I also go over my “10 Rules of Wisdom” towards BI success based on lessons learned from personal experience as well as from insight gained from leading authors and speakers in the BI universe. The purpose of my 10 Rules of  Wisdom is to serve as a guideline for anyone involved in a BI initiaive or in its planning stages.

My “10 Rules of  Wisdom” for Business Intelligence Success are listed below:

1. The Business Intelligence solution needs strong executive management support. Keyword: Sponsor
2. The Business Intelligence solution must add value to the organization and be trustworthy.
3. Always have a Business Intelligence roadmap in clear view.
4. Define iterative success criteria.
5. Choose the right technology based on your business and user needs.
6. The BI solution needs to be understandable and documented.
7. The BI solution needs to be accessible.
8. The BI solution must be able to grow according to the business needs.
9. The BI solution needs to adapt to new business analysis needs.
10. Partner with experts in the field to help you achieve your goals.

These and other topics can be found on my PowerPoint presentation below which I continuosly enhance for my presentations for SQL Saturdays and User Groups.

 (click on image to download)

Slides updated 3/24/2011

Afterthoughts: SQL Saturday #48 Columbia, SC

More than 1,000 miles later and almost 20 hours behind the wheel, I can only express how much I enjoyed each and every moment at SQL  Saturday #48 hosted in West Columbia, S.C. Let me get started by saying that it was a succesfull and well planned event. It had good attendance rate and had a great speaker line-up.

I have to recognize my wife for doing most of the driving. She volunteered behind the wheel while I sat back and and helped out keeping the girls entertained and busy munching on some veggie sticks.

The Highlights
I can not possibly start without pointing out that I walked away with the most valuable treasure of all: friendships. I was blessed to meet Brian Kelley (Blog | Linkedin | Twitter) and his family and be able to interact with their kids. Our two daughters Fae and Sofia had a great time together in the after party. It was very fulfilling to me to be able not just to meet a talented and well-respected guy such as Brian Kelley in a professional setting but also in a more personal way. I really hope this is the start of a long-lasting friendship.

I want to recognize Brian’s wife for manning the book  and prizes table while pregnant. Not many pregnant women would volunteer to be standing up and doing physical work for a whole Saturday. It really shows the type of committment Brian and his wife have to the SQL community.

More Networking
I also had the opportunity to meet and establish friendships with some amazing professionals, in particular funny guy Bobby Dimmick (Linkedin | Twitter). Some of the new connections and personal interactions for the firs time include:

• Brian Kelley (Blog | Linkedin | Twitter) – AgFirst Farm Credit Bank (AFFCB)
• Bobby Dimmick (Linkedin | Twitter) – VC3
• Mark Tabladillo (Blog | Twitter) – Solid Quality Mentors  
• Bob Langley (Linkedin) – Forsyth County BOC
• Chris Skorlinski (Blog | Linkedin) – Microsoft SQL Server Escalation Team
• Jessica Moss (Blog | Linkedin | Twitter) – Iron Works Consulting
• Rafael Salas (Blog | Linkedin | Twitter) – Quaero
• Geoff Hiten (Blog | Linkedin | Twitter) -Intellinet
• Stuart Ainsworth (Blog | Linkedin | Twitter) – Jack Henry & Associates
• Julie Smith (Blog | Linkedin | Twitter) – Key2 Consulting (and her upcoming SQL professional mom)
• Andy Leonard (Blog | Linkedin | Twitter) – Unysis
• Alex Tocitu (Blog | Linkedin | Twitter) – Gwinnett County Clerk of Courts
• William Pearson (Blog | Linkedin | Twitter) – Island Technologies, Inc
• Tim Radney (Blog | Linkedin | Twitter) – Synovus Financial Corp

I also got to see some of my friends and tweeps such as:

• Andy Warren (Blog | Linkedin | Twitter) – SQLShare.com
• David Taylor (Blog | Linkedin | Twitter) – Techsonic Industries, Inc
• Aaron Nelson (Blog | Linkedin | Twitter) – Intellinet
• Eric Humphrey (Blog | Linkedin | Twitter) – A/P Recovery, Inc

 I would like to give thanks to  the organizers and sponsors for such a great event. I also want to give a big thanks to the attendees to both my sessions, Get Cert! Get Cred! and Business Intelligence: Decaffeinated Please! I got great feedback and participation from them. I want to recognize some of my attendees for doing some constructive observations about my presentation style and visuals.  I value all comments that help me become a better speaker and presenter.

What I learned
In my third SQL Saturday I learned several things as an attendee and as a speaker.

First of all, SQL Saturday is a great opportunity to spend quality time with your family and to plan a mini-vacation, especially if traveling to a city or area you have not visited before. Also, if you are fortunate like I was, you may end up getting to know other professionals and their families. Next SQL Saturday bring your family along, especially to our Tampa SQL Saturday to be scheduled between January and February, 2011. I would love to meet you and your families.

Second as a SQL Server and Business Intelligence professional you get no better chance to meet your rockstars and be able to have an opportunity to interact. You also meet great professionals in the area with which you establish not only professional connections but also friendships. Friends with which if you can go out to lunch with if you are in their hometown or get good recommendations where to stay or what to do. Also, they can serve as a lifeline.

Third, I learned that you have to balance your presentation between what I consider the two main presentation styles: those who base their presentation on the slides content and those who base their presentation on the slide visuals primarily. The reason you have to balance these two main styles is because of your audience. Some audience members expect for you to follow your slide deck and stick to the text and content on them as much as possible (slide followers). Other audience members don’t like it when you repeat what is on your slide and want to hear what you have to say (content cravers). In this SQL Saturday I had the opportunity to experiment with both these styles. In Get Cert! Get Cred! I played with Guy Kawasaki’s style, while in Business Intelligence: Decaffeinated Please! I was a little more conservative. I got great feedback on both presentations ranging from As Expected and Better than Expected ratings with an overall average of 4.5 out of 5 rating. If you attended any of my sessions, I want to say thank you once more and keep commenting on ways to improve as a speaker.

Fourth, as SQL PASS Chapter leader it is a great opportunity to learn from the organization and management perspective of a SQL Saturday event. I learned what works and got some great pointers for our upcoming SQLSaturday in Tampa, FL early 2011. Also, I was able to connect with potential speakers for our user group and SQL Saturday event.

Fifth but not least, I had the opportunity to attend great sessions such as:

• William Pearson’s “Attribute Discretization in Analysis Service”
  Learned a native way of grouping dimension attributes into buckets.
• Mark Tabladillo’s “Data Mining with PowerPivot 2010” 
  Learned the reason behind the need for so many data mining models and more insight on PowerPivot.
• Andy Warren’s “Building a Professional Development Plan”
  Learned that you have to consider yourself as a “business of one” and make a plan for your goals as such.
  Also, learned that when you blog do it for yourself primarily even if you repeat what others have already blogged. Unless you are blogging as a business, don’t wory about duplication of content, keeping in mind not to plagiarize.
• Julie Smith’s “Cool Tricks to Pull from your SSIS Hat”
  Learned how to skip an SSIS container without using precedence constraints.

I hope I didn’t leave anyone or anything out. It is not my intention to exclude anyone. These are just some of  my afterthoughts. Please comment on anything or anyone I left out.