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

Wed, Jul 24 2013 13:00 (GMT-08:00) Pacific Time (US & Canada)

SSIS: Effective Control Flow execution


Effective Control Flow execution with 7 different types of Foreach Loop Enumerator

Controlling execution of tasks in Control Flow tab of SSIS package can be much easier with getting help of Foreach Loop container. Foreach loop container provides ability to loop through items of a list. There are 7 types of enumerators for using in this Foreach loop, which provides wide range of lists to be used in loop structure. For example looping through array of items in a variable, or nodes and elements of an XML data, or looping through excel sheets, looping through SQL Server data objects.... In this session audience will learn about all 7 types of enumerators, and real world scenarios of using them in SSIS packages. One of the main benefits of loop structures are helping in creating dynamic task execution, for example dynamic data flow. In this session, there will be samples of creating dynamic data flows with help of Foreach Loop enumerators.

Reza Rad is an author, trainer, speaker, and consultant. He has been a Microsoft MVP in SQL Server for 4 years, specializing in Microsoft Business Intelligence and data movement. Reza has worked with Microsoft BI technologies more than 10 years. He is an MCP, an MCT, and leader of the New Zealand Business Intelligence Users Group. He has written several books about SQL Server BI and is currently working on others. You can find his technical articles on his blog at


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