Full session details for each of these events will be sent out to the OttawaSQL.net mailing list, but in the meantime we wanted to let you know the roadmap so you can save the dates (or register early)! We will be continuing with a focus on BI for the next 2 events, and we'll be capping it off with a full day event this summer for people interested in the MCITP BI certification on SQL Server 2008.
Monday, May 25th 6:00 PM to 8:30 PM - Microsoft Ottawa, World Exchange Plaza
Session: Data Warehouse Architecture, Dejan Sunderic
Dejan Sunderic presented this session on Data Warehouse Architecture to the Toronto group last December and attendees were very impressed. We are lucky to have him visit the Ottawa group to share his knowledge.
The main topics of this session include:
· Objectives of a DW System
· Components of a DW / BI System
· DW Design Methods and Artifacts
Speaker: Dejan Sunderic
Dejan Sunderic is an independent consultant specializing in SQL Server development and architecture. He is an author of couple of books (such as "SQL Server 2005 Stored Procedure Programming in TSQL and .NET") and maintains couple of other web sites (such as tsql.trigonblue.com, ssis.trigonblue.com...).
Register at: http://www.clicktoattend.com/?id=138406
Wednesday, June 17th 6:00 PM to 8:30 PM - Microsoft Ottawa, World Exchange Plaza
Session: Introduction to Dimensional Modeling - A Case Study
Lynda will explore introductory dimensional modeling techniques and will demonstrate how to build an OLAP database using these techniques. Her case study will examine source data from an operational database (OLTP) and step by step create a basic dimensional model and OLAP database.
Speaker: Lynda Rab
Lynda Rab is a Senior Data Warehouse Analyst and has been working with OLAP databases since 2000. Lynda is the Program Director for the Professional Association of SQL Server (PASS) and is a member of the OttawaSQL.net executive team.
Register at: http://www.clicktoattend.com/?id=138407
Late July / Early August
Certification Exam Review, MCITP: Business Intelligence Developer 2008
In keeping with the BI theme, we are working on having a full day event (6 to 8 hours) on a Saturday in late July or early August to review all of the exam objectives for the MCITP BI certification (on SQL Server 2008). We will have a team of 3 or more presenters that will tightly base their presentations on the objectives for the 70-452 exam ( http://www.microsoft.com/learning/en/us/Exams/70-452.mspx ). Since we have not yet confirmed the date we are simply asking for people that are interested in attending to let us know via email (at Events@OttawaSQL.net ). Once all of the logistics have been arranged we will setup a registration for the event.

Comments