On this page
Instituto Superior Técnico

LEBiom · Instituto Superior Técnico

Programming for Data Science

PCDCourse Page
  • 6 ECTS
  • 2nd Semester
  • Exam: Not specified
Overall
5
0
4
1
3
1
2
0
1
0
3.5
★★★★★★
2 ratings
Workload
Very light
0
Light
1
Moderate
1
Heavy
0
Very heavy
0
Light2 ratings

Feedback

2025/2026
★★★★★
Workload:Moderate

6 months ago

The teacher is ok, you can get by watching the mooc of the course and reading the slides, it’s important to go to the exercise class to understand how the exam questions work because they are subjective, do a lot of previous exams to understand the thought process. The exam is true or false and wrong questions discount 0.2 so it’s nit the best. The project is easy, everything you need is in the teachers website and she encourages people to use the code from there, there is a report template that you just need to fill with your results and analysis

2024/2025
★★★★★
Workload:Light

4 months ago

É muito fácil passar à cadeira, e dá muito pouco trabalho, mas não se aprende nada. Não é necessário ir às aulas de todo, apenas ao exame e opcionalmente a 3 reuniões de zoom. 50% da avaliação consiste num exame absurdo de 40 questões de verdadeiro ou falso a descontar, muitas delas subjectivas, que devem ser memorizadas com base nos exames disponibilizados dos anos anteriores. O projecto, talvez mais absurdo, consiste em preencher o template report disponibilizado com gráficos resultantes de correr o código disponibilizado sobre o dataset disponibilizado e cada um deve vir acompanhado de um...

About the course

Objectives

Students should be able to: 1. Understand the basic concepts of databases, from the user point of view, namely to manipulate and select data from a database 2. Understand the specificities and advantages of Data Warehouses: knowing how to explore datacubes through OLAP queries 3. Train classification models from tabular data and assess them 4. Obtain proficiency in data science libraries for Python

Syllabus

1. Fundamentals of object oriented programming in Python 2. Relational databases: the relational model and accessing data through SQL queries 3. Data warehousing: star schemas and data cubes; OLAP queries and languages for cubes manipulation 4. Data profiling and information visualization principles 5. Data selection and preparation: the ETL process and data integration 6. Classification: training classification models (naïve Bayes, KNN, decision trees and random forests). Models evaluation, performance estimation and overfitting. Neural networks and deep learning.

Prerequisites

Basic notions of probabilities and statistics.

Cross Competence Component

In terms of Interpersonal Skills and Information and Media Literacy, the course addresses the topics of Written Communication and Reporting, respectively, by evaluating the report produced within the project (~1% NF). Specifically, the topics of data description and information visualization detail the most appropriate elements and forms of information presentation in written form , also evaluated in the exam (~1.5% NF). Regarding Intrapersonal Skills, aspects related to Productivity and Time Management (definition of project planning and its verification) and Decision Making (discussion and justification of project decisions, against alternatives) are addressed (~2.5% NF).

Laboratorial Component

Laboratories comprise a set of analysis tasks concerning each one of the following goals: Students have to deliver programmed procedures to perform the previous tasks.

Ethical Principles

All members of a group are responsible for the group’s work In any assessment, every student shall honestly disclose any help received and sources used. In an oral assessment, every student shall be able to present and answer questions about the entire assignment and solution.

Something missing or out of date?

Assessment

Grading is based on three components: E: exam, P: project and L: labs (optional) The final grade is given by 50%E + max(10%L + 40%P, 50%P), constrained to: E>=9.5 e P>=9.5 Oral assessment when P-E>=4

Has the assessment changed, or is something missing?

Bibliography

Bibliografia Principal

Missing a book or some materials?