sqlsathistory

Nr: 326

Back to Main list

SQLSaturday #326 - Tampa - BA Edition 2014

Start Time (24h) Speaker Track Title
00:00:00 David Dye Track 3 Location Location Location Preparing and Presenting Geographic Data
00:00:00 Dmitri Korotkevitch Track 2 Clustered Columnstore Indexes: Internals and Design Considerations
00:00:00 Frank Quintana Track 1 An introduction to Business Intelligence and Big Data
00:00:00 Jen Underwood Track 2 Advanced Analytics with Excel and Power BI
00:00:00 Joe Rossi Track 1 Hadoop - Past, Present and Future
00:00:00 Andrey Korshikov Track 2 Dozen tips and tricks you should know when working with SSRS
00:00:00 Leigh Freijo Track 3 Why I won't hire you and what you can do about it!
00:00:00 Maximo Trinidad Track 1 SSIS - Integrating PowerShell in a ScriptTask comp
00:00:00 Mike Davis Track 3 Mastering the Technology Interview
00:00:00 Mikey Nelson Track 3 Affecting Change with Automation
00:00:00 Mitchell Pearson Track 2 Introduction to PowerPivot
00:00:00 Michael Reed Track 1 Big Data- Part 1 of 3- Let’s Get Started
00:00:00 Michael Reed Track 1 Big Data- Part 2 of 3- Beyond the Basics
00:00:00 Pam Shaw Track 3 Tips Tricks for dynamic SSRS Reports

SessionID: 13204

Location Location Location Preparing and Presenting Geographic Data

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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!

Back to calendar

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:

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.

SessionID: 19917

SSIS - Integrating PowerShell in a ScriptTask comp

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 25-10-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Mitchell Pearson

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.

SessionID: 21104

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

Back to calendar

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:

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.

SessionID: 21105

Big Data- Part 2 of 3- Beyond the Basics

Back to calendar

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:

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.

SessionID: 22366

Tips Tricks for dynamic SSRS Reports

Back to calendar

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.