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!
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
- Pivot Tables
- Solver and What-If Analysis
- Predictive Analytics
- SQL Server Data Mining Add-In for Excel
- “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.