business intelligence and data warehouse

• process of transforming data into something useful for decision making

data warehouse (dwh)

• is a repository that stores information for the decision making process

• integrated and consistent (no delete or update, only add) (automated data collection process)

• it show data evolution overtime

multidimensional model

• in a DWH data are organized in a multidimensional structure that store data based in categories

this model can be explored interactively by the user through OLAP queries