December 2013 Upcoming Sessions
We would like to invite PASS DW/BI VC members around the world to participate in Microsoft User Study on BI Professionals survey. Please follow the link below to complete it and thank you in advance for your participation.
As the end of the year is quickly approaching, we have 3 exciting sessions lined up in December, two of which are to be held at Noon Pacific time and one at New Zealand time. So, please ensure that you check your local timezone by clicking on the Date heading.
Thank you volunteers, speakers and members for your continual support for PASS DW/BI VC. We are very much looking forward to more successful and richer content in the new year. If you are interested in volunteering, for example hosting, speaking or marketing PASS DW/BI VC, please feel free to email us at firstname.lastname@example.org
Last but not least, Happy New Year and best wishes from the PASS DW/BI VC Team,
Julie & Jen
Thursday 12 December Noon PST / 3 PM EST / 8 PM GMT - Friday 13 December 9 AM NZDT
Create and Load a Staging Environment from Scratch in an Hour with Biml
Speaker: Scott Currie
Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this hour long presentation, Scott Currie from Varigence will use the free BIDSHelper add-in for BIDS and SSDT to introduce Biml and use to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Scott will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of *hundreds* of target table creation scripts, data load packages, data scrubbing rules, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns. .
Scott Currie is the founder and CEO of Varigence, Inc. prior to founding Varigence, Scott worked for 7 years at the Microsoft Corporation. Scott was the Program Manager for managed interoperability in the Visual C++ Compiler and the 64-bit Just In Time (JIT) compiler for the .NET Framework. He also lead several important customer connection initiatives for the Developer Division at Microsoft including product feedback, product preview (CTP) and early adopter (TAP) programs, online crash analysis, and customer satisfaction measurements. Scott later created and served as the Product Unit Manager for the Detego team at Microsoft, which was responsible for leveraging agile application development methodologies in the development of Business Intelligence solutions.
Tuesday 17 December Noon NZDT / 10 AM AEDT - Monday 16 December 3 PM PST / 6 PM EST / 11 PM GMT
Inferred Dimension Members within MDS and SSIS
Speaker: Reza Rad
Combining Master Data Services with Data Warehouses, will cause some challenges in ETL Scenarios. In this session we will go through a demo of Inferred Dimension Members implementation with SSIS considering the fact that MDS keeps the single version of truth for the dimension record. In this session you will learn how we will write back new record's data into MDS entity as an Inferred member. The staging structure of Master Data Services and Batch Processing will be used for this. Then you will learn what is the best practice to add the inferred record into Data Warehouse dimension. Updating the existing dimension member also would consider the Inferred member and apply SCD types only if this is not an inferred Member..
Reza Rad is an Author, Trainer, Speaker and Senior DW/BI Consultant. He has a BSc in Computer engineering; he has more than 10 years' experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in SQL Server for three continues years (from 2011 till now) for his dedication in Microsoft BI. His articles on different aspects of technologies, especially on MS BI, can be found on his blog: http://www.rad.pasfu.com .
He wrote some books on MS SQL BI and also is writing some others, He is also an active member on online technical forums such as MSDN and Experts-Exchange, and is a moderator of MSDN SQL Server forums, and is a MCP, MCTS and MCITP of BI. He is the leader of New Zealand Business Intelligence users group.
He is a Technical Speaker in SQL Saturday and SQL users groups and Conferences. And He is a Microsoft Certified Trainer.
Thursday 19 December Noon PST / 3 PM EST / 8 PM GMT - Friday 20 December 9 AM NZDT
Guerrilla MDS/MDM The Road To Data Governance
Speakers: Ira Whiteside and Victoria Stasiewicz
Ira and Vic's session "Guerrilla MDS" will be a walk-through of a real-world implementation for a master data model (MDM) and metadata mart utilizing SSIS, MDS and POWER BI EXCEL addins as well as applying proper data quality techniques. We will walk through in detail the processes necessary for utilizing the complete MDS functionality as follows: creating entities attribute, relating entities the domain based attributes , staging leave table, updated entity content, apply business rules, create subscription view and set up security. Source code for all samples and PowerPoints will be made available
Ira Whiteside: 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 and Data mining.
Victoria is a senior business analyst and data profiling analyst. She has extensive experience in the healthcare industry in analyzing and implementing the Sundial metric decomposition methodology as well as extensive experiencing in developing SSIS packages