Colonial Williamsburg’s Foundation Data Warehouse, where the 18th century meets the 21st century.  Rick Todd from the Colonial Williamsburg Foundation IT Department will be sharing some of their insights into handling the ever-tricky Customer Dimension while building their Data Warehouse.  Colonial Williamsburg is a perfect fit for a Data Warehouse, having lines of business as diverse as Ticketing, Hotel, Food and Beverage, Retail (online, on location, and catalog), Spa, and Golf.  Rick will be discussing some of the successes and failures his team (of 2) has had will attempting to import, conform, merge, household, and report on customers across all these systems (which currently include SQL 2000, SQL 2005, and AS400).  The first 3/4ths of the presentation will be a fairly fast moving, high level discussion covering modeling the Customer dimension, an ETL framework for conformed dimensions, merging, purging, and householding Customers through fuzzy logic, and handling the conformed dimension in Analysis Services.  The last 1/4th of the meeting time will be left for a more in-depth discussion of any areas that people find interesting.  Please come to help Rick further Colonial Williamsburg’s mission: That the Future May Learn From the Past.  In this case, their Rick’s teams’ past mistakes and successes, as opposed to the founding of our country.