The PASS Business Intelligence and Data Warehousing Virtual Chapter serves to connect BI professionals globally over ongoing webinars.
Next Meeting

Tue, Nov 19 2013 17:00 (GMT-07:00) Mountain Time (US & Canada)

Data Vault Data Warehouse Architecture


Data Vault Data Warehouse Architecture

Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2012. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session Leslie and I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2012 help make your data warehouse solution provide maximum value to your users.

Jeff Renz is a Consultant at Revgen Partners currently working as the tech lead on a project for a Fortune Top 50 company. He is designing a reporting data mart that will integrate data from multiple sources using SSIS 2012. Jeff has worked with SQL Server and BI for 15+ years and has 10 years’ experience with data warehouse design and implementation. He received his bachelor’s degree in Computer Science and his master’s degree in Operations Research from Colorado School of Mines.


Web: | Twitter: @PASSBIVC | Email:



PASS Business Analytics Conference


The World of Data is Changing 
- Stay Ahead of the Curve -

There’s never been a more exciting time for data professionals as more organizations turn to data-driven insights to stay ahead. But staying up to speed in this rapidly changing data landscape is a challenge.

The conference brings together analysts  from the world of analytics to connect, share experiences, and learn more about the power of data to transform business.

With more than 65 sessions by the world’s top BI and BA experts, you'll walk away with real-world insights, best practices, prescriptive guidance and strategic vision.

April2014 Upcoming Sessions


Monday 28 Apr 2014 11 AM PDT / 2 PM EDT / 7 PM GMT  - Tuesday 29 Apr 2014 6 AM NZST

The Power Query Formula Language

Speakers: Matt Masson & Theresa Palmer 

Registration URL:

Microsoft Power Query for Excel includes a powerful query engine and a formula language that enables self-service data integration and shaping over a diverse set of data sources, ranging from simple text files to Big Data and Hadoop. In this session, we will go beneath the UI and learn how to unlock the full power of the underlying query engine and the formula language. You will learn how to conquer your data and data-shaping needs. 

Matt Masson & Theresa Palmer 


Matt Masson is a Program Manager on the Power Query team. Matt has worked with multiple products across SQL Server, including SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS), and the Data Management Gateway for the Power BI release. He has authored two books – SSIS Design Patterns (Apress) and SQL Server 2012 Integration Services (MS Press), and is a frequent presenter at SQL conferences. You can find his blog at 

Theresa Palmer is a Program Manager in the Microsoft SQL Server Information Services Group. She is currently working on Microsoft Power Query for Excel, which offers end user experiences around data discovery, data consumption, and data mashups.

Check your Timezone by clicking here, or use our handy list below

New York - 28 Apr 2014 02:00 PM 
London - 28 Apr 20414 07:00 PM 
Sydney - 29 Apr 2014 04:00 AM 
Auckland - 29 Apr 2014 06:00 AM 

May 2014 Upcoming Sessions


Friday 9 May 2014 1 PM AEST / 4 AM GMT  - Thursday 8 May 2014 8 PM PST / 11 PM EST

Leveraging SQL Spatial Analytics for Making Business Decisions

Speaker: Rolf Tesmer 

Registration URL:

Imagine the possibilities if you were able to gather real-time insight into the traffic flow, patterns and behaviors of people while within your premises. Wi-Fi Location Analytics solutions leverage WiFi infrastructure to make this possible by capturing high volume real-time spatial positioning data from mobile devices. The spatial data is extracted, transformed and analysed in SQL Server to provide location based mobility services (such as tracking, mapping and way-finding)This session discusses how these Big Data solutions work and demonstrates data consumption via SQL 2012 spatial (direction, distance, speed, proximity), SSRS 2012 custom maps, and Excel Power View. 

Rolf Tesmer 
Rolf has 18 years IT experience with more than 15 years across all facets of SQL Server/Windows BI platforms, operating in both freelance consulting roles and within large multi-nationals, including Dimension Data, BHP Biliton, Honda and Australia Post.Rolf’s SQL experience covers SQL architecture/design, business intelligence (BI), disaster recovery (DR), performance management, security and compliance, consolidation/strategy and virtualisation. 

Check your Timezone by clicking here, or use our handy list below

New York - 8 May 2014 11:00 PM 
Los Angeles - 8 May 20414 08:00 PM 
Sydney - 9 May 2014 01:00 PM 
Auckland - 9 May 2014 03:00 PM 

Usage of R in SQL Server for better data understanding


Speaker: Tomaž Kaštrun

Registration URL:

Tuesday 13th May 8PM Central European Time 2014 11 AM PDT / 2 PM EDT / 7 PM GMT  - Wednesday 14th May 2014 6 AM NZST

Language R for Statistical computing is powerful language for data analysis with all great features for data import from SQL environment. 

Using R with SQL server data will help data scientists and data analysts prepare, explore and validate data much easier, as well as to use wide range of statistics; from univariate to multivariate. 

Session will focus mainly on: 
1) on connecting R Language with SQL server using standard ODBC connectors and T-SQL procedures. 
2) how to validate data with using classical statistical methods on SQL transactional data. 
3) how to use R output in SSRS and bring extra information to reports. 

Tomaž Kaštrun

Tomaž Kaštrun is BI developer who focuses mainly on data mining, data quality and programming in SQL and .NET. He has been working with SQL Server since version 2000.


Check your Timezone by clicking here, or use our handy list below


New York - 13 May 2014 14:00 PM 
London - 13 May 2014 19:00 PM 
Sydney - 14 May 2014 04:00 AM 
Auckland - 14 May 2014 06:00 AM