Week 5

Question 1

Managing information systems (MIS)

Answer 1

Enabling technology for delivering the right information, to

right recipient, at right time and supporting decision-making process

Question 2

Data base
Data warehouse
Data mart
Data lake

Answer 2

1. Data warehouse
   all data / Higlhy structured / General purpose
   Analyst but more advacned
2. Data mart
   subset specific / purpose built /Analyst
3. Data lake
   all lake / structured and not structured /
   General purpose / data sceintist / A lot of money /
   health care providers

Question 3

Static Analytics

Answer 3

Forensic audit for a fraud event.
u Analysis of change in financials due to change in strategy.
u Cost – Benefits analysis for specific business case or project.

Question 4

Dynamic Analytics

Answer 4

Dashboards – Performance (KPIs), Risk (KRI) and so on.
Monthly, quarterly or annual regulatory or financial report.
Stock price analysis
Covid statistics dashboard

Question 5

ETL and ELT

Answer 5

ETL Extract transform loaded
example of the dates that comes from different sources and different format

ELT Extract loaded transform

Remember the example of projects,, they start iterating but don’t know the goal of the projects