Optimizing Enterprise Data Warehouse Design Utilizing Dimensional Normal Form
Venue: Residenza di Ripetta
|Event Date/Time: Apr 20, 2009||End Date/Time: Apr 22, 2009|
This seminar fully covers design techniques for Data Warehousing and BI solutions based on the Dimensional Normal Form Data Architecture and discusses the pros and cons of the many design decisions that must be made. History considerations are discussed in detail along with their impact on schema design.
Various schema design examples are presented and discussed. The seminar participants will also be given design exercises will have their solutions analyzed and discussed by the group.
The seminar will also present contrasting Data Warehouse architectures and discuss the variations in physical design that are required for different Data Warehousing environments.
The following seminar on Template-Driven ETL will show how to build, populate and maintain the schemas built following the Dimensional Normal Form Data Architecture.
He specializes in high performance Data Warehousing solutions. He has in-depth experience utilizing efficient, scalable techniques whether dealing with large-scale Data Warehouses or small-scale, platform constrained Data Mart implementations. After establishing a career in database management systems and working for Software AG and IBM he began specializing in Data Warehousing in 1987 with Teradata. He subsequently worked for Red Brick and Informix and served as Director of Data Warehousing for Oraclesâ€™ Mid-Market Solutions Group. After establishing a successful independent consultancy he worked Knightsbridge Solutions and HPâ€™s Information Management practice. He is most recently acted as the Lead DW/BI Architect for Nike building a new Enterprise Data Warehouse based on Informatica and Teradata. He is currently the principal and owner of Database Performance LLC. His experience with different systems, architectures, and methodologies has enabled him to evolve a unique approach to Data Warehousing utilizing best of breed components and methods. He has written several articles on his approach and has co-authored one book. He actively works on Data Warehouse implementations and teaches design and implementation classes internationally.