21th Marzo 2023
During the months of February and March, Professor Francisco Ruiz, a colleague of the Alarcos group, has taught at the ESI the classroom course "Data Analysis with Power BI", dedicated to learning how to carry out data analysis and visualisation projects with the Microsoft Power BI tool, considered the world's leading technology.
The students of the course were ESI students, active IT professionals and also graduates of other degrees, such as business administration or chemical engineering. They have learned in a practical way, carrying out a project chosen by themselves: to analyse the situation of women in university studies in Spain. The students worked with real student data according to the university (the 85 existing in Spain), the level of studies (bachelor's, master's and doctorate) and the subject of the studies (at various levels of breakdown). They first extracted data from the sources and transformed and loaded them into a repository in Power BI. Then they have designed the data model with a star schema and created some measures to make calculations. Finally, they have created an interactive application to analyse and visualise the data, including tables, various graphs, maps and some artificial intelligence options.
This teaching activity is part of Francisco Ruiz's dedication to Data Science and Engineering, one of the current axes of the great change in our world and which we have incorporated into our own name: ALARCOS - Software and Information for a Digital and Sustainable World.