Dimensional Modelling

lt;pgt; Dimensional modelling is an integral part of any BI (Business Intelligence) system and can be used within the data warehouse and/or the data marts. This 3 day course assumes no prior knowledge of dimensional modelling. It starts by discussing what a data warehouse is, how they are designed and the part that dimensional modelling plays.lt;/pgt;lt;pgt; The vitally important process of requirement gathering is covered and delegates are shown how to:lt;/pgt;lt;ulgt; lt;ligt; Collect the analytical requirements of the business userslt;/ligt; lt;ligt; Create a logical model of these requirementslt;/ligt; lt;ligt; Create a star schema from those requirementslt;/ligt;lt;/ulgt;lt;br /gt;lt;pgt; The relational and dimensional models are compared and contrasted, with particular reference to the current Kimball/Inmon debate.lt;/pgt;lt;pgt; The course then looks in great detail at dimensional modelling itself and finally ends with a summary of possible BI architectures.lt;/pgt;lt;h4gt; Target Audiencelt;/h4gt;lt;pgt; This course is aimed at people who work in the BI area. It is suitable for business analysts who need to understand the analytical requirements and turn those requirements into a model. It is also suitable for the IT professional who will turn those models into working OLAP (On-Line Analytical Processing) structures. Please note, delegates who have previously attended QADMBIS - Developing A Modern Business Intelligence System should not attend this course.lt;/pgt;