Extracting information out of the many data available in a company is heavily dependant on the structures e.g. a data mart, through which people access the data. Analyzing key measures through dimensions has, for many years, proven to be an excellent way of doing just that. However, supporting the many different user requirements requires a solid design using the dimensional modeling technique.

Content: In this course you will learn about the fundamental design considerations for a data mart and learn how to distinguish between measures and dimensions and how to apply these elements to establish powerful analytical structures that will support even complex business requirements. The art of Dimensional Modeling apply regardless of whether you use OLAP or relational based technology. The course covers:

• Introduction to Dimensional Modeling
• Where to apply Dimensional Modeling in a Data Warehouse architecture
• How to design a data mart using Dimensional Modeling
• How to identify facts, dimensions, hierarchies within the business
• The different types of Data Marts
• The different types of facts
• Moving from a logical model to a physical design
• Performance considerations in a relational database
• How to deal with historic data in Data Marts
• Practical exercises, individual and in groups

Target audience: This course applies to project managers, participants in Business Intelligence projects, BI-architects and others which have occupied themselves with Data Warehouse- or OLAP-implementation.

Attendee requirements: Participants should have practical experience with IT or have a relevant IT-degree. Participants should have knowledge of Business Intelligence at a similar level as the course Introduction to Business Intelligence and Data Warehousing and knowledge of data modeling similar to the course Information Modeling.

Duration: 2 days fundamentals course

Price: AUD 2.300 ex. VAT