Databases and data analytics (5cr)

Objective

After completing this course, student knows the principles databases and data warehouses. Student can use different data sources and develop OLAP cube. Student can utilize Business Intelligence tools in data analyzation and visualization.

Content

- Theory of using databases, relational databases, NoSql-databases
- ETL
- Cubes and data analysis
- Business Intelligence tools

Qualifications

Basics of databases, relational model, basics of SQL.

Assessment criteria, satisfactory (1)

Student knows the principles databases and data warehouses. Student knows how to utilize Business Intelligence tools.

Assessment criteria, good (3)

Student knows the principles databases and data warehouses. Student can use different data sources and develop OLAP cube. Student can utilize Business Intelligence tools in data visualization.

Assessment criteria, excellent (5)

Student masters the principles databases and data warehouses. Student can use different data sources and develop OLAP cube. Student can use Business Intelligence tools in data analyzation and visualization.