3862
Comment:
|
3901
|
Deletions are marked like this. | Additions are marked like this. |
Line 3: | Line 3: |
90 hp Computer and Systems Sciences with at least: | 90 credits in Computer and Systems Sciences or 90 credits in a DSV bachelor programme with at least 60 credits in Computer and Systems Sciences. Including at least: |
Line 7: | Line 9: |
Data Warehouses are systems used for reporting and data analysis, and they are considered as a core component of business intelligence. This course will help you to design and implement data warehouses. You will learn different techniques and principles based on which you can design an effective and efficient data warehouse. In addition, you will experience the full data warehouse life-cycle by implementing a system according to latest advances in this area. | In this course, student will learn about one of the most important ingredient to a Business Intelligence (BI) and Data Science area, called data warehousing, which is very high demand in the job market. They will learn about techniques to Extract Transform and Load (ETL) the data. They will learn theories about modeling and implementation of data warehouses. In addition, they will get familiar with multi-dimensional data storage, called OnLine Analytical Processing (OLAP). They will also learn about languages that help them to query information from OLAP systems. Data warehouses are used within Business Intelligence (BI) to support organizations strategic decision making by utilizing Decision Support Systems. This course will help students to design and implement data warehouses. They will learn different techniques and principles based on which they can design an effective and efficient data warehouse. In addition, they will experience the full data warehouse life-cycle by implementing a system according to latest advances in this area. |
Line 12: | Line 15: |
After taking this course the student should have achieved the following objectives: 1. Is able to account for central terminology in the area, (in particular the terminology introduced by Ralph Kimball in the course literature, e.g. multidimensional model, star join schema, fact table, degenerate dimension, ETL, hierarchy, business intelligence, bitmap indexing, OLAP). Is able to explain how a data warehouse functions and how it differs from a traditional OLTP database. Is able to specify ETL processes and multi-dimensional expressions, i.e. MDX, as well as account for the functionality of back- and front-end tools; 2. Is able to apply the dimensional modelling techniques presented in the course literature and from a textual domain description produce and document dimensional models for a data warehouse. Be able to apply the strategies for physical data warehouse design presented in the course literature; 3. Can, from given sources, produce models and routines for data transfer into a data warehouse and practically apply these in a specific tool for populating a warehouse. Can use a given ETL system to extract data from different files and load it into relational tables. Is able to deal with history in continuous ETL processes; 4. Is able to implement dimensional models in a given system, populate these models with data, and use a front-end tool for extracting, calculating and analyzing the data present in a data warehouse; 5. Is able to implement theories and techniques for data warehousing presented in given research literature in the area. |
After taking this course the student should have achieved the following objectives: 1. knows central terminology in the area. 2. is able to produce and document dimensional models for a data warehouse based on an informal domain description 3. from a given source, produce routines for data transfer into a data warehouse, and able to write queries to fetch data from a data warehouse using MDX. 4. is able to implement dimensional models in a given system, populate these models with data, and use a front-end systems for extracting and analyzing the data present in a data warehouse. Can use a given ETL system to extract data from different files and load it into relational tables 5. can summarize, present and assess results from research literature in the area |
Line 21: | Line 29: |
1. Information requirements and information modeling relevant for enterprise management level 2. History, state-of-the-art, trends for data warehouse 3. Multidimensional modeling as a practical method for Data Warehouse design 4. Physical design, indexing techniques and the use of aggregate tables 5. The ETL process (Extract-Transform-Load) 6. Project management and lifecycle during the development and the maintenance of a Data Warehouse 7. Decision support systems and business intelligence (BI) |
1. Introduction to decision support systems and Business Intelligence 2. History, state-of-the-art within data warehousing 3. Rationale and patterns for multi-dimensional modeling 4. The ETL process (Extract-Transform-Load) and data integration 5. The Data Warehouse Lifecycle (DW development and maintenance process) 6. OLAP (Online Analytical Processing) and a multi-dimensional query language for data cubes 7. Trends within data warehousing and current research |
Line 30: | Line 45: |
The course is though in a traditional way. It contains a number of lectures, lessons, seminars and tutorials. Course schedule with the different activities is provided in Daisy. Students have to do self studies (i.e. read the course literature) and carry out a number of practical assignments. The assignments are completed in groups. The lectures and lessons introduce the students to the theory needed for the completion of the assignments. Tutorials are offered to students working with the assignments. The assignments are reported and discussed during seminars or meetings. | The course contains a number of lectures, lessons, labs and tutorials. Course schedule with the different activities is provided in Daisy. Students have to do self studies (i.e. read the course literature) and carry out a number of practical assignments. The assignments are completed in groups. The lectures and lessons introduce the students to the theory needed for the completion of the assignments. Tutorials are offered to students working with the assignments. The assignments are reported and discussed during seminars or meetings. The ETL and OLAP part of assignments are based on SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS), which are very high demand and widely used in industry. |
IS5 - Data warehousing
Requirements
90 credits in Computer and Systems Sciences or 90 credits in a DSV bachelor programme with at least 60 credits in Computer and Systems Sciences.
Including at least:
- 7,5 hp database
Short description
In this course, student will learn about one of the most important ingredient to a Business Intelligence (BI) and Data Science area, called data warehousing, which is very high demand in the job market. They will learn about techniques to Extract Transform and Load (ETL) the data. They will learn theories about modeling and implementation of data warehouses. In addition, they will get familiar with multi-dimensional data storage, called OnLine Analytical Processing (OLAP). They will also learn about languages that help them to query information from OLAP systems. Data warehouses are used within Business Intelligence (BI) to support organizations strategic decision making by utilizing Decision Support Systems. This course will help students to design and implement data warehouses. They will learn different techniques and principles based on which they can design an effective and efficient data warehouse. In addition, they will experience the full data warehouse life-cycle by implementing a system according to latest advances in this area.
Aim
The general goal with this course is to familiarize the students with a special kind of information systems called Data Warehouses – their role, utilization and benefits for organisations, as well as architectures and underlying technologies relevant for their development.
After taking this course the student should have achieved the following objectives:
1. knows central terminology in the area.
2. is able to produce and document dimensional models for a data warehouse based on an informal domain description
3. from a given source, produce routines for data transfer into a data warehouse, and able to write queries to fetch data from a data warehouse using MDX.
4. is able to implement dimensional models in a given system, populate these models with data, and use a front-end systems for extracting and analyzing the data present in a data warehouse. Can use a given ETL system to extract data from different files and load it into relational tables
5. can summarize, present and assess results from research literature in the area
Syllabus
The course contains the following parts:
1. Introduction to decision support systems and Business Intelligence
2. History, state-of-the-art within data warehousing
3. Rationale and patterns for multi-dimensional modeling
4. The ETL process (Extract-Transform-Load) and data integration
5. The Data Warehouse Lifecycle (DW development and maintenance process)
6. OLAP (Online Analytical Processing) and a multi-dimensional query language for data cubes
7. Trends within data warehousing and current research
Outline
The course contains a number of lectures, lessons, labs and tutorials. Course schedule with the different activities is provided in Daisy. Students have to do self studies (i.e. read the course literature) and carry out a number of practical assignments. The assignments are completed in groups. The lectures and lessons introduce the students to the theory needed for the completion of the assignments. Tutorials are offered to students working with the assignments. The assignments are reported and discussed during seminars or meetings. The ETL and OLAP part of assignments are based on SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS), which are very high demand and widely used in industry.
Note that this is not a distance course; hence students are strongly recommended to participate in the activities offered during the course.