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 DW/BI VC

January 2015 Upcoming Sessions


Tuesday 27 Jan 2015 11:00 AM PST, 7:00 PM GMT / 28 Jan 2015 8:00 AM NZDT

SSIS Internals and Performance

Speaker: David Peter Hansen

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

You have worked with SQL Server Integration Service (SSIS) for a few years, but more often than not, you see performance problems with your packages. Some packages are running slow, while others are taking up more memory and CPU than before. In this session, you will learn the internals of SSIS and why having a deep understanding is important to solve performance problems. You will also learn how the control flow engine and data flow engine work, what the impact on performance buffers have, and how execution trees are related to parallelism.


David Peter Hansen
David Peter Hansen is Microsoft Certified Master (MCM) in SQL Server and works as Consulting Manager for Advectas Denmark. He has worked with database development and administration for 12 years, and has worked with the Microsoft Business Intelligence platform since SQL Server 2000. He is a frequent speaker at conferences and is an active community member.

Check your local timezone here


February 2015 Upcoming Sessions

Monday, February 16, 2015 at 3:00:00 PM CET (UTC+1 hour) / Monday, February 16, 2015 at 9:00:00 AM EST (UTC-5 hours)

BI in the sky (with diamonds)

Speaker: Johan Ludvig

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

Microsoft is really delivering up on it's "Cloud first" mantra with rapid releases of new functionality to it's PowerBI portifolio, functionality that won't arrive on-premise until next Office release - if ever. So you, or your manager has decided to give PowerBI a go. But the budget for this is a bit tight, and maybe you're not allowed to use the existing server. Azure is ready for you. But what Azure service do you choose, and how do you let PowerBI and Azure play nicely together? That's what this webinar is here to tell you.


Johan Ludvig
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 diving into PowerBI, R and all other sorts of technologies he can get his grubby little hands on.

Check your local timezone here