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 Pacific Daylight Time


SSIS: Effective Control Flow execution

RSVP: https://attendee.gotowebinar.com/register/1504630336516349696

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 http://www.rad.pasfu.com.

 

Web: http://Bi.sqlpass.org | Twitter: @PASSBIVCEmail:  

 

 

PASS Summit 2014 Discount Code

The annual PASS Summit is taking place in Seattle, on Nov 4-7, 2014. If you have not registered, you can use PASS DW/BI VC discount code of VCSUM05 to get $150 off registration price. To register, please visit http://www.sqlpass.org/summit/2014/RegisterNow.aspx.

 

 

October 2014 Upcoming Sessions



Wednesday 15 Oct 2014 Noon CEST / 9 PM AEDT / 6 AM EDT

Risk Analysis Dashboard on a shoestring

Speaker: Johan Ludvig Brattås 

Registration URL: https://attendee.gotowebinar.com/register/8462303642921614850

Visualization is all the rage – with the focus on Self-Service BI, In-Memory technology and fancy graphics. Tableau, QlikView and Microsoft PowerBi are showing off the eye-candy, and managers like what they see. However, either these solutions cost a lot of money, or your organization is stuck on older versions of software that lacks the functionality needed. This session will show you how to make a cool dashboard using a database (MS SQL Server 2008), Excel 2010, and in addition how to prepare your solution for SQL2012 and the full PowerBI-suite with PowerPivot. 



Johan Ludvig Brattås 


Johan Ludvig is a business intelligence consultant who has been working with SQL Server since 2000. He mainly works with T-SQL, reporting and visualization. Johan Ludvig is a certified QlikView developer but is just as happy diiving into PowerView, R and all other sorts of technologies he can get his grubby little hands on.
Read less


Timezone

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

Los Angeles - Wednesday, 15 Oct 2014 at 3:00 a.m 
New York - Wednesday, 15 Sep 2014 at 6:00 a.m 
London - Wednesday, 15 Sep  2014 at 11:00 a.m 
Sydney - Wednesday, 15 Sep 2014 at 9:00 p.m 
Auckland - Wednesday, 15 Sep 2014 at 11:00 p.m 

 

Wednesday 22 Oct 2014 1 PM BST / 8 AM EDT

A Dive Into Data Quality Services

Speaker: Steve Simon

Registration URL: https://attendee.gotowebinar.com/register/6114236088244455682

Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has made with the advent of Data Quality Services, in the SQL Server 2012 release. In this hands-on presentation we shall be looking at how to set up a new knowledge base, based upon an existing one, set up rules, do knowledge discovery within the new knowledge base and finally cleanse the data through a data quality project. The end results being more effective data, guaranteed to keep end users and management happy. 


Steve Simon 


Steve Simon is a SQL Server MVP and is a senior BI Development Engineer with Atrion Networking Corporation in Providence RI USA. He has been involved with database design and analysis for over 29 years. Steve has presented papers at 8 PASS Summits and one at PASS Europe 2009 and 2010. He has recently presented a Master Data Services presentation at the PASS Amsterdam Rally and is a regular presenter at SQL Saturday’s in the USA and Canada. Steve has presented 5 papers at the Information Builders' Summits. He is a PASS regional mentor.

Timezone

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

Seattle - Wednesday, 22 Oct 2014 at 5:00 a.m
New York - Wednesday, 22 Oct  2014 at 8:00 a.m
London - Wednesday, 22 Oct 2014 at 1:00 p.m
Sydney - Wednesday, 22 Oct  2014 at 11:00 p.m
Auckland - Thursday, 23 Oct 2014 at 01:00 a.m