sqlsathistory

Nr: 163

Back to Main list

SQLSaturday #163 - Dallas - BI Edition 2012

Start Time (24h) Speaker Track Title
00:00:00 Bryan Smith Beginner 1 An Introduction to Big Data for BI
00:00:00 Bryan Smith Advanced Building a Business Intelligence Competency Center
00:00:00 Chaitanya Khaladkar Advanced Data cleansing and Data Quality
00:00:00 David Stein Intermediate 1 Dimensions, It's All Meaningless Without Them
00:00:00 David Eichner Beginner 1 SRS Report Builder for Business Intelligence
00:00:00 Ef Romero Intermediate 2 Partitioning Performance in the Data Warehouse
00:00:00 Garrett Edmondson Intermediate 2 Scaling SQL Server to HUNDREDS of Terabytes!
00:00:00 Ira Warren Beginner 2 Creating a Metadata Mart w/ SSIS - Data Governance
00:00:00 Jason Horner Beginner 2 PoSh Eye for the BI Guy
00:00:00 Jason Horner Beginner 1 Dimensional Modeling: Beyond the Basics
00:00:00 Jeff Johnston Intermediate 1 Analytical MDM with Master Data Services 2012
00:00:00 J Sawyer Intermediate 2 Introducing StreamInsight 2.1
00:00:00 Mahesh Pujari Intermediate 1 Data Visualizations with Microsoft BI Stack
00:00:00 Patrick Gallucci Advanced GeoBI, Interactive Geospatial Analytics
00:00:00 Patrick Brady Intermediate 2 Monitoring SQL Server Analysis Services with DMVs
00:00:00 Paul Waters Beginner 2 Automating SSIS Development with Biml
00:00:00 Paul Turley Intermediate 1 Power View and PowerPivot: High-Octane Self-Svc BI
00:00:00 Paul Turley Advanced Use a custom assembly to extend reports queries
00:00:00 Rob Kerr Intermediate 2 100x query performance improvement with xVelocity
00:00:00 Ryan Adams Beginner 2 How Active Directory affects SQL Server BI
00:00:00 Sri Sridharan Intermediate 1 PDW - What is it ? Is it right for me ?
00:00:00 Tim Mitchell Beginner 1 Getting Started with SSIS 2012
00:00:00 visakh murukesan Beginner 1 SSIS Project Deployment Model
00:00:00 Adam Saxton Advanced What is Claims - A look at RS 2012 with SP 2010

SessionID: 11061

An Introduction to Big Data for BI

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 1

Speaker: Bryan Smith

Title: An Introduction to Big Data for BI

Abstract:

A lot has been made of Microsoft's announcement around support for Apache Hadoop but many in the Microsoft Business Intelligence community have been left scratching their head about what this exactly means. In this session, we will discuss Big Data concepts, pick apart Microsoft's announcement, and explore what Big Data means for Business Intelligence programs traditionally focused on data warehousing.

SessionID: 11063

Building a Business Intelligence Competency Center

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Advanced

Speaker: Bryan Smith

Title: Building a Business Intelligence Competency Center

Abstract:

If you build it, they will come! While we may all hope that this will be the case, the successful adoption of the data warehouse and other Business Intelligence tools requires continued engagement with the business. In this session, we will explore strategies for encouraging not only adoption but integration of BI into the day-to-day activities of our organizations through what has become known as a Business Intelligence Competency Center (BICC). This is a non-technial session intended for BI architects and managers.

SessionID: 11395

Data cleansing and Data Quality

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Advanced

Speaker: Chaitanya Khaladkar

Title: Data cleansing and Data Quality

Abstract:

In this session we will look at what Data Quality Services (DQS) in SQL Server 2012. We will look at how DQS enables data stewards to maintain the quality of their data. A major part of maintaining data quality is making sure data is clean before it makes its way to the Data Warehouse. We will also look at how DQS components in SQL Server Integration Services help cleanse data

SessionID: 12440

Dimensions, It's All Meaningless Without Them

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 1

Speaker: David Stein

Title: Dimensions, It's All Meaningless Without Them

Abstract:

Dimensions are arguably the most important part of Dimensional Modeling, and it’s critical that they are designed properly. In this session, we’ll go beyond just the basics. You’ll learn how to:

Properly design Dimension tables. Understand the different types of Slowly Changing Dimensions and their proper use. Load SCDs using several accepted methods including T-SQL Merge, the SCD Wizard, and a free custom transformation.

SessionID: 12751

SRS Report Builder for Business Intelligence

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 1

Speaker: David Eichner

Title: SRS Report Builder for Business Intelligence

Abstract:

Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy!

SessionID: 13749

Partitioning Performance in the Data Warehouse

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 2

Speaker: Ef Romero

Title: Partitioning Performance in the Data Warehouse

Abstract:

By simply applying partitioning to large tables, a database developer can possibly yield immediate benefits in query and ETL performance. This presentation will discuss methods that will allow BI developers to more fully leverage table partitioning in order to improve ETL and query performance in the data warehouse lifecycle. The benefits of partitioning‘s participation in an implementation of SQL Server 2012’s new columnar index storage will also be discussed.

SessionID: 14408

Scaling SQL Server to HUNDREDS of Terabytes!

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 2

Speaker: Garrett Edmondson

Title: Scaling SQL Server to HUNDREDS of Terabytes!

Abstract:

Provide an introduction to the Microsoft Appliance and Reference Architectures. Learn how these Appliance Architectures can scale to hundreds of Terabytes. The presentation will focus on the Fast Track Reference Architecture and also contain real world performance metrics and lessons learned directly from someone who actually developed a Parallel Data Warehouse (PDW) BI Solution.

SessionID: 15496

Creating a Metadata Mart w/ SSIS - Data Governance

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 2

Speaker: Ira Warren

Title: Creating a Metadata Mart w/ SSIS - Data Governance

Abstract:

This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We  will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.

SessionID: 15844

PoSh Eye for the BI Guy

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 2

Speaker: Jason Horner

Title: PoSh Eye for the BI Guy

Abstract:

In this session, we will explore the many ways that you can use Windows

PowerShell to simplify software development, deployment, and administration. We will discuss PowerShell features related to Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS). We will also review project structure and configuration management best practices. Some previous exposure with PowerShell or .Net programming is assumed.

SessionID: 15845

Dimensional Modeling: Beyond the Basics

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 1

Speaker: Jason Horner

Title: Dimensional Modeling: Beyond the Basics

Abstract:

In this session, we will dive deeper into the art of dimensional modeling.

We will identify the different types of fact tables and dimension tables and discuss how and when to use each type. We will also review approaches to creating rich hierarchies that simplify complex reporting. This session will be very interactive--bring your toughest dimensional modeling quandaries!

SessionID: 16868

Analytical MDM with Master Data Services 2012

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 1

Speaker: Jeff Johnston

Title: Analytical MDM with Master Data Services 2012

Abstract:

In this session we will take a deep dive in to Analytical Master Data Management and how it differs from Operational Master Data Management. We will examine how you can leverage SQL 2012 Master Data Services to manage your data warehouse dimensions and hierarchies. Come learn how you can leverage the new features of SQL 2012 Master Data Services to enroll business users in the process of master data management to reduce the burden on IT and as a result, maximize the value of your Master Data Management solution.

SessionID: 17638

Introducing StreamInsight 2.1

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 2

Speaker: J Sawyer

Title: Introducing StreamInsight 2.1

Abstract:

StreamInsight provides real-time analytics on large volumes of data with a response time measured in milliseconds, bringing a new level of capabilities to the Sql Server platform. This session will provide an overview of StreamInsight, its capabilities and use cases. It will also provide details on StreamInsight 2.1, what's been added and how it makes your real-time applications easier and more robust.

SessionID: 19389

Data Visualizations with Microsoft BI Stack

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 1

Speaker: Mahesh Pujari

Title: Data Visualizations with Microsoft BI Stack

Abstract:

Microsoft SQL Server 2012 provides tools for rapid data exploration and discovery; and creation of rich data visualizations using Power Pivot and Power View. This allows users to see and interact with their information in a faster and more dynamic way compared to static reports. In this session, we will take an in-depth look at data visualizations and how to create compelling reports that deliver relevant insights to business to make informed decisions.

This session will cover the end user experience of Data Visualization. We will look at how data helps business gain insights into processes and make informed decisions.

SessionID: 21757

GeoBI, Interactive Geospatial Analytics

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Advanced

Speaker: Patrick Gallucci

Title: GeoBI, Interactive Geospatial Analytics

Abstract:

As more and more organizations implement Business Intelligence, utilizing geographic data for analytics is becoming more prevalent. We will look a real world implementation of Geospatial Analytics. We will start with data acquisition, to preparing the data and data analysis, to providing a rich interactive BI presentation layer for your end users. We will explore the features of SQL Server 2012 SharePoint 2010 and other 3rd Party and open source applications for delivering an interactive GeoBI Project.

SessionID: 21767

Monitoring SQL Server Analysis Services with DMVs

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 2

Speaker: Patrick Brady

Title: Monitoring SQL Server Analysis Services with DMVs

Abstract:

Imagine having the power in your hands to quickly provide activity information about open connections to Analysis Services, memory usage by specific objects, or a list of cube measures in a connection. In this session, you'll discover the power of SQL Server Analysis Services Dynamic Management Views (DMVs) that provide this information and so much more. These simple yet powerful views provide administrators with easy access to valuable information including current active sessions and connections, memory consumption, performance counters, and cube partitioning. In addition, DMVs also provide the ability to richly describe and document the structure of your cubes.

SessionID: 21819

Automating SSIS Development with Biml

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 2

Speaker: Paul Waters

Title: Automating SSIS Development with Biml

Abstract:

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, there are some painful shortcomings that make it difficult to automate package creation, easily reuse patterns and templates, and create packages directly from schema information and other metadata. The free and open source BIDS Helper Add-In offers support for automatically generating SSIS packages using the Business Intelligence Markup Language (Biml).

In this session we will start by showing the power of Biml. We will then step back, and start from the beginning of using BimlScript. Once we cover the basics, we will cover practical examples using the BIDS Helper add-in to automate SSIS development.

SessionID: 21843

Power View and PowerPivot: High-Octane Self-Svc BI

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 1

Speaker: Paul Turley

Title: Power View and PowerPivot: High-Octane Self-Svc BI

Abstract:

The next-generation analytic, self-service reporting tools will knock your socks off! The Power View reporting experience in SQL Server 2012 and SharePoint 2010 takes user reporting to the next level and makes data exploration fun without writing queries and code. Come see the impressive performance capabilities of BI Semantic Tabular models used with high-volume, enterprise data. Two great things that go great together!

SessionID: 21844

Use a custom assembly to extend reports queries

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Advanced

Speaker: Paul Turley

Title: Use a custom assembly to extend reports queries

Abstract:

Amp up Reporting Services and tale your business reports to the next level with custom code written in Visual Studio. Build one dynamic super report to replace several other reports and address business requirements more effectively. Dynamically add or remove query columns, modify groups and sorting options.

SessionID: 23069

100x query performance improvement with xVelocity

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 2

Speaker: Rob Kerr

Title: 100x query performance improvement with xVelocity

Abstract:

Learn how to achieve eye-popping performance for your data warehouse and analysis services queries using SQL Server 2012's xVelocity technologies. This session covers the core xVelocity technology and demonstrates its use in various data warehouse and analytical scenarios.

SessionID: 23725

How Active Directory affects SQL Server BI

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 2

Speaker: Ryan Adams

Title: How Active Directory affects SQL Server BI

Abstract:

There are many things that can go wrong with SQL server, and a lot of times they come from outside influencers. Whether you're using SSRS, SSIS, or SSAS, Active Directory is one of the largest influencers. We'll discuss how the location of your server in AD is important, how security can be compromised, AD DNS configuration, and of course Kerberos. By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work. This includes the biggest perpetrator, Group Policy Objects.

SessionID: 25179

PDW - What is it ? Is it right for me ?

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 1

Speaker: Sri Sridharan

Title: PDW - What is it ? Is it right for me ?

Abstract:

In this session, you will learn about what is Parallel Datawarehouse. We will go into its architecture and understand what are good technical scenarios that justify going into Parallel DW.

SessionID: 26613

Getting Started with SSIS 2012

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 1

Speaker: Tim Mitchell

Title: Getting Started with SSIS 2012

Abstract:

In this session, we'll take a tour through SQL Server Integration Services in SQL Server 2012. We'll briefly review the essentials of SSIS and will walk through the key elements of data movement and transformation using Integration SErvices. We'll focus much of our time on the new and improved features in this latest version of SSIS.

This session will be most useful for database professionals with some experience with either DTS or SSIS, including those who are currently using an earlier version of the product and are interested in learning about what's new in 2012.

SessionID: 27469

SSIS Project Deployment Model

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 1

Speaker: visakh murukesan

Title: SSIS Project Deployment Model

Abstract:

In this session, we will look at the features of the SSIS Project Deployment Model in SQL 2012. Specific areas of interest include:Shared Connection Managers : Ability to create project level connection managers which can be shared across multiple packages within projectParameterization of package properties: Concept of parameters introduced through which properties within packages can be parameterized and set from outside for automated as well as interactive package execution using environment variable setsSeamless deployment and execution monitoring through SSIS catalog: Addition of new SSIS catalog DB for storing and managing the execution of packages and easy monitoring and auditing through improved set of standard reports

SessionID: 9914

What is Claims - A look at RS 2012 with SP 2010

Back to calendar

Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Advanced

Speaker: Adam Saxton

Title: What is Claims - A look at RS 2012 with SP 2010

Abstract:

People say that Kerberos isn't need with Reporting Services 2012. That is a half truth. We will look at what has happened with Reporting Services 2012 from an authentication perspective. This will look at how Claims Authentication fits into the picture and what Kerberos items need to be addressed as a result. If you are setting up Reporting Services 2012 with SharePoint 2010, you need to be aware of how this works and how it can affect you.