Welcome to SQLSaturday #273

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Feb 22 2014 at University of South Florida (USF), College of Business Bldg., 12212 USF Maple Drive, Tampa, Fl 33620. Admittance to this event is free, but we do charge a lunch fee of 10.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited, and let friends and colleagues know about the event.

Please note the change in venue - HCC was not able to accommodate us this year. USF has graciously volunteered to host us.

Location : University of South Florida (USF) College of Business Bldg. 12212 USF Maple Drive Tampa, Fl 33620 Click Location for details

Registration starts at 8:00 am, The first session will start 9:00 am. The last session concludes at 5:00 pm to be followed by the raffle and an off site after event.

USF has internet connectivity available via the following link: http://www.usf.edu/it/services/wireless-guest-access.aspx

SpeedPASS has been posted. Log in and go to your profile or look for your link in an email this week. Be sure to print and bring with you on Saturday to avoid registration lines.

Hope to see you there!

Pre Cons!

We are very excited about our 2 pre-cons this year. Each pre-con is an entire day of training for only $99! Space is limited so sign up soon!

Tampa SQL Saturday 2014 Power BI and Excel Analytics Precon

Come join us for the Tampa SQL Saturday precon presented by Jen Underwood!

Power BI and Excel Analytics

Power BI and Excel Analytics touches upon an array of Excel data analysis, dashboard development and predictive analytics topics. This fast-paced course is designed for data analysts, business analysts, advanced Excel users and business intelligence developers that want to expand their analytics skills. We will introduce and walk-through a variety of popular analytic tools including but not limited to Microsoft Power BI: Power Pivot, Power Query, Power Map and Power View, analytics with Excel, predictive analytics with the SQL Server Data Mining Add-In for Excel, Predixion and R.

Topics covered include:

Microsoft Power BI

Power Pivot

Power Query

Power Map

Power View

Excel Data Analytics

Slicers

Pivot Tables

Filtering

Sparklines

Dashboards

Solver and What-If Analysis

Predictive Analytics

SQL Server Data Mining Add-In for Excel

Predixion

R

“Smart” Reports

Jen Underwood, has almost 20 years of experience in business intelligence and predictive analytics. Prior to starting Impact Analytix, she held roles as a Microsoft Business Intelligence Technical Product Manager, Tableau Evangelist and also as a Business Intelligence Consultant. Jen holds a Bachelor of Business Administration degree from the University of Wisconsin, Milwaukee and a post graduate certificate in Computer Science - Data Mining from the University of California, San Diego.

Tampa SQL Saturday 2014 SQL Server Performance Tuning Precon

Come join us for the Tampa SQL Saturday precon presented by Jeff Garbus!

Topics covered include:

Indexing for performance

Join performance, self joins, and advanced join techniques

Stored procedure performance

Advanced session configuration

Working with nulls

Advanced / new select options

Writing dynamic SQL

Writing recursive CTEs

Jeff has been in the SQL Server business for over 20 years, training and consulting, with an emphasis on performance and tuning. He has written over a dozen books, and hundreds of magazine articles. He has spoken at weeks of SQL Saturdays.

*We do ask that you consider to OPT-IN for the Sponsors of this event. Without their assistance, we cannot bring this FREE event to you. You can always opt-out if and when they contact! Thank you for your consideration.