Business Intelligence

Code

IT-BUI1

Version

1.1

Offered by

ICT Engineering

ECTS

Prerequisites

Main purpose

The main purpose of the course is to equip the student to work with realistic data using professional business intelligence tools, such as Microsoft SSIS, SSRS, and SSAS.

Knowledge

Students will obtain knowledge about understanding, reading, and displaying data from a dimensional model, such as a star scheme or data cube.

Skills

Data migration using integration services
Designing paginated reports in Reporting services
Scheduled jobs in SQL server
Creating analyses in Power BI
Creating cubes in Analysis services

Competences

Topics

Teaching methods and study activities

Lessons alternate between theory and practical exercises using Microsoft SQL Server business intelligence services. The course contains one compulsory assignment.

Expected workload for students is estimated to 135 hours.

Resources

Online resources.

Evaluation

Internal examination.
In order for the student to qualify for the examination, the course assignment must have been handed in and approved.

Examination

Oral examination based on the course assignment.

Approximately 20 minutes incl. discussion of examinee's performance, without preparation.

Grading criteria

According to the 7-point grading scale.

Mark 12:
Awarded to students who have shown excellent comprehension of the above-mentioned competences. A few minor errors and shortfalls are acceptable.

Mark 02
Awarded to students for the just acceptable level of comprehension of the required competences.

Additional information

Responsible

Ole Ildsgaard Hougaard

Valid from

2/1/2020 12:00:00 AM

Course type

6. semester
7. semester
Elective for the specialization Data Engineering
Electives