Enterprise Information SystemsLaajuus (5 cr)

Objective

After passing the course the student can Knows how to process Data using Pivot Table tools and functions i.e. Vlookup, Hlookup, Offset, Sumifs, Match Knows when to use VBA macro tools to analyze information osaa jalostaa tietoa hyödyntäen sekä Pivot toimintoa että keskeisimpiä Excelin funktioita tunnistaa VBA-makrojen hyödyntämismahdollisuuden analysoinnin välineenä know the relationship between business and datasystems know the most important types of datasystems in companies know the tasks of IT-adminitration know the facts concerning outsourcing

Content

Pivot Fuctions i.e. Vlookup, Hlookup, Offset, sumifs, match Masterdata and trasnactiondata Different kinds of datasystems BI-systems Different types of IT-administration Outsourcing