Data Warehouse Design and Implementation

 

Course title   

Data Warehouse Design and Implementation

Course Codes          

DS7502

Level  

7

Status            

Elective

Credits

15

Prerequisite 

DS6503 Data Mining Tools and Techniques

Course offered in

Refer to Programme Course Selection Sheet

Duration

1 trimester

 

 

           

Aim

To provide learners with practical experience in the design and implementation of data warehouses and the development of Online Analytical Processing (OLAP) tools.

 

Indicative content

ETL procedures involving staging, data integration and access layers, Multidimensional modelling approaches for implementing data warehouse architectures, Querying languages and reporting tools commonly used on OLAP cubes for roll-up, drill-down and slice and dice operations, Approaches for conveying the analytical results from OLAP tools and data cube mining to a target audience, Contemporary issues relating to data warehousing and its role within strategies for achieving business intelligence

 

Learning Outcomes

On successful completion of this course, the learner will be able to:

  1. Identify and explain commonly used architectures in the design of data warehouses
  2. Create multidimensional models using star and snowflake schemas
  3. Perform Extract-Transform-Load (ETL) procedures to populate a data warehouse
  4. Create queries that analyse multidimensional data from multiple perspectives
  5. Identify and explain the characteristics of data warehouses and their role within strategies for achieving business intelligence
  6. Perform data mining functions on data cubes and explain analytical results to a target audience

 

 

 

 

 

 

Have a question
or feedback?

Call us on 0800 935 832
or send us a message