Topic: Data Warehouse Concepts and Design
Description: This presentation will briefly cover a number of concepts and design techniques related to planning and developing a Data Warehouse.
The following points will be addressed during the presentation:
• What is a Data Warehouse, and what are its goals
• Differences between Operational Database Systems and Data Warehouses
• Schema types for Data Warehouses
• Data Warehouse Architecture and Bus Matrix
• Dimensional modelling
• High level overview of the ETL subsystems
• Q&A
Examples throughout the presentation are sourced from Kimball, R. and Ross, M., The Data Warehouse Toolkit, Wiley, 2002, other relevant works on this topic, as well as from the presenter’s experience.
Due to limited time, this presentation is only an introduction to the above concepts and design techniques, and no prior knowledge is assumed. Attendees will gain an understanding of the structure of the underlining data on which BI tools are applied, in order to get useful knowledge for the business.
Presenter: Laura Rusu completed her PhD in Computer Science in 2009 at La Trobe University, with a thesis on “XML data warehousing and mining”. During her studies, she proposed a number of novel techniques to adapt traditional data warehousing and mining methodologies (which deal mostly with structured data) to XML data warehousing and mining. She presented at more than 10 international conferences, and published two extended papers in prestigious international peer-reviewed journals. She also authored a book chapter and edited a book on Data Mining and Warehousing Technologies. Laura’s experience is a blend of academic, research and industry roles. She worked in academia as a lecturer and she was a Postdoctoral Fellow in a two-year project for AirServices Australia. Currently she is a Development Team Lead at Computershare Technology Services, and an independent consultant on Data and Information Management topics.
Date: 28 Feb 2011
Time: 5:30pm for a 6pm start
Venue: ACS Pearcey Room Level 2, 120 Clarendon StreetSOUTHBANK VIC 3006
Cost: Member: Free Non-Member: Free
Registeration: Register here
Refreshments and drinks will be provided.
Contact Info:
Convenor: Pengchea Ngo
Mobile: 0403709613
Email: pengchea@yahoo.com
