Artificial Intelligence for Data Analysis

Materials and instructions by Bojan Cestnik

Link to the course Data and Text Mining

Artificial Intelligence for Data Analysis

Materials ICT2

ICT2 Course Ia (November 11, 2025, 15:00-17:00): Data preprocessing I

Additional materials

ICT2 Course Ib (November 19, 2025, 17:00-19:00): Hands-on deep learning

Intructions

QTvity collaboration:

Questions and Answers activity: QTvity
Course pwd: AIDA2026

Points for QTvity collaboration during the course lectures in 2025/26:

    19. 11. 2025Total
No. Student Ans.PtsΣ andΣ pts
1Denica    
2Georgi    
3Adrian    
4Farid    

Domain and data for practical demostrations

Domain description and data sets: ASHRAE - Great Energy Predictor III

Training datasets can be downloaded as zip file from ASHRAE_data.zip (108 MB).

Initial script in R can be downloaded from Kaggle_EC_begin.R.

ER diagram for three data files (tables): METER, BUILDING, WEATHER:

ER diagram of ASHRAE

Literature:

Gordon S. Linoff. Data Analysis Using SQL and Excel. Wiley, 2008.

Dorian Pyle. Data Preparation for Data Mining. Morgan Kaufmann, 1999.

Gerhard Widmer et al. In Search of the Horowitz Factor. AI Magazine, 2003.

Last update: 17. 11. 2025