Nr: 163
SQLSaturday #163 - Dallas - BI Edition 2012
SessionID: 11061
An Introduction to Big Data for BI
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
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Advanced
Speaker: Bryan Smith
Title: Building a Business Intelligence Competency Center
Abstract:
SessionID: 11395
Data cleansing and Data Quality
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
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
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
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 2
Speaker: Ef Romero
Abstract:
SessionID: 14408
Scaling SQL Server to HUNDREDS of Terabytes!
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:
SessionID: 15496
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 2
Speaker: Ira Warren
Abstract:
SessionID: 15844
PoSh Eye for the BI Guy
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
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
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
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 2
Speaker: J Sawyer
Title: Introducing StreamInsight 2.1
Abstract:
SessionID: 19389
Data Visualizations with Microsoft BI Stack
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 1
Speaker: Mahesh Pujari
Title: Data Visualizations with Microsoft BI Stack
Abstract:
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
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
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:
SessionID: 21819
Automating SSIS Development with Biml
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 2
Speaker: Paul Waters
Title: Automating SSIS Development with Biml
Abstract:
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
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:
SessionID: 21844
Use a custom assembly to extend reports queries
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
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Intermediate 2
Speaker: Rob Kerr
Abstract:
SessionID: 23725
How Active Directory affects SQL Server BI
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 ?
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
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Beginner 1
Speaker: Tim Mitchell
Title: Getting Started with SSIS 2012
Abstract:
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
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
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.