SQLSaturday #163 - Dallas - BI Edition 2012
10/13/2012 12:00:00 AM
(GMT-06:00) Central Time (US and Canada)
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server.
#sqlsat163
Microsoft Campus , 7000 State Hwy 161, Bldg LC1
Irving
TX
75039
http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png
http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png
2691
Microsoft
Gold Sponsor
http://www.microsoft.com/en-us/default.aspx
http://www.sqlsaturday.com/files/380d6cda-c272-46d2-b65d-500ae3398742.png
60
170
9672
SQLSaturday 163
MPR 1200
Break
10/13/2012 10:15:00 AM
10/13/2012 10:30:00 AM
9672
SQLSaturday 163
MPR 1200
Break
10/13/2012 2:15:00 PM
10/13/2012 2:30:00 PM
9672
SQLSaturday 163
MPR 1200
Break
10/13/2012 3:45:00 PM
10/13/2012 4:00:00 PM
9672
SQLSaturday 163
MPR 4005
Break
10/13/2012 10:15:00 AM
10/13/2012 10:30:00 AM
9672
SQLSaturday 163
MPR 4005
Break
10/13/2012 2:15:00 PM
10/13/2012 2:30:00 PM
9672
SQLSaturday 163
MPR 4005
Break
10/13/2012 3:45:00 PM
10/13/2012 4:00:00 PM
9672
SQLSaturday 163
MPR 4025
Break
10/13/2012 10:15:00 AM
10/13/2012 10:30:00 AM
9672
SQLSaturday 163
MPR 4025
Break
10/13/2012 2:15:00 PM
10/13/2012 2:30:00 PM
9672
SQLSaturday 163
MPR 4025
Break
10/13/2012 3:45:00 PM
10/13/2012 4:00:00 PM
9672
SQLSaturday 163
Office
Break
10/13/2012 10:15:00 AM
10/13/2012 10:30:00 AM
9672
SQLSaturday 163
Office
Break
10/13/2012 2:15:00 PM
10/13/2012 2:30:00 PM
9672
SQLSaturday 163
Office
Break
10/13/2012 3:45:00 PM
10/13/2012 4:00:00 PM
9672
SQLSaturday 163
Windows
Break
10/13/2012 10:15:00 AM
10/13/2012 10:30:00 AM
9672
SQLSaturday 163
Windows
Break
10/13/2012 2:15:00 PM
10/13/2012 2:30:00 PM
9672
SQLSaturday 163
Windows
Break
10/13/2012 3:45:00 PM
10/13/2012 4:00:00 PM
9673
SQLSaturday 163
Windows
Lunch Break
10/13/2012 11:45:00 AM
10/13/2012 1:00:00 PM
9673
SQLSaturday 163
Office
Lunch Break
10/13/2012 11:45:00 AM
10/13/2012 1:00:00 PM
9673
SQLSaturday 163
MPR 4025
Lunch Break
10/13/2012 11:45:00 AM
10/13/2012 1:00:00 PM
9673
SQLSaturday 163
MPR 4005
Lunch Break
10/13/2012 11:45:00 AM
10/13/2012 1:00:00 PM
9673
SQLSaturday 163
MPR 1200
Lunch Break
10/13/2012 11:45:00 AM
10/13/2012 1:00:00 PM
9686
Patrick Gallucci
MPR 4025
GeoBI, Interactive Geospatial Analytics
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.
10/13/2012 4:00:00 PM
10/13/2012 5:15:00 PM
9731
Rob Kerr
Windows
100x query performance improvement with xVelocity
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.
10/13/2012 4:00:00 PM
10/13/2012 5:15:00 PM
9769
Adam Saxton
MPR 4025
What is Claims - A look at RS 2012 with SP 2010
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.
10/13/2012 9:00:00 AM
10/13/2012 10:15:00 AM
9771
Garrett Edmondson
Windows
Scaling SQL Server to HUNDREDS of Terabytes!
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.
10/13/2012 9:00:00 AM
10/13/2012 10:15:00 AM
9884
Bryan Smith
MPR 1200
An Introduction to Big Data for BI
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.
10/13/2012 10:30:00 AM
10/13/2012 11:45:00 AM
9886
Bryan Smith
MPR 4025
Building a Business Intelligence Competency Center
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.
10/13/2012 2:30:00 PM
10/13/2012 3:45:00 PM
10056
David Eichner
MPR 1200
SRS Report Builder for Business Intelligence
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!
10/13/2012 4:00:00 PM
10/13/2012 5:15:00 PM
10591
Patrick Brady
Windows
Monitoring SQL Server Analysis Services with DMVs
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.
10/13/2012 1:00:00 PM
10/13/2012 2:15:00 PM
10736
Paul Turley
MPR 4005
Power View and PowerPivot: High-Octane Self-Svc BI
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!
10/13/2012 9:00:00 AM
10/13/2012 10:15:00 AM
10737
Paul Turley
MPR 4025
Use a custom assembly to extend reports queries
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.
10/13/2012 10:30:00 AM
10/13/2012 11:45:00 AM
10973
J Sawyer
Windows
Introducing StreamInsight 2.1
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.
10/13/2012 10:30:00 AM
10/13/2012 11:45:00 AM
11127
Ira Whiteside
Office
Creating a Metadata Mart w/ SSIS - Data Governance
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.
10/13/2012 10:30:00 AM
10/13/2012 11:45:00 AM
11176
Ryan Adams
Office
How Active Directory affects SQL Server BI
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.
10/13/2012 2:30:00 PM
10/13/2012 3:45:00 PM
11257
Paul Waters
Office
Automating SSIS Development with Biml
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.
10/13/2012 9:00:00 AM
10/13/2012 10:15:00 AM
11265
Chaitanya Khaladkar
MPR 4025
Data cleansing and Data Quality
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
10/13/2012 1:00:00 PM
10/13/2012 2:15:00 PM
11271
Jason Horner
Office
PoSh Eye for the BI Guy
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.
10/13/2012 1:00:00 PM
10/13/2012 2:15:00 PM
11272
Jason Horner
MPR 1200
Dimensional Modeling: Beyond the Basics
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!
10/13/2012 9:00:00 AM
10/13/2012 10:15:00 AM
11274
visakh murukesan
MPR 1200
SSIS Project Deployment Model
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
10/13/2012 2:30:00 PM
10/13/2012 3:45:00 PM
11275
Mahesh Pujari
MPR 4005
Data Visualizations with Microsoft BI Stack
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.
10/13/2012 4:00:00 PM
10/13/2012 5:15:00 PM
11281
Tim Mitchell
MPR 1200
Getting Started with SSIS 2012
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.
10/13/2012 1:00:00 PM
10/13/2012 2:15:00 PM
11285
Ef Romero
Windows
Partitioning Performance in the Data Warehouse
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.
10/13/2012 2:30:00 PM
10/13/2012 3:45:00 PM
11289
Sri Sridharan
MPR 4005
PDW - What is it ? Is it right for me ?
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.
10/13/2012 1:00:00 PM
10/13/2012 2:15:00 PM
11384
Jeff Johnston
MPR 4005
Analytical MDM with Master Data Services 2012
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.
10/13/2012 2:30:00 PM
10/13/2012 3:45:00 PM
11385
Dave Stein
MPR 4005
Dimensions, It's All Meaningless Without Them
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.
10/13/2012 10:30:00 AM
10/13/2012 11:45:00 AM
11559
SQLSaturday 163
MPR 1200
Opening
Opening Comments
10/13/2012 8:30:00 AM
10/13/2012 9:00:00 AM
11560
SQLSaturday 163
MPR 1200
Closing
Closing Comments
10/13/2012 5:30:00 PM
10/13/2012 5:45:00 PM