SSIS ETL Workshop: Processing Canadian Election Data

Using publicly available data from Elections Canada, Doug Sartori has created a database of Canadian federal election results that can provide answers to complex questions. Thanks to ETL (and open data sources), this DB is able to tell us: - which races were won by 5% or less - which poll was the best in the country for each party - how large the margin of victory was in each riding In this one-hour workshop, Doug will not only give answers to these questions, he will walk through the process used to create this database, providing usable tips and advice along the way.