Permalink
2010/2011 KAN-CMIT_VDAW Data warehouses
| English Title | |
| Data warehouses |
Course Information | |
| Language | English |
| Point | 7,5 ECTS (225 SAT) |
| Type | Elective |
| Level | Full Degree Master |
| Duration | One Semester |
| Course Period | Pending schedule: Friday 13.30-16.05, week 36-41, 43-44 |
| Time Table | Please see course schedule at e-Campus |
| Study Board |
Study Board for BSc/MSc in Business Administration and Information Systems |
| Course Coordinator | |
| Lars Frank - lpf.inf@cbs.dkSecretary INF - reception.inf@cbs.dk | |
| Main Category of the Course | |
| |
Taught under Open University-Taught under open university. | |
| Last updated on 29 maj 2012 | |
| Learning Objectives | ||||||||||||||||||||||||||
|
The course’s development of personal competences: The course qualifies the students for occupation within Business Intelligence (BI)/decision support systems that is one of the fastest groing areas within IT. Objectives: A datawarehouse is a consistent set of data organized for decision making The course focus on how to design, describe, and optimize datawarehouses for different line of businesses/organisations. For each node in the value chain of any type of organization, the student should be able to design, describe, and implement a data mart for decision making. As a datawarehouse normally evolves over time, the student should also be able to demonstrate how “conforming” the data warehouse can protect the investment against new unforeseen demands to the data warehouse. In a given business decision making situation, the student should be able to select an appropriate BI tool to support the decision making. SAS´s data warehouse produkt EIS will be demonstrated in order to make it possible for the students to implement a data warehouse. However, any datawarehouse product may be used. The company Affecto have offered free licenses to the participants in their free optional Business Object course. | ||||||||||||||||||||||||||
| Prerequisite | ||||||||||||||||||||||||||
| The student should know how to read a simple SQL program. | ||||||||||||||||||||||||||
| Examination | ||||||||||||||||||||||||||
| Oral exam on the basis of a project, max. 15 pages. | ||||||||||||||||||||||||||
| ||||||||||||||||||||||||||
| Examination | ||||||||||||||||||||||||||
| 20 minutes oral exam based on a maxi-project which is max. 15 pages per student. The re-take takes place according to the same rules as the regular examination. | ||||||||||||||||||||||||||
| Prerequisites for Attending the Exam | ||||||||||||||||||||||||||
| Course Content | ||||||||||||||||||||||||||
As an introduction to the course the basic data models for both operative databases/On Line Transactional Processing (OLTP) and data varehuse/On Line Analytical Processing (OLAP) are described.The focus of the course is how to design, describe, implement, and evaluate data warehouses for different line of businesses/organisations. From a business point of view the main problem in data warehouse design is that most companies/organizations have lots of data, but these data are not structured in order to give information for decision support. The course will also give an overview of the different types of data mining from a user point of view. Therefore, data mining algorithms will not bedescribed. | ||||||||||||||||||||||||||
| Teaching Methods | ||||||||||||||||||||||||||
| The teaching is integrated with exercises and discussion of the solutions. It is expected that each student is responsible of a lecture that presents the theory from one of the chapters in the required readings. The student lectures may last up to 20 minutes and may also use exercises followed by discussions. Background theory that is only used indirectly in the maxi project is often self study. The teaching also consists of supervising the project groups and discussion of the solutions followed by student presentation of their work with the maxi project. Students with knowledge in other data warehouse products can substitute there theory lecture with a presentation of another data warehouse product. | ||||||||||||||||||||||||||
| Literature | ||||||||||||||||||||||||||
A little more than 1000 pages are listed as there is some overlapping between Kimball’s two books.
| ||||||||||||||||||||||||||