TY  - JOUR
T1  - Dimensional Modeling of ICT Competencies
JO  - Revista EIA 
VL  - 10
IS  - 20
SP  - 39
EP  - 54
PY  - 2013/12//
T2  - Modelamiento Dimensional de Competencias en TIC
AU  - Mendoza, Martha
AU  - Mendoza, Jaime
AU  - Zuńiga, Deyro
AU  - Moreno, Jorge
AU  - Cobos, Carlos
SN  - 1794-1237
DO  - 
KW  - Dimensional modeling
KW  - Data Warehouse
KW  - OLAP
KW  - Competencies in Information and Communication Technology (ICT)
AB  - Some Latin American countries are developing programs that allow their educational communities to have greater access to in Information and Communication Technology (ICT). In order to verify the effectiveness of these programs is necessary to measure the ICT skills acquired by the members of these communities. This paper presents a dimensional model for a data warehouse that enables the analysis of information related to the appropriation of ICT skills by teachers and students of educational institutions. The design cases are based on Ralph Kimball’s proposals: many to many relationship, heterogeneous products, subdimension and organizational hierarchy. There is also a new design case called “Dimension with measures”, which together with a fact table and calculation of measures based on MDX functions allows weighted analysis of the competences of the actors in the educational institutions. This new design case can be used in other contexts that require recursive calculations of weighted numeric attributes on hierarchical organizational dimensions within a data warehouse. Finally, the main components of a Decision Support System (DSS) developed for the “Computers for Education” (CPE) program in partnership with the University of Cauca are presented. The DSS System can be replicated in other programs with similar objectives.
ER  -