Successful Business Intelligence solutions rely on a robust architecture and the principles applied within. Such an architecture must be able to fulfill requirements such as reusability, data validity, flexibility, scalability, availability etc. In other words you need to be able to handle changing requirements over time as well as an ever-increasing complexity. A key component is the Enterprise Data Warehouse (EDW)

Content: In this course you will learn the best practices for establishing and maintaining a robust Data Warehouse architecture as the foundation for Business Intelligence solutions. You’ll learn a specialized modeling technique for Data Warehouses that builds upon best practice architecture, drives requirements for developing standardized ETL, and supports changing business requirements. The course covers:

• Introduction to Data Warehouse architecture and the fit with BI solutions
• Design and modeling of an Enterprise Data Warehouse using a specialized modeling technique
• Populating structures and extracting data in the Data Warehouse
• Managing and recording changes in data
• Managing security
• How to tag data in the Data Warehouse to support e.g. roll-backs across several tables
• Performance optimization
• Practical exercises, individual and in groups

Target audience: This course applies to project managers, BI architects, participants in Business Intelligence projects and others working with Data Warehousing.

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