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
Faculty
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
Be able to use data sets for business analysis - Control test based on 10 score system
Be able to analyze data sets using MS Excel Pivot Table tool - Control test based on 10 score system
Be able to perform data mining using MS Excel BI tools - Control test based on 10 score system
Be able to use received knowledge in practice - Exam based on 10 score system
Course prerequisites mathematics and informatics in the level of secondary school

[Extended course information PDF]