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: @PASSBIVC | Email: PASSDWBIVC@sqlpass.org

 

 

 

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.

 

 

July 2014 Upcoming Sessions


Tuesday 8 Jul 2014 11AM PDT / 7 PM GMT

ETL: Avoiding Costly Mistakes

Speaker: Rafael Salas

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

Data integration can be the most expensive part and largest point of failure of a data warehouse project. But, do you know why? Or better yet, do you know what you can do to reduce risk and increase your success rate? 

This session will outline the most common and costly mistakes made when designing and building data integration processes. The aim is to provide you with a list of recommendations and actionable steps that will save you money and time. You can use this list as reference in your projects to ensure that ETL processes are equipped with a robust foundation a solid data integration system must have. After attending this presentation, you will gain a perspective that goes beyond merely moving data. You will have a well-rounded understanding of ETL architecture key concepts 

Rafael Salas
Rafael is a recognized speaker, published author and blogger with more than 15 years of experience across multiple industries. He specializes in Business Intelligence and information architecture and is the recipient of multiple industry awards, including Microsoft Most Valuable Professional and The Data Warehouse Institute best practices as recognition for his expertise and high quality of the solutions he and his team have built. His Areas of expertise include data integration, data quality, data warehouse architecture, analytics. Rafael is also an active member in the SQL Server technical community and maintains a blog at www.rafael-salas.com

Timezone

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

Los Angeles - Tuesday, 8 July 2014 at 11:00:00 a.m 
New York - Tuesday, 8 July 2014 at 2:00:00 p.m 
London - Tuesday, 8 July 2014 at 7:00:00 p.m 
Sydney - Wednesday, 9 July 2014 at 4:00:00 a.m 
Auckland - Wednesday, 9 July 2014 at 6:00:00 a.m 

 

Friday 18th July 2014 10.30AM BST / 7 :30 pm AEST

A One Hour Data Analysts Toolkit: using R and PowerBI

Speaker: Jen Stirrup

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


If you want to conduct advanced, business-oriented Business Intelligence development and Business Analysis, then it is useful to understand data visualisation and have R as a tool in your toolset. In this intensive one hour session, we will look at the latest suite of Microsoft Business Intelligence tools - Microsoft Power BI in conjunction with R. The demos will be implemented in both tools in an end-to-end hour long session so that delegates can see when to use each technology in order to determine 'what to use' and 'when to use it', as well as seeing where the technologies complement each other. We will visualise the data according to data visualisation principles set out by Stephen Few amongst others. 

Jen Stirrup

Jen Stirrup is an award-winning, world recognised Business Intelligence and Data Visualisation expert, author, data strategist, MVP, and technical community advocate who is repeatedly honoured with peer recognition as one of the top 100 most global influential tweeters on Big Data topics. Jen has over 16 years experience in delivering BI and dataviz projects for companies of various sizes around the world. Jen is an elected member of the Board of Directors for the Professional Association of SQL Server, holding the seat for Europe and holder of the Virtual Chapters portfolio worldwide. Jen has presented at TechEd North America and Europe, Summit, SQLBits, as well as at SQLSaturday and other SQL events in the UK, in the US and on many occasions across Europe such as Hungary, France, Belgium, Germany, Portugal, Poland, Sweden, Norway, Switzerland, Ireland, Denmark, Bulgaria, Austria and the Netherlands. Therefore she works hard! She has proven evidence of being extremely involved in the SQL Community across the UK, Europe and the US, and has been for a number of years now. She has also presented preconference sessions in Microsoft Business Intelligence and Data Visualisation for SQLPass, SQLSummit and at various countries around Europe. When she is not working for the SQLFamily, Jen jointly runs a Copper Blue Consulting based in Hertfordshire with Allan Mitchell, where they helps business leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investment both here in the UK, Europe and the US, and more recently in Africa. Jen has also won awards for her blog and community work, most notably from SQLServiaPedia as runner-up for best Business Intelligence blog. She is a former Awardee of PASS's prestigious PASSion Award in 2012. 

Timezone

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

Seattle - Friday 18th July 2014 at 2:30 a.m 
New York - Friday 18th July 2014 at 5:30 a.m 
London - Friday 18th July 2014 at 10:30 a.m 
Sydney - Friday 18th July at 07:30 p.m 
Auckland - Friday 18th July at 09:30 p.m


Tuesday 29 Jul 2014 Noon PDT / 3 PM EDT / 7 PM GMT

Analysis Services: Multidimensional vs Tabular

Speaker: Jessica Moss

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

 

The difference between Analysis Services Multidimensional versus Analysis Service Tabular can be difficult to understand for both new and seasoned Microsoft business intelligence developers. However, this understanding helps you to pick the model type that will provide the best possible solution for your end users. This session will describe each model type, list the pros and cons of each model type, and show developer and end user functionality for both model types. After this session, you will be able to successfully pick the right Analysis Services model type for you. 


Jessica M. Moss 

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence. Jessica's expertise includes dimensional modeling, ETLs, semantic modeling, report design, and helping customers across industries successfully implement and enhance their business intelligence solutions. Jessica enjoys sharing her knowledge with the central Virginia community, speaks regularly at user groups, code camps, and conferences, and has co-authored six technical books

Timezone

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

Los Angeles - Tuesday, 29 July 2014 at Noon PDT 
New York - Tuesday, 29 July 2014 at 3:00:00 p.m 
London - Tuesday, 8 July 2014 at 8:00:00 p.m 
Sydney - Wednesday, 9 July 2014 at 4:00:00 a.m 
Auckland - Wednesday, 9 July 2014 at 6:00:00 a.m