2024/2025 KAN-CDSCO2303U Data Management and Visualization
English Title | |
Data Management and Visualization |
Course information |
|
Language | English |
Course ECTS | 7.5 ECTS |
Type | Mandatory |
Level | Full Degree Master |
Duration | One Semester |
Start time of the course | Autumn |
Timetable | Course schedule will be posted at calendar.cbs.dk |
Study board |
Master of Science (MSc) in Business Administration and Data
Science
|
Course coordinator | |
|
|
Main academic disciplines | |
|
|
Teaching methods | |
|
|
Last updated on 31-01-2024 |
Relevant links |
Learning objectives | ||||||||||||||||||||||||||||
After completing the course, the students will be
able to
|
||||||||||||||||||||||||||||
Course prerequisites | ||||||||||||||||||||||||||||
While it is not mandatory, students are recommended to brush up some basic data handling & analytical skills like using joins, unions, summarizing data, etc. | ||||||||||||||||||||||||||||
Prerequisites for registering for the exam (activities during the teaching period) | ||||||||||||||||||||||||||||
Number of compulsory
activities which must be approved (see section 13 of the Programme
Regulations): 2
Compulsory home
assignments
The students have to get 2 out of 3 assignments approved. Each assignment is 3-5 pages written in groups of 3-4 students. Some assignments may require submitting the scripts used to complete the assignment. There will not be any extra attempts provided to the students before the ordinary exam. If a student cannot hand in due to documented illness, or if a student does not get the activity approved in spite of making a real attempt, then the student will be given one extra attempt before the re-exam. Before the re-exam, there will be one home assignment (max. 10 pages) which will cover 3 mandatory assignments. The purpose of mandatory assignments is to help the students learn how to process data and create dashboards and thus prepare them for the final submission. The three assignments will cover (1) databases and SQL (2) Extract, Transform and Load (ETL) operations, and (3) visualising data and building dashboards. The first assignment will be on database systems and SQL. Students will be asked to create ER models, relational schemas and answer questions related to developing and maintaining databases. The assignment will also include SQL programming. In the second assignment, students will practice ETL operations and get hands-on experience in transforming and joining raw data using Python and other tools. In the third assignment students will practice building effective visualisations as well as learn how to build a dashboard. Although the exercises and lectures will demonstrate dashboarding with Tableau, students may use other dashboarding software to complete the assignment. |
||||||||||||||||||||||||||||
Examination | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
Course content, structure and pedagogical approach | ||||||||||||||||||||||||||||
The course provides knowledge of various concepts, techniques and methods related to data management, dashboarding and visualizations. Topics covered are:
The course provides the students with practical hands-on experience on data management, ETL and dashboarding. Although the lectures exercises will use specific tools and programs, students are allowed to use also other tools in the course project.
After completing the course, the students will be able to handle real-word big/business datasets and develop dashboards providing actionable insights to managers. |
||||||||||||||||||||||||||||
Description of the teaching methods | ||||||||||||||||||||||||||||
The course consists of lectures, exercises, and
assignments. Each lecture is followed by an exercise session, and
there will be a teaching assistant providing technical support for
assignments and course projects.
The presented theories, concepts and methods should be applied in practice and exercise sessions. The students work the entire semester on a mini project displaying the understanding of the concepts presented in the lectures and exercises. |
||||||||||||||||||||||||||||
Feedback during the teaching period | ||||||||||||||||||||||||||||
Feedback on mandatory assignments will be
provided.
Feedback is given during the course as described below: 1. We go through the assignment requirements in the exercise class so students can clarify initial doubts, if any. Then the assignment is published on Canvas. The course instructor will provide a written criteria on assessments. 2. Each group will get written feedback explaining strengths and weaknesses of their work as well as the correct answers to the assignment. 3. Some of the the best submissions will be discussed and presented in subsequent lectures. Students might be requested to present their work too. |
||||||||||||||||||||||||||||
Student workload | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
Expected literature | ||||||||||||||||||||||||||||
The literature can be changed before the semester starts. Students are advised to find the final literature on Canvas. Access to the a free license to use an online copy of the book "Database Systems" is provided to students who sign-up during the first week of the course.
|