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

Wed, Oct 30 2013 12:00 AUS Eastern Daylight Time


Data Lineage using SSIS, SSAS and Power Pivot

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

Data Lineage using SSIS, SSAS and Power Pivot

Data Lineage is the concept of enabling a client ability to analyze data in a NEW way yet still be able to see the original values, critical in Big Data. Ira Warren Whiteside and Victoria Stasiewicz will demonstrate how to do this in SSIS AND SSAS using Power Pivot, Power BI ,Office 365 and Power Query. We have several case studies for our current clients.


Ira has over 40 years of IT experience and has extensive knowledge of data warehousing. His roles have included management, Technical Team Lead, Business Analysis, Analytical Application Development, Data Warehousing Architecture, Data Modeling, Data Profiling, Data Mining, Text Mining, E-Commerce Implementation, Project Management, Decision Support/OLAP, Financial Application Development, E-Commerce, B2C, B2B with primary emphasis in Business Intelligence Applications and Data Warehousing Management. Mr. Whiteside has managed multi-million dollar projects from start to completion. His experience includes the planning, budgeting, project management/technical leadership and product management for large projects and software companies. In addition, Mr. Whiteside has been hands on, in that he has extensively used Microsoft SQL Server 2005/2012 tools, including SSIS, SSAS, SSRS (Microsoft Reporting Services) and Data mining. In addition Ira has authored and published various white papers, articles, provided numerous training seminars and presentations on the methodology required for data-driven application cogeneration in the Microsoft stack.

 

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.

 

 

August 2014 Upcoming Sessions


Friday 15 Aug 2014 11 AM PDT / 2 PM EDT / 7 PM GMT

Continuous Integration for Reporting Services

Speaker: Nat Sundar

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

Developing a Report with Reporting Services is easy. But how can we deliver consistent and bug free Report in a short turnaround. Continuous Integration help us to Build, Unit Test and Deploy the components as we develop. It helps the Developers, DBAs, Test Engineers and the Release Managers. 

Continuous Integration: 

With the help of CI tools , we can build the Report files (.RDL) from Source control (Perforce, SVN, etc). However writing Unit test cases for Reports requires little thoughts. Once the test development has completed, this also need to be build and integrated with the CI tools for automatic runs. 

Also the Reports, Datasets and the Datasources have to be deployed to a Test environment. With the help of CI tools the deployment process can be automated as well. 

In this Demo Rich session, I will walkthrough the best practices around the Development, Build, Unit Test case and Deployment. 

Nat Sundar

Nat Sundar is an independent SQL BI consultant working in the UK. He has considerable years of experience with the UK Financial Services Industry (Mainly in Insurance and Investment Banking). 

He is passionate in SQL Server, SSIS, SSAS, SSRS and MDX. 

Linked-In Profile: http://uk.linkedin.com/pub/nat-sundar/58/a87/842

Timezone

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

Los Angeles - Friday, 15 Aug 2014 at 11:00:00 a.m 
New York - Friday, 15 Aug 2014 at 2:00:00 p.m 
London - Friday, 15 Aug 2014 at 7:00:00 p.m 
Sydney - Saturday, 16 Aug 2014 at 4:00:00 a.m 
Auckland - Saturday, 16 Aug 2014 at 6:00:00 a.m 

 

Wednesday 27 Aug 2014 Noon BST / 9 PM AEST

Intro to R

Speaker: Stephanie Locke

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

R, the statistical programming language, is another open-source program making inroads into the Microsoft world. 

R was originally for doing stats, but it now does database CRUD, reporting, documentation, and even websites. It can be awkward to know where to start, so this session fast tracks you to the sections you need to know about to save yourself pains you didn't even know you had. 

Stephanie Locke 

Stephanie Locke (@SteffLocke) is an experienced Analyst and BI developer within the Finance and Insurance industries. Steph runs her local SQL Server User Group, helps organise SQLRelay, co-author of the book Tribal SQL and contributes to the community at large via blogging, presenting and forums. 

Timezone

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

Seattle - Wednesday, 27 Aug 2014 at 4:00 a.m 
New York - Wednesday, 27 Aug 2014 at 7:00 a.m 
London - Wednesday, 27 Aug 2014 at Noon 
Sydney - Wednesday, 27 Aug at 9:00 p.m 
Auckland - Wednesday, 27 Aug at 11:00 p.m