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

Fri, Feb 22 2013 11:00 (GMT-05:00) Eastern Time (US & Canada)


Hacking the SSIS 2012 Catalog

RSVP: None

SSIS 2012 Catalog

Andy Leonard is CSO of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SQL Server MVP Deep Dives, Volume 2 and SSIS Design Patterns. His background includes VB and web application architecture and development; and SQL Server 2000-2012.


Andy Leonard is a consultant and trainer with Linchpin People, LLC. He is active in the SQL Server community, co-CSO of SQLPeople.net, and co-author of several books on SQL Server and Integration Services.

 

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.

 

 

September 2014 Upcoming Sessions



Wednesday 17 Sep 2014 4 PM EDT / 1 PM PDT / 9 PM BST / Thursday 18 Sep 2014 6 AM AEST / 8 AM NZST

Absolute beginners presentation for Power BI for Office 365

Speaker: Kevin S Goff

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

As the title states, this is an absolute beginner’s presentation. I actually create a brand new Power BI site, completely from scratch, then provision it, set up a gateway, and then create a few basic examples. The objective isn’t to show off all the cool visualizations in PowerView and PowerPivot, it’s more to show the core mechanics of creating a site, pushing up content, and setting up a refresh through the gateway. The presentation is intended to show to brand new people that it’s really not that difficult. At the conclusion I’ll talk about some of the new features coming down the pike soon for Power BI. 



Kevin S. Goff (www.KevinSGoff.net) 


* SQL Server MVP since 2010 (was a C#/.NET MVP from 2005-2009) 

* SQL Server/Business Intelligence architect/developer/speaker/instructor/author 

* CoDe Magazine Columnist from 2004-2013 on .NET and SQL Server/BI Topics 

* Frequent speaker at community events in the Mid-Atlantic region, and regular speaker for the SQL Live!360 Conference Brand 

* Created 13-week SQL Server 2012 webcast series for Microsoft TechNet Radio 


Timezone

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

Los Angeles - Wednesday, 17 Sep 2014 at 1:00 p.m 

New York - Wednesday, 17 Sep 2014 at 4:00 p.m 

London - Wednesday, 17 Sep  2014 at 9:00 p.m 

Sydney - Thursday, 18 Sep 2014 at 6:00 a.m 

Auckland - Thursday, 18 Sep 2014 at 8:00 a.m 

 

Thursday 25 Sep 2014 7 AM PDT / 10 AM EDT / 3 PM BST

Using Power BI for Managing Personal Fitness

Speaker: Matthew Roche

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

In the summer of 2011, Matthew Roche joined the SQL Server team, moved his family across the country to Redmond. Over the next 15 months, inundated with the demands of a new role, move-related family stress, and an abundance of great food, Matthew managed to gain over 20 kilograms – and he realized that he needed to make a change. That change involved many healthy habits, but centered around weight training pushing his limits and abilities week after week. And of course, data and business intelligence were at the heart of how Matthew reversed his downward spiral and embarked on a fitness journey of epic proportions. 



In this session Matthew will present a custom solution for managing personal fitness data, implemented in Excel using Power Query, Power Pivot, and Power View. The session will focus on the real-world solution Matthew developed to measure and guide his fitness progress, including data sources, data modeling, and data visualization, and may or may not include shirtless progress photos. If you’re motivated by data, and want to see how you can reach your fitness goals while letting Excel do the heavy lifting, this is the session you’ve been waiting for. 



Matthew Roche 


Matthew Roche is a Senior Program Manager on the Cloud & Enterprise team at Microsoft, working on Self-Service Information Management (SSIM) in Power BI and related hybrid cloud efforts. Matthew has previously worked Enterprise Information Management (EIM) tools including SQL Server Integration Services (SSIS), Master Data Services (MDS) and Data Quality Services (DQS). Before joining Microsoft in 2008, Matthew was a Business Intelligence consultant and trainer and a Microsoft SQL Server MVP.

Timezone

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

Seattle - Thursday, 25 Sep 2014 at 7:00 a.m 

New York - Thursday, 25 Sep  2014 at 10:00 a.m 

London - Thursday, 25 Sep 2014 at 3:00 p.m 

Sydney - Friday, 26 Sep 2014 at 0:00 a.m 

Auckland - Friday, 26 Sep 2014 at 02:00 a.m