Session: Data Warehouse Architecture
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 his session include:
- Objectives of a Data Warehouse System
- Components of a Data Warehouse / Business Intelligence System
- DW, ETL, ODS, OLAP, Data Marts, Grain vs. Presentation Marts, Reports, Analytic Tools
- Data Warehouse Design Methods and Artifacts
- Normalizing vs. Denormalizing, Dimensional Modeling, Star vs. Snowflake Schema, Surrogate Keys, Conformed Dimensions and Facts, Bus Matrix, Slowly Changing Dimensions, Fact Table Types
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...)
RSVP: http://www.clicktoattend.com/?id=138406
Arrival: 5:45 PM to 6:00 PM
Session: 6:00 PM to 8:30 PM
Refreshments: Pizza and Pop
Comments