Attendees leave with the understanding of how different design choices affect both the usability and performance of their database design. The last day of the class focuses on the ETL processes necessary to support their designs. What's Happening Given the tremendous success of dimensional data warehouse techniques in even the largest of data warehouse implementations, dimensional data warehouse design techniques are being adapted by a majority of data warehouse designers. For years dimensional techniques have proven their validity in data marts, but the big news is that the dimensional techniques are also applicable, even necessary, at the detail level of the enterprise data warehouse. This workshop teaches how to design both the detail and aggregate levels of the data warehouse.
Participants work in teams as they develop solutions for difficult design problems.
Their solutions are then analyzed and simulated for both usability and performance providing important feedback to the students on their design choices. Preliminary Quiz and Discussion 3. Basic Dimensional Modeling Review 4. The time dimension l. Enabling percentage calculations 6.