Information Systems

Information Systems

Relational Databases (mysql,postgres e SQL Server)

Programming Languages (python,c, c++, php, asp, or java)

The theoretical classes will be aimed at presenting content and complemented with practical problems to promote and stimulate collective discussion.

In the practical classes, some exercises will be conducted focusing on the implementation of small projects using development tools such as SQL Server, Visual Studio, Excel, and PowerBI.

Understanding the techniques and implementation models of warehousing, including the design and implementation of applications for data extraction, transformation, and integration.

Development and implementation of applications for multidimensional database systems.

Having knowledge in specific aspects of Information Systems (IS).

Being proficient in using various technologies employed in IS within the field of Business Intelligence.

SCM and CRM.
Information Systems Development Methodologies.
Data Warehousing Systems: Introduction to data warehousing; the data warehouse as an organization’s information infrastructure; environment and functional structure of a data warehouse; life cycle and incremental development of a data warehouse. Design, implementation, and administration of a data warehouse, including data extraction, transportation, transformation, and integration systems.
Modeling Tools.
Online Analytical Processing (OLAP) Systems: Fundamentals of analytical data processing; data structures for analytical data processing; optimization and dynamic restructuring of cubes; materialization of views: centralized and distributed perspectives. Administration of multidimensional database management systems.
Building ETL Pipelines with Python.
Development of multidimensional database system projects; definition of data access criteria. Use of analytical processing systems.
Development of information system projects using Visual Studio + SQL Server + Excel + Power BI Desktop + Python.

The final grade for the course unit results from the sum of components A + B + C + D, as described below:

• A (10 points) – Written examination corresponding to the regular exam period, the resit exam, or the special exam session.
• B (2 points) – Submission and assessment of at least 80% of the practical worksheets carried out during class sessions. Each worksheet may only be submitted and assessed by the student who attended the specific class session in which it was completed.Note: working students, or students undertaking an internship in the first semester, may choose either (i) to complete component B in its entirety under the same conditions as the other students, or (ii) to replace this component with an additional exam question. This choice is exclusive and irrevocable, and must be communicated through the Inforestudante platform no later than the third week of classes.
• C (3 points) – Submission, presentation, and discussion of a topic during a lecture session.
• Note: working students, or students undertaking an internship, must arrange with the lecturer the scheduling of the presentation and discussion at a mutually agreed time, to take place before the regular exam period.
• D (5 points) – Submission, presentation, and defence of a practical assignment.
• Note: working students, or students undertaking an internship, must arrange with the lecturer the scheduling of the presentation and discussion at a mutually agreed time, to take place before the regular exam period.

Remarks

Components B, C, and D will each have only one submission deadline, as defined in the respective instructions.

Components B, C, and D are valid for all exam periods and cannot be repeated.

NAO