Nr: 326
SQLSaturday #326 - Tampa - BA Edition 2014
SessionID: 13204
Location Location Location Preparing and Presenting Geographic Data
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: David Dye
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.
SessionID: 13298
Clustered Columnstore Indexes: Internals and Design Considerations
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Dmitri Korotkevitch
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.
SessionID: 14315
An introduction to Business Intelligence and Big Data
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Frank Quintana
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.
SessionID: 16455
Advanced Analytics with Excel and Power BI
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Jen Underwood
Title: Advanced Analytics with Excel and Power BI
Abstract:
SessionID: 17610
Hadoop - Past, Present and Future
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Joe Rossi
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.
SessionID: 18823
Dozen tips and tricks you should know when working with SSRS
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Andrey Korshikov
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.
SessionID: 19008
Why I won't hire you and what you can do about it!
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Leigh Freijo
Title: Why I won't hire you and what you can do about it!
Abstract:
SessionID: 19917
SSIS - Integrating PowerShell in a ScriptTask comp
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Maximo Trinidad
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.
SessionID: 19977
Mastering the Technology Interview
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Mike Davis
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.
SessionID: 20636
Affecting Change with Automation
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Mikey Nelson
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.
SessionID: 21011
Introduction to PowerPivot
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Mitchell Pearson
Title: Introduction to PowerPivot
Abstract:
SessionID: 21104
Big Data- Part 1 of 3- Let’s Get Started
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Michael Reed
Title: Big Data- Part 1 of 3- Let’s Get Started
Abstract:
SessionID: 21105
Big Data- Part 2 of 3- Beyond the Basics
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Michael Reed
Title: Big Data- Part 2 of 3- Beyond the Basics
Abstract:
SessionID: 22366
Tips Tricks for dynamic SSRS Reports
Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Pam Shaw
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.