IVZ751 Business Intelligence Technologies II

Code IVZ751
Name Business Intelligence Technologies II
Status Compulsory/Courses of Limited Choice
Level and type Undergraduate Studies, Professional
Field of study Computer Studies
Academic staff Leonards Budņiks, Aleksandrs Fiļipovs, Vladimirs Jansons, Tatjana Celmiņa
Credit points 4.0 (6.0 ECTS)
Parts 1
Annotation The course includes introduction to analyzing of economic information by means of MS Excel tools - Pivot Table, Power Query, Power Pivot and vlookup functions. It covers data base development; data model creation and management; business intelligence basics, VBA usage in business tasks optimization..
Course project is aimed to consolidate knowledge that was acquired in previous two courses “Business intelligence technologies I” and “Business intelligence technologies I”. In this project students have to show their abilities to use gained skills dealing with practical issues. Course project is written according to regulations written by professor..
Goals and objectives
of the course in terms
of competences and skills
The goal of the subject is to teach students to use MS Excel for solving various data analysis challenges. Course implementation tasks: • to understand the role of economic approaches. • Ability to use computer programs (Excel, VBA) for the economic challenges. • Ability to use available data to creating useful reports. • Ability to create and use a simple data base. •To manage the processing of information to take appropriate decisions.
Learning outcomes
and assessment
Understands steps of ETL process. Is able to consolidate large amounts of data - 1st Test Laboratory works 1 till 4
Understands the specificity of the use of data models. Freely forms reports with simple measurements. Understands the relationship principles - 2nd Test Laboratory works 5 till 8
Is able to integrate multiple data sources and create complex reports. Understands the principles of using the DAX language. - 3rd Test Laboratory works 9 till 12
Be able to use received knowledge in practice - Course paper
Course prerequisites mathematics and informatics in the level of secondary school

[Extended course information PDF]