Data Warehouse
Concepts and
Design
CSE5DWD Lecture 6
A Case Study & Design
Decision
Copyright La Trobe University
Lecture 6
Cover
A Case Study
Design Decision
2
Case Study: Perfect Property Sales
Division
Perfect Property is a real estate company. Their
CSE5DWD DATA WAREHOUSE CONCEPTS AND DESIGN
LABORATORY 1
Objectives
In this laboratory you will analyse the main discussion points from the Lecture 1. This is not
a test for your memory and you are not required to repeat what the lecturer said during the
l
Data Warehouse
Concepts and
Design
CSE5DWD
Lecture 7
Extract Transform Load
(ETL)
Copyright La Trobe University
Lecture 7 Topics
Extract Transform Load (ETL)
ETL Requirements
The 34 subsystems of ETL
Extracting Data Subsystems
Cleaning and Conforming
CSE4DWD Data Warehouse Concepts and Design
Laboratory 5 & 7 - Aim for ETL process
Oracle Warehouse Builder Design Centre
Lab 5. Finishing the part one to have a Warehouse Builder workspace
Step 1 You need to go SQLplus to change your initial password. Ini
CSE5DWD Data Warehouse Concepts and Design
Laboratory 4
In this laboratory you will have a preliminary exercise and then you will work through two case
studies, where you need to implement some of the concepts discussed during Lecture 3 - 5.
-Case study:
CSE5DWD DATA WAREHOUSE CONCEPTS AND DESIGN
LABORATORY 6 Dimensional modelling design
review
Objectives
In this laboratory you will analyse the scheme for design view using your learnt
knowledge from the Lecture 4-6 to further enhance your learning. Unders
CSE5DWD Data Warehouse Concepts and
Design
Laboratory 3 - Solution
In this laboratory you will have a preliminary exercise and then you will work through
two case studies, where you need to implement some of the concepts discussed during
Lecture 3.
Exerci
3789d1a6da60bdece8d0ec54b6f37271d7b8cd24
Expense_Type
Air Direct Billed
Air-Rail Transportation
Air Express Shipping
Bonus (Non-Cash Awards)
Books-Subscriptions
Breakfast
Car Rental
Computer Supplies
Courier-Ground Freight
Dinner
Entertainment
Expats - Ai
CSE5DWD DATA WAREHOUSE CONCEPTS AND
DESIGN
LABORATORY 3
Objectives
In this laboratory you will have a preliminary exercise and then you will work through
two case studies, where you need to implement some of the concepts discussed during
Lecture 3.
Refere
CSE5DWD Data Warehouse Concepts and Design
Laboratory 5
-sample solutions
In this laboratory you will have a preliminary exercise and then you will work through two case
studies, where you need to implement some of the concepts discussed during Lecture 3
CSE5DWD Data Warehouse Concepts and
Design
Laboratory 2 - Solution
In this laboratory you will analyse the main discussion points from the Lecture 2 and work
through a case study.
As previously mentioned, this is not a test so you are not required to repe
Data Warehouse
Concepts and
Design
CSE4DWD
Lecture 2 Data Warehouse
Architecture
Copyright La Trobe University
Lecture 2
Cover
Data Warehouse Architecture
Dimensional Data Modelling Primer
Reading
Kimball, R. and Ross, M. The Data
Warehouse Toolkit, Wil
CSE5DWD DATA WAREHOUSE CONCEPTS AND DESIGN
LABORATORY 2 - Data Warehouse environment
Objectives
In this laboratory you will analyse the main discussion points from the Lecture 2 and work
through a case study. As previously mentioned, this is not a test so
Data Warehouse
Concepts and
Design
CSE5DWD
Lecture 3 Dimensional
Data Modelling
Copyright La Trobe University
Lecture 3
Cover
Dimensional Data Modelling
Case study
Four-step process for designing
Dimensional Models
Reading
1. Kimball, R. and Ross, M. T
CSE5DWD DATA WAREHOUSE CONCEPTS AND
DESIGN
LABORATORY 5
Objectives
In this laboratory you will have a preliminary exercise and then you will work through
two case studies, where you need to implement some of the concepts discussed during
Lecture 3 - 5.
Re
CSE5DWD DATA WAREHOUSE CONCEPTS AND
DESIGN
LABORATORY 4
Objectives
In this laboratory you will have a preliminary exercise and then you will work through
two case studies, where you need to implement some of the concepts discussed during
Lecture 3 - 5.
Re
CSE5DWD DATA WAREHOUSE CONCEPTS AND
DESIGN
LABORATORY 1 SOLUTION
Objectives
In this laboratory you will analyse the main discussion points from the Lecture 1. This
is not a test for your memory and you are not required to repeat what the lecturer said
dur