SQLSaturday #326 - Tampa - BA Edition 2014

Event Date: 10/25/2014 00:00:00

Event Location:

  • 5426 Bay Center Dr
  • Tampa, Florida

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Location Location Location Preparing and Presenting Geographic Data

Abstract: This session will begin with the tasks necessary to model a dimensional data structure to maintain and present geographic data. We will discuss various requirements that can affect a data model such as granularity, surrogate keys, slowly changing dimensions. Real life examples and solutions will provided to give better context to each step in the process. After the data structure has been created we will focus on how to best “clean” and validate the geographic data. We will focus on using SSIS to obtain latitude and longitude and then how this can be converted SQL Server spatial types. Finally we will cover presenting this data using SSRS and Power Map and how to create dynamic and aesthetically pleasing graphical reports. This portion of the session concentrates on presenting reports using the geographic data type that answer specific questions such as: Events that occurred at a specific address, zip code, and even block range and events within a mile radius.


  • David Dye

Track and Room: Track 3 - N/A

Title: Affecting Change with Automation

Abstract: As a BA/BI Professional you are in a key position of influence. Helping to guide your organization to embracing automation of testing, deployment and configuration will help your company deliver better, safer software faster. If you are interested in understanding automation’s role • What is automation, really? • Why is it important to me and my company? • Is this just one more thing to learn and do? • Where do you start? • When to start? • How can I be an influencer? • What’s in it for me? • What’s automation’s role in Big Data Mike has spent years successfully helping companies start or restart their path to automation. For some years Mike has had a passion for automating tasks processes related to the Software Development Lifecycle (SDLC), helping companies deliver the business value of their software more rapidly.


  • Mikey Nelson

Track and Room: Track 3 - N/A

Title: Clustered Columnstore Indexes: Internals and Design Considerations

Abstract: In this session, Dmitri will talk about internal structure of Clustered Columnstore Indexes. He will demonstrate how to design ETL processes and Columnstore Index Maintenance routines in the way that improve query performance in the system. Finally, Dmitri will discuss how to utilize Columnstore Indexes in reporting solutions that work with volatile data in OLTP environments.


  • Dmitri Korotkevitch

Track and Room: Track 2 - N/A

Title: Mastering the Technology Interview

Abstract: Join Mike as he shows you how to be prepared for technology job interviews. Learn the do’s and don’ts of interviewing for technology jobs. Learn what your resume says about you and your ability to grow. Learn how passion can overcome a lack of skills.


  • Mike Davis

Track and Room: Track 3 - N/A

Title: SSIS - Integrating PowerShell in a ScriptTask comp

Abstract: This session will demostrate how you can reuse a PowerShell script in SSIS “Script Task” component as part on a ETL flow. I’ll be showing some basic .NET Script code in both C# and VB. I’ll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell. Everyone is welcome to attend.


  • Maximo Trinidad

Track and Room: Track 1 - N/A

Title: Tips Tricks for dynamic SSRS Reports

Abstract: In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.


  • Pam Shaw

Track and Room: Track 3 - N/A

Title: Hadoop - Past, Present and Future

Abstract: A session focused on ramping you up on what Hadoop is, how its works and what it’s capable of. We will also look at what Hadoop 2.0 and YARN brings to the table and some future projects in the Hadoop space to keep an eye on.


  • Joe Rossi

Track and Room: Track 1 - N/A

Title: Why I won’t hire you and what you can do about it!

Abstract: As a hiring manager, I see the same mistakes over and over again. In this session we’ll talk about common mistakes in resumes, interviews, social media and how you can avoid them. We’ll also discuss lost opportunities and how not to miss them. This information applies to both internal and external candidates.


  • Leigh Freijo

Track and Room: Track 3 - N/A

Title: Big Data- Part 1 of 3- Let’s Get Started

Abstract: In this hour I will show you how to set up a Big Data environment, how to load and transform data, and how to access the data using Hadoop and Microsoft utilities. I will leave you with all of the pieces, parts, instructions, and additional experiments to set up your own environment and get some actual stick time. This is part one in a three part series which will take you from setting up your environment to basic analytics to applying analytics to business decision making.


  • Michael Reed

Track and Room: Track 1 - N/A

Title: An introduction to Business Intelligence and Big Data

Abstract: The problem with the old way of organizing and analyzing data in RDBMS is that it is painfully slow, incomplete and costly. We are obligated to be selective and work with data in small chunks. In the best case scenario we partitioned our data and archived it with the hope to eventually use it, but the fact is that when data is being archived, usually, it is never used again. We don’t even bother with collecting all the data due to economics and technical limitations. In this presentation I will introduce BI and Big Data, explain advantages and disadvantages of OLTP, OLAP and Big Data.


  • Frank Quintana

Track and Room: Track 1 - N/A

Title: Dozen tips and tricks you should know when working with SSRS

Abstract: SQL Server Reporting Services have many useful but not well-known features. Many BI developers do not know how to create interactive reports or reports with dynamic columns; how to use JavaScript in reports or display an image in multiple columns. Come to this session and you will learn 12 useful tips and tricks, which will help you to make impressive reports and simplify their development.


  • Andrey Korshikov

Track and Room: Track 2 - N/A

Title: Introduction to PowerPivot

Abstract: Building an SSAS cube isn’t for everyone. PowerPivot is! This session is for anyone who wants to get started in PowerPivot. Join us as we build a PowerPivot model from the ground up and then create some reports, all in just over an hour. Learn how to use data from existing sources, such as SQL Server databases or Analysis Services, as well as how to integrate currently unrelated data from sources such as Excel workbooks.


  • Mitchell Pearson

Track and Room: Track 2 - N/A

Title: Advanced Analytics with Excel and Power BI

Abstract: Take your Power BI analytics skills to the next level. In this session we will introduce and walk-through a variety of popular advanced analytic techniques and tools. We will cover prescriptive and predictive analytics, methodology and tools including but not limited to Microsoft Power BI: Excel, Power Pivot, Power Query, SQL Server Data Mining, Predixion, Frontline Systems Solver and R. Advanced analytics lifecycle topics discussed include choosing the right analytic technique and tool, data preparation, developing analytic models, evaluating models and implementing analytics into smart reports, dashboards, business processes and applications.


  • Jen Underwood

Track and Room: Track 2 - N/A

Title: Big Data- Part 2 of 3- Beyond the Basics

Abstract: In this hour I will build on the exercises in Part 1 of this series. I will cover more advanced data acquisition and transformations, building ‘tidy’ data sets, plotting and visualizations, and basic data mining using a variety of tools and utilities. This is part two in a three part series which takes you from setting up your environment to basic analytics to applying analytics to business decision making.


  • Michael Reed

Track and Room: Track 1 - N/A


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Dmitri Korotkevitch

Twitter: - aboutsqlserver

LinkedIn: Dmitri Korotkevitch

Contact: http://aboutsqlserver.com

Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect.

Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.

Jen Underwood

Twitter: - @idigdata

LinkedIn: Jen Underwood

Contact: http://www.jenunderwood.com

Jen Underwood is a Senior Director at DataRobot. Over the past 20 years, Jen has held worldwide product management roles at Microsoft and served as a technical lead for system implementation firms. She has a unique blend of product management and “hands-on” experience in data warehousing, reporting, visualization, and advanced analytics. In addition to keeping a constant pulse on industry trends, she enjoys digging into oceans of data to solve complex problems with machine learning.

Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

Mike Davis

Twitter: - @mikedavisSQL

LinkedIn: Mike Davis

Contact: http://MikeDavisSQL.com

Mike Davis, MCITP, is a Consulting Team Lead at Pragmatic Works. He is an author with books covering Business Intelligence and SSIS. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQLSaturday, and SQL Rally. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

Joe Rossi

Contact: http://bigdatajoe.io/

“Big Data Joe” is the Engineering Lead and Big Data Architect at Trace3’s Big Data Intelligence Practice. Joe is certified in most Hadoop distributions as an administrator, engineer and developer. Joe is the technical Big Data evangelist for Trace3 and speaks at T3’s workshops, training sessions and events. He has 16 years of experience in the IT field as hands-on engineer with startups to Fortune 5 companies. He enjoys sharing his findings and helping others make sense of new technologies.

Frank Quintana

Twitter: - Frankqr2

LinkedIn: Frank Quintana

Contact: http://www.businessintelligencematters.us

Doctor Quintana has been involved in optimization and math modeling since the ’80s. He is an IT University professor of Data Science, Databases, Data Mining, and Knowledge Discovery. He is a former head of an RD department. He worked as a research engineer at the Memorial University of Newfoundland. He also worked as a consultant in the role of a technical team leader and software architect for EDS responsible for critical parts of the SDLC for multi-million dollar projects. He is one of the Software Architects that designed and built the “Health and Benefits System for the of the Veteran Affairs of Canada” He is a regular speaker at national and international events In 2004 he started his consulting practice in South and Central Flori

Michael Reed

LinkedIn: Michael Reed

I have been working with SQL Server for 14 years, have a background in business, worked in the Microsoft Online Services Division, Behavioral Targeting group, am employed by Pragmatic Works as a Senior BI Consultant. I am studying Data Science through online certificate programs and bring this experience to my presentations. I am particularly interested in how to apply Big Data to solve business problems.

Leigh Freijo

Twitter: - @leighfreijo

LinkedIn: Leigh Freijo

Leigh Freijo is a Manager in Database Administration for Raymond James Financial. Leigh is an experienced SQL Server DBA and the chapter leader of the Pinellas SQL User Group.

Michael Reed

LinkedIn: Michael Reed

I have been working with SQL Server for 14 years, have a background in business, worked in the Microsoft Online Services Division, Behavioral Targeting group, am employed by Pragmatic Works as a Senior BI Consultant. I am studying Data Science through online certificate programs and bring this experience to my presentations. I am particularly interested in how to apply Big Data to solve business problems.

Pam Shaw

Twitter: - @PamShaw

LinkedIn: Pam Shaw

Contact: http://sqlpam.wordpress.com/

Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.

Andrey Korshikov

Работать с SQL Server начал в 2003 году. Довелось работать и сдавать сертификационные экзамены по версиям SQL Server от 2000 до 2012. Участник конференций SQLSaturday, Платформа, DevCon и TechEd. География выступлений от Тампы до Красноярска, от Санкт-Петербурга до Тбилиси. Основатель сообществ Krasnodar SQLamp;BI Usergroup и Global Russian Virtual Chapter. На данный момент являюсь PASS Regional Mentor for Central Eastern Europe.

Mitchell Pearson

Twitter: - @MitchellSQL

Contact: http://www.mitchellpearson.com

Mitchell is an experienced Business Intelligence Consultant and Trainer at Pragmatic Works and is currently the content training manager leading content development and delivery of training courses. Mitchell is experienced developing BI solutions using the full Microsoft BI Stack (SSRS, SSIS, and SSAS) as well as Microsoft Power BI. He is also very active in the community speaking at SQLSaturday events, local user groups, and online virtual events. Mitchell also blogs at mitchellpearson.com.

Maximo Trinidad

Twitter: - maxtrinidad

LinkedIn: Maximo Trinidad

Contact: http://www.maxtblog.com

Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps events.

Mikey Nelson

Contact: http://www.therealmikenelson.com

For years Mike has had a passion for automating tasks processes related to the Software Development Lifecycle (SDLC), helping companies deliver the business value of their software more rapidly. Whether establishing from scratch, working with a company’s existing Automation Toolset or identifying gaps in the set for appropriate additions, building a new team or augmenting or mentoring an existing team, I bring the clarity and experience required to get the job done quickly efficiently.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page