The course introduces the basic techniques for the representation and exploratory analysis of data from a Business Intelligence perspective, with reference to descriptive analytics and exploratory data analysis methodologies aimed at supporting decisions in industrial and management fields.
The student will be able to design and build a simple dashboard using data from different sources.
Python programming language
Main concepts of databases
Theoretical classes and PC labs
Introduction to EDA (Exploratory Data Analysis)
Structured and unstructured data
Data preprocessing and Data wrangling
Key Performance Indicators
Date visualization
Dashboard design
Data warehousing and OLAP
Data Quality
Data Privacy
Material provided by the teacher
Python libraries: SciPy https://scipy.org and in particular the Pandas library https://pandas.pydata.org
Optional material:
C.C Aggarwal, Data mining: the textbook. Springer, 2015. [Chap.2,3] J.V. Guttag, Introduction to computation and programming using Python. MIT Press, 2013. [Chap. 16] M.J.Zaki, M.Wagner Jr., Data Mining and Machine Learning: Fundamental Concepts and Algorithms. Cambridge University Press, 2019. [Chap. 1-7] S.Few, Information Dashboard Design, 2nd Ed., Analytics Press, 2013. D. Parmenter, Key Performance Indicators, 2nd Ed., 2010. W. McKinney et al., Pandas: powerful Python data analysis toolkit, 2021
Ricevimento: By appointment.
Ricevimento: By appointment, scheduled by email.
DAVIDE ANGUITA (President)
ANTONIO EMANUELE CINA'
LUCA ONETO (President Substitute)
LUCA DEMETRIO (Substitute)
https://corsi.unige.it/en/corsi/10716/studenti-orario
The student will develop independently (individually or in cooperation with other students) a case study of their choice, among those proposed by the teacher, using one of the methodologies illustrated during the course. The oral exam will focus on the discussion of the case study.
The oral exam will allow to verify the ability to analyze and represent a set of data from different sources in order to make them usable by a hypothetical end user identified with the case study.