sqlsathistory

Nr: 86

Back to Main list

SQLSaturday #86 - Tampa BI Edition 2011

Start Time (24h) Speaker Track Title
00:00:00 Adam Jorgensen Analysis BI with SharePoint 2010 and Performance Point
00:00:00 Adam Jorgensen Analysis Analysis - 0 to SSAS
00:00:00 Andy Warren xMisc - Prof Dev, DBA, Powershell Building a Professional Development Plan
00:00:00 Angel Abundez Presentation Unleash the Tablix
00:00:00 Bradley Ball xMisc - Prof Dev, DBA, Powershell Page and Row Compression How, When, and Why
00:00:00 Brian Mitchell ETL Applying FastTrack PDW Best Practices to your DW
00:00:00 Chris Albrektson Presentation Introduction to SSRS Dashboards
00:00:00 Dustin Ryan Presentation Reporting on a Cube with SSRS 2008
00:00:00 Daniel Taylor xMisc - Prof Dev, DBA, Powershell Useful tools SSMS TipsTricks for DBA Developer
00:00:00 Joe Celko ETL Nested Sets model for Trees Hierarchies
00:00:00 Joe Celko ETL Modeling Time in SQL
00:00:00 Jose Chinchilla xMisc - Prof Dev, DBA, Powershell SQLServer 2012 PowerView "Crescent" Dashboards
00:00:00 Jen Underwood Analysis What's New for Business Intelligence in "Denali"
00:00:00 James McAuliffe ETL SSIShare The Code, Man
00:00:00 James McAuliffe ETL Lookup Between The Lines is Data Late Than Never
00:00:00 John Welch ETL Do You Know the Data Flow?
00:00:00 John Welch ETL Do More (ETL) with Less (Effort) - Automating SSIS
00:00:00 John Welch Analysis Tuning Analysis Services Processing Performance
00:00:00 John Welch ETL Handling Advanced Data Warehouse Scenarios in SSIS
00:00:00 Richie Rump xMisc - Prof Dev, DBA, Powershell Intro to Project Management for BI Professionals
00:00:00 Juan Soto Analysis Using MS Access as a BI Tool with SQL Server
00:00:00 Marc Miller Analysis BI in the Cloud
00:00:00 Maximo Trinidad xMisc - Prof Dev, DBA, Powershell SSIS - Analyzing your data integrating PowerShell
00:00:00 Michael Hinckley Presentation BI to SharePoint and vice versa
00:00:00 Michael Antonovich Presentation SQL - External Data Source for SharePoint Office
00:00:00 Melissa Coates Presentation Dashboards...How to Choose Which MSBI Tool?
00:00:00 Rob Collie Analysis PowerPivot: BI Massive Data Analysis for Humans
00:00:00 Phillip E Rosen Presentation Biz Intel Dashboards W/Excel OLAP formulas
00:00:00 Sanjay Soni Presentation Delivering BI to the masses at Microsoft
00:00:00 Mark Tabladillo Analysis Data Mining with Excel 2010 and PowerPivot
00:00:00 Mark Tabladillo xMisc - Prof Dev, DBA, Powershell Social Marketing 2011 for Microsoft Professionals
00:00:00 Todd Davis xMisc - Prof Dev, DBA, Powershell SELECT job FROM firm WHERE hired = 'Yes'

SessionID: 28526

BI with SharePoint 2010 and Performance Point

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Analysis

Speaker: Adam Jorgensen

Title: BI with SharePoint 2010 and Performance Point

Abstract:

What’s the use of having business intelligence if you can’t make it actionable? In this session you’ll learn how to better collaborate with SharePoint 2010 and Microsoft’s BI suite. You’ll learn how Performance Point can help you develop scorecards and aid your users in answering questions they didn’t even know they had.

SessionID: 28528

Analysis - 0 to SSAS

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Analysis

Speaker: Adam Jorgensen

Title: Analysis - 0 to SSAS

Abstract:

In this session, the attendees will learn how to drive and build an Analysis Services cube and reports as they rotate through the podium as volunteers.

SessionID: 28702

Building a Professional Development Plan

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: xMisc - Prof Dev, DBA, Powershell

Speaker: Andy Warren

Title: Building a Professional Development Plan

Abstract:

A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.

SessionID: 28733

Unleash the Tablix

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Presentation

Speaker: Angel Abundez

Title: Unleash the Tablix

Abstract:

Tablix = Table + Matrix. Got it? Good. But wait, what exactly is a Tablix good for then? And where is it in your SSRS Toolbox? Not to worry. Angel will show you how to wake up the Tablix control introduced in SQL Server 2008 R2 using some real-world examples. In this session, you’ll learn why the Tablix features help solve many common reporting scenarios such as Timelining, Summarizing, and Subtotaling. Important takeaways from this session are how to aggregate everywhere in your Tablix with single formulas and condensing very wide reports. We’ll also cover some visualization reporting techniques to help solve some pretty common reporting requests such as Exporting to Excel. Please welcome: Table, Matrix, and List.

SessionID: 29136

Page and Row Compression How, When, and Why

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: xMisc - Prof Dev, DBA, Powershell

Speaker: Bradley Ball

Title: Page and Row Compression How, When, and Why

Abstract:

Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page Row with SQL 2008 RTM, and Page Row with Unicode Compression with SQL 2008 R2. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead.

SessionID: 29262

Applying FastTrack PDW Best Practices to your DW

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: ETL

Speaker: Brian Mitchell

Title: Applying FastTrack PDW Best Practices to your DW

Abstract:

SQL Server 2008 R2 Fast Track Data Warehouse and SQL Server 2008 R2 Parallel Data Warehouse share many of the same design components and best practice recommendations. We will discuss what those designs are and how you can apply those to your data warehouse. Additionally, we will walk through things you can do today to improve the performance of your data warehouse.

SessionID: 29374

Introduction to SSRS Dashboards

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Presentation

Speaker: Chris Albrektson

Title: Introduction to SSRS Dashboards

Abstract:

In this session, learn how to quickly build visually appealing dashboards for your organization in SSRS using the features in SQL 2008 R2. Chris will show you how to use the indicator’s, spark lines, maps and some best practices when designing dashboards.

SessionID: 30022

Reporting on a Cube with SSRS 2008

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Presentation

Speaker: Dustin Ryan

Title: Reporting on a Cube with SSRS 2008

Abstract:

In this session Dustin will give you an introduction to reporting on a cube with SQL Server Reporting Services (SSRS). You’ll learn about some of the advantages of using your cube as a source for your SSRS reports, how to build reports based on your cube with minimal knowledge of MDX, as well as a few tricks you can use to increase the usability of your reports.

SessionID: 30024

Useful tools SSMS TipsTricks for DBA Developer

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: xMisc - Prof Dev, DBA, Powershell

Speaker: Daniel Taylor

Title: Useful tools SSMS TipsTricks for DBA Developer

Abstract:

Justlike any good tradesman understanding your tools is keyto getting the job done accurately and timely. Are you Database Developer orDBA? If so are you familiar with the out of the box tools provide to us byMicrosoft? During this session I will walk thru some of the SSMS tools I finduseful and help me get the job done in an accurate and timely manner. We willalso walk thru some of the tools shared with the development teams which theyhave found useful to complete their daily tasks.

SessionID: 30574

Nested Sets model for Trees Hierarchies

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: ETL

Speaker: Joe Celko

Title: Nested Sets model for Trees Hierarchies

Abstract:

Techniques that use the Nested sets model. Tyhis is aimed at the new SQL progammer who does not know this idiom.

  1. Problems with the adjacency list model
  2. Insertion, deletion
  3. Roll up aggregation
  4. Basic queries

SessionID: 30575

Modeling Time in SQL

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: ETL

Speaker: Joe Celko

Title: Modeling Time in SQL

Abstract:

An intro to basic temporal modeling of events

  1. The nature of time
  2. begin-end time pairs; durations
  3. CHECK() and REFERENCES constriants for integrity
  4. Report Period tables - date ranges, hourly ranges

SessionID: 30611

SQLServer 2012 PowerView "Crescent" Dashboards

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: xMisc - Prof Dev, DBA, Powershell

Speaker: Jose Chinchilla

Title: SQLServer 2012 PowerView "Crescent" Dashboards

Abstract:

SQL Server 2012 formerly codename "Denali" will include a new interactiveand powerful reporting tool called PowerView, formerly codename "Project Crescent". In this session Jose will overview PowerView and showcase how to create a rich and interactive dashboard that will knock your socks off!

SessionID: 30722

What's New for Business Intelligence in "Denali"

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Analysis

Speaker: Jen Underwood

Title: What's New for Business Intelligence in "Denali"

Abstract:

This session will cover SSIS, SSRS, SSAS, PowerPivot, BISM and Crescent. We will walk through high level overviews of new features in SSIS, SSRS, SSAS and take a deeper look at improvements in PowerPivot, the new Business Intelligence Semantic Model and new Project Crescent for ad-hoc reporting.

SessionID: 30864

SSIShare The Code, Man

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: ETL

Speaker: James McAuliffe

Title: SSIShare The Code, Man

Abstract:

For many SSIS scenarios, a desired outcome is to implement logic or rules that are already in use in existing enterprise applications. The only significant difference is that the implementation is done in a bulk data loading scenario. Many times the logic being applied is complex and multi-step. Many times enterprises have proprietary rules systems that need consistent application throughout the code base. We will examine a scenario where complex logic from shared code sources can be applied in SSIS processing.

SessionID: 30866

Lookup Between The Lines is Data Late Than Never

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: ETL

Speaker: James McAuliffe

Title: Lookup Between The Lines is Data Late Than Never

Abstract:

Fully cached lookups are GREAT for performance in ETL processing. These types of lookups use a query to pull a limited data set into the SSIS memory cache. Then, in processing, a exact match is made on lookup values to provide the match lookup value. However, what if you need to match on more than on value, or use BETWEEN type lookups? This is possible, and this session will examine some solutions. Also, we will talk about making allowances for missing data when running ETL processes, strategies for late arriving dimensions and late arriving facts.

SessionID: 30985

Do You Know the Data Flow?

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: ETL

Speaker: John Welch

Title: Do You Know the Data Flow?

Abstract:

The Data Flow task is one of the most powerful and most complex tools available in SSIS. Whether you are brand new to SSIS, or you’ve been using it for a while, it’s likely you’ve had some questions about the Data Flow. Why are some components so much slower than others? Why can’t I store a value (like a row count) in one component, and use it in another component later in the Data Flow? And why does it always seem to be the part of my package that fails when I run it against real data? Well, you’re not alone. During this session, we’ll answer these questions (and many others) by learning how the Data Flow operates internally. After attending this session, you’ll know a lot more about getting the most out of Data Flows in SSIS.

SessionID: 30986

Do More (ETL) with Less (Effort) - Automating SSIS

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: ETL

Speaker: John Welch

Title: Do More (ETL) with Less (Effort) - Automating SSIS

Abstract:

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks or packages that adhere to a pattern, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options.

SessionID: 30987

Tuning Analysis Services Processing Performance

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Analysis

Speaker: John Welch

Title: Tuning Analysis Services Processing Performance

Abstract:

You’ve got your Analysis Services cube created, and deployed in production. However, you notice that every night, the cube is taking longer and longer to process, and users are starting to complain about their data not being ready when they arrive in the morning. If you’ve found yourself in this situation, or want to avoid being in it in the first place, come to this session. We’ll cover how to benchmark processing performance, track down bottlenecks, and how to tune things to get the best performance for processing your cube.

SessionID: 30989

Handling Advanced Data Warehouse Scenarios in SSIS

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: ETL

Speaker: John Welch

Title: Handling Advanced Data Warehouse Scenarios in SSIS

Abstract:

So you’ve used SSIS to populate a simple star schema data mart, and everybody’s happy. But now you have new requirements that require more advanced data warehouse approaches, like late arriving dimensions, bridge tables, parent child dimensions, and Type 3 or Type 6 slowly changing dimensions (SCD). How do you handle those in a scalable, efficient way in SSIS? This session will present some common patterns for handling these scenarios. You’ll learn when to use each advanced approach and the pros and cons associated with each pattern. You will learn how to implement these patterns in SSIS, and how to tune them for high performance.

SessionID: 31045

Intro to Project Management for BI Professionals

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: xMisc - Prof Dev, DBA, Powershell

Speaker: Richie Rump

Title: Intro to Project Management for BI Professionals

Abstract:

The IT industry isnow being dominated by projects. This session is designed to present ahigh-level foundational knowledge of the project management process. It willalso focus on the tools that BI professionals can use to deliver projects ontime and on budget.

SessionID: 31089

Using MS Access as a BI Tool with SQL Server

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Analysis

Speaker: Juan Soto

Title: Using MS Access as a BI Tool with SQL Server

Abstract:

Access is a wonderful BI analysis tool. It allows users to leverage the native capabilities for Crosstab queries along with some powerful UI mechanisms to provide a rich BI environment. In this session I'll be using VBA and SQL Server to extend the tools even further:

We will cover three topics: Creating a Access dashboard using a SQL Server stored procedure; creating a Crosstab analysis with subtotals in table format and creating a flexible Crosstab analysis using Access's Crosstab table form. You will walk away with new methods to do BI analysis using the World's most popular desktop database.

SessionID: 31544

BI in the Cloud

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Analysis

Speaker: Marc Miller

Title: BI in the Cloud

Abstract:

In this session we will take a look at some strategies for building Business Intelligence solutions on the Windows Azure platform. We'll see methods for transferring on-premises data to the cloud, report deployment to Windows Azure Reporting Services and options for performing ad-hoc analysis. We'll look at some of the challenges faced when moving BI into the cloud, such as high-performance ETL, schema management and transient fault handling.

SessionID: 31632

SSIS - Analyzing your data integrating PowerShell

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: xMisc - Prof Dev, DBA, Powershell

Speaker: Maximo Trinidad

Title: SSIS - Analyzing your data integrating PowerShell

Abstract:

This is a sample of buidling an SSIS solution to assist in analysing data been rejected by the Import process. Then, we integrate a PowerShell application to consolidate this rejected records building a dynamic table to view these data. I will be covering the use of Script_Task and Script_Components. Also, creation of variables and how to pass parameters to a PowerShell application. This is a good example for all BI interested in how to use PowerShell in their ETL process.

SessionID: 31727

BI to SharePoint and vice versa

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Presentation

Speaker: Michael Hinckley

Title: BI to SharePoint and vice versa

Abstract:

BI the final frontier, these are the voyages of a Business Analyst/PM/IT Pro Lite as he navigates the BI to SharePoint Universe. This session is an overview of the various BI solutions within SharePoint highlighting the scopes of each and who and what it takes to get them deployed. Starting with Excel, PowerPivot, Performance Point and InfoPath Services. SharePoint is quickly becoming THE intranet platform for businesses. No matter what your area of expertise is sooner or later it will end up on, in or for SharePoint.

SessionID: 31807

SQL - External Data Source for SharePoint Office

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Presentation

Speaker: Michael Antonovich

Title: SQL - External Data Source for SharePoint Office

Abstract:

In this session, we will examine how to create connections to an external data source (SQL Server) using SharePoint Designer. Once the External Data Content Type exists, we can display and manipulate the data within SharePoint using an External List. But you will see in this session that you can also surface the data to Outlook and use the data in a disconnected mode. You will also see how to use external data sources within a Word document template with the assistance of QuickParts. The final demonstration (time permitting) shows how you can use the external data in an InfoPath form.

SessionID: 31933

Dashboards...How to Choose Which MSBI Tool?

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Presentation

Speaker: Melissa Coates

Title: Dashboards...How to Choose Which MSBI Tool?

Abstract:

The Microsoft BI stack has a few choices for visualization. We will explore options, flexibility, limitations, and ease of use for creating dashboards scorecards with:

This session will be a fun one! We will compare and contrast options available in each tool, such as: charts, gauges, maps, indicators, sparklines, data bars, and decomposition trees. The goal is to determine when you might choose one tool in the Microsoft BI stack versus another.

SessionID: 32550

PowerPivot: BI Massive Data Analysis for Humans

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Analysis

Speaker: Rob Collie

Title: PowerPivot: BI Massive Data Analysis for Humans

Abstract:

The paradox of Business Intelligence: it's one of the few tech sectors that actually grows during recessions, and yet, satisfaction levels with BI investments remain on average quite poor. Also, BI remains the domain of specialists, off-limits to most of us. Why do these conditions persist when the funding, and therefore the business need, only continues to grow? In this session I will demonstrate how PowerPivot is opening the world of BI to a broader audience ( range of applications). The only prereqs: curiosity, and fondness for numbers :) I will explain how PowerPivot impacts benefits you depending on role (analyst, DBA, BI Pro, etc.), show off its capabilities in real-world usage, and field as many q's as you can muster :)

SessionID: 32649

Biz Intel Dashboards W/Excel OLAP formulas

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Presentation

Speaker: Phillip E Rosen

Title: Biz Intel Dashboards W/Excel OLAP formulas

Abstract:

I will demonstrate how to develop MS Excel BI Dashboards in the following ways: 1. Workbook style with Office data connections stored on local PC or networked document drive. 2. excel services style using Reports Library SP 2007 for storage of the Office data connections workbook that excel services will render. 3. Convert excel pivot table into excel OLAP formulas. 4. Discuss SP 2010 BI Center. Attendees will understand and be able to create BI dashboard workbooks with excel 2007 which are connected to SSAS data cubes via ODC and store the ODC on local PC/data connections folder. Convert excel pivot table into excel OLAP formulas for use in BI dashboard grids and charts

SessionID: 32779

Delivering BI to the masses at Microsoft

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Presentation

Speaker: Sanjay Soni

Title: Delivering BI to the masses at Microsoft

Abstract:

See live demos of how BI is being delivered to the masses (39,600+ users globally) at Microsoft using SharePoint, Excel, PerformancePoint, SQL Server and other Microsoft BI products. Learn about Microsoft's Consolidated Business Intelligence framework, a successful BI story, 6 years in the making. We will showcase and share technical details and best practices on how Microsoft IT was able to consolidate 100+ applications from 50+ business organizations in a single enterprise report catalog and a BI portal. Learn best practices and technical details on how to implement large scale self-service Business Intelligence systems in your organization.

SessionID: 33108

Data Mining with Excel 2010 and PowerPivot

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Analysis

Speaker: Mark Tabladillo

Title: Data Mining with Excel 2010 and PowerPivot

Abstract:

Excel 2010 provides a world-class platform for enterprise decision making. This presentation introduces the decision-making ability possible with the free Excel add-ins for PowerPivot and SQL Server Data Mining. The data mining is a service hosted in Microsoft's Analysis Services, but the Excel add-in exposes the enterprise-strength server technology to analysts and executives. This talk introduces some functions from the "Analyze" and “Data Mining” tabs, including data mining model creation from Excel data. Having seen this presentation some had thought it was all Excel since the functions seem so seamless. The Excel interface provides a familiar way for professionals to make actionable decisions.

SessionID: 33109

Social Marketing 2011 for Microsoft Professionals

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: xMisc - Prof Dev, DBA, Powershell

Speaker: Mark Tabladillo

Title: Social Marketing 2011 for Microsoft Professionals

Abstract:

Developing a social media platform is a challenge for high-end professionals and consultants. The presenter has successfully leveraged web media to establish a blog (http://marktab.net), cofound an online journal (http://solidq.com/sqj), become a paid video presenter, secured a spot at Microsoft TechEd 2011, and earned credit toward his first Microsoft MVP. This presentation introduces the basic elements for 2011 of a successful web strategy, starting with discovering your own best personal focus given current market needs. The presenter includes experiences with website development, WordPress blog hosting, leveraging social media services (including Twitter, Linked in, YouTube and Facebook), and working with Microsoft.

SessionID: 33320

SELECT job FROM firm WHERE hired = 'Yes'

Back to calendar

Event Date: 05-11-2011 - Session time: 00:00:00 - Track: xMisc - Prof Dev, DBA, Powershell

Speaker: Todd Davis

Title: SELECT job FROM firm WHERE hired = 'Yes'

Abstract:

Find out what hiring managers really want to see throughout the hiring process. This session will walk through the basics that every successful candidate should know: Resume tips, Job search and Interview tips. Yes, recruiters and hiring managers view your LinkedIn page; but, did you realize they also view your twitter account, your blog, your Facebook and that webpage you designed freshman year in college? If you are in a job search, considering one or just want to be prepared for one, then this session will be a great opportunity to find out what "they" are really looking for.