One of the difficult phases in implementing solid BI solutions is designing a multi-dimensional storage model, the core of a data warehouse or a data mart. The translation of business requirements to a star or snowflake schema is not trivial, and comes with a number of options and possibilities to choose from: - Shall I store this information in the dimension or in a fact?
- Do we need an extra dimension or shall we put it as fields in a fact table?
- Can I use a fact as dimension table?
- Do we pre-calculate in the fact, or do we calculate it on-the-fly?
- Can’t we do without technical keys?
- Why and when do we need an ODS?
- Which fields should trigger an SCD?
- Can we automatically maintain summary tables?
- Do we process complex algorithms in the source, during ETL, in the semantic layer or in the report?
- ...
Keyrus offers a practical 2-days training course about multi-dimensional modelling, including a set of advanced modelling techniques. It is a 'hands-on' training, which enables all participants to produce star and snowflake models tailored to a given set of end-user requirements. By taking part in this workshop, people will also understand the difference between 3NF modelling and multi-dimensional modelling. Studying the more advanced modelling issues and their solutions will give all participants a great insight into the pros and cons of star and snowflake modelling in the company’s overall (corporate) data architecture. Agenda
The following topics will be handled interactively: - Introduction to data warehouse modelling
- Multi-dimensional modelling methodology
- Modelling dimensions & hierarchies
- Define report granularity
- Define fact granularity
- Define report templates
- Cross-reference lists
This training is set up as a highly interactive workshop, where a major part of the time is spent on practical application of the techniques in consistently developed exercises. By the end of the workshop all participants will be able to: - capture business requirements,
- apply multi-dimensional modelling principles,
- define required fact granularity,
- produce dimensional models,
- use cross-reference lists.
About the speaker
This workshop is brought by Bert Wustenberghs, who perfectly combinestheory and practice into a compelling training course: - Principal consultant data warehousing & business intelligence,
- Experienced data warehouse architect & data modeller
- Projectmanager
- Senior business analyst (finance, manufacturing, automotive, chemical)
- Lector at EHSAL Management School in Brussels
Bert has broad experience in implementing various IT projects, the last 20 years predominantly related to data warehousing & business intelligence, and the delivery of corporate performance management information in multi-national organizations. Should you be interested in organising a private (case-driven) workshop at Keyrus, or at your company’s premises, please contact us for further details. For any further queries regarding this workshop please do not hesitate to contact us: t +32 2 706 03 00
mail to events@keyrus.be
visit www.keyrus.be | Üregistration Date & time
Wednesday-Thursday 22-23 April 2009 We welcome all participants as of 09:30. Every day starts at 10 a.m. and finishes around 5 p.m. Location
Keyrus nv - Nijverheidslaan 3/2, B-1853 Strombeek-Bever Audience
DWH project members who need a better insight in multi-dimensional data modelling, or more specifically, business analysts, data modellers, ETL designers/developers, report designers/developers, consultants. Prerequisites
Participants should have some understanding of BI concepts, be skilled users of Microsoft PowerPoint and Excel and bring their own laptop, if possible. Pricing
The price per participant per workshop (2 days) is 1100,- EUR (excl. 21% BTW). Discounts
For a second participant of the same company registering at the same time (i.e. same invoice) Keyrus allows a discount of 10% on the price. All subsequent people receive a 20% discount. Please check out the workshop terms and conditions. 
|
