Providing both performance and flexibility are often seen as contradictory goals in designing large scale data implementations. In this talk we will discuss techniques for denormalisation and provide a framework for understanding the performance and flexibility implications of various design options. We will examine a variety of logical and physical design approaches and evaluate the trade offs between them. Specific recommendations are made for guiding the translation from a normalised logical data model to an engineered-for-performance physical data model. The role of dimensional modeling and various physical design approaches are discussed in detail. Best practices in the use of surrogate keys is also discussed. The focus is on understanding the benefit (or not) of various denormalisation approaches commonly taken in analytic database designs.
Discounts
Face to face public courses: early bird pricing is available until 2 weeks prior. Group discounts: 5% for 2–4 people, 10% for 5–6 people, 15% for 7–8 people, and 20% for 9 or more people. Discounts are calculated during checkout.
Online public courses: available at a 25% off the face-to-face courses as a special introductory price. to groups or to individuals who want to follow a curriculum program and attend multiple courses:
- 2-4 courses/attendees 10% off
- 5+ courses/attendees 20% off
Hurry as bookings will close 1 week before each course. Group discounts are calculated during checkout on individual courses. Individuals can book multiple courses at a discount – please enquire.
Additional Information
| Audience | Experts, management, architects, BI analysts, and data scientists interested in learning to use advanced analytic techniques to find insights in data and who has at least some scripting experience, although there’s no scripting involved. |
| Prerequisites | Students should have completed or have equivalent knowledge to the course Data Literacy for Everyone. |
| Objectives |
|
| Workshop | |
| Duration | 3hrs – 1 day, depending on your organisation’s requirements |
| Trainer | Stephen Brobst |
| Delivery Method | In-person at AlphaZetta Academy locations or on-premise for corporate groups |
Private and Corporate Training
In addition to our public seminars, workshops and courses, AlphaZetta Academy can provide this training for your organisation in a private setting at your location or ours, or online. Please enquire to discuss your needs.
Scheduled Public Courses
Private and Corporate Training
In addition to our public seminars, workshops and courses, AlphaZetta Academy can provide this training for your organisation in a private setting at your location or ours, or online. Please enquire to discuss your needs.
