IVZ752 Business Intelligence Technologies II

Code IVZ752
Name Business Intelligence Technologies II
Status Compulsory/Courses of Limited Choice
Level and type Undergraduate Studies, Academic
Field of study Computer Studies
Academic staff Leonards Budņiks, Aleksandrs Fiļipovs, Vladimirs Jansons, Tatjana Tambovceva, Tatjana Celmiņa
Credit points 2.0 (3.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 task optimization..
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
Course prerequisites mathematics and informatics in the level of secondary school

[Extended course information PDF]