Skip to main content

IPLUSO 23557

Data Warehouse and Business Intelligence

Computer Applications for Data Science
  • ApresentaçãoPresentation
    This curricular unit aims to provide students with the knowledge and skills necessary to analyze, design and implement state-of-the-art information systems, with a view to supporting the business processes of current companies, based on different skills, preparing them for assume management and leadership positions in the technology industry.
  • ProgramaProgramme
    CP1.General concepts: Data, information and knowledge of electrotechnics/electronics CP2. Typology and functions of information systems: OLAP and OLTP systems CP3. Planning, designing and modeling in information systems: UML language CP4. Database Management System (DBMS) CP5. Decision Support Information Systems in a business and industrial context: Business Intelligence ERP- Enterprise Resource Planning SCM - Supply Chain Management CRM- Customer Relationship Management Big Data & Analytics CP6. Data Knowledge Extraction Systems: ETL - Extract, Transform & Load Data Wharehouses Data Mining KDD ¿CP7: Security and ethics in information systems  
  • ObjectivosObjectives
    LO1: Explain the main concepts and types of information systems used by organizations; LO2: Make known the context of Information Systems and their role in the management of organizations, particularly in the field of decision-making support and business analysis; LO3:Develop the ability to design information systems, including relational database systems to support decision making in a business context; LO4: Demonstrate the ability to integrate information from the different organizational functions of a company, enhancing control and support in decision-making processes; LO5: Analyze and use information and knowledge, extracted from the information systems used by organizations, using for this purpose the most appropriate information system for each type of situation; LO6: Know, develop and appropriately use applications with a data access component, such as dashboards and other applications to support and analyze decision making;
  • BibliografiaBibliography
    Frye, Curtis - Microsoft Excel 2016 Passo a Passo. Edição em Português. Brasil. Bookman, 2016. ISBN 9788582603956. Rascão, José - Sistemas de Informação para as Organizações. Edições Sílabo. 2004. ISBN: 9789726183303. Lopez, Yanai - Sistemas de informação para a Gestão. Escolar Editora. 2013. ISBN: 9789725923740. Slides/Folhas de apoio disponibilizadas pelo docente no âmbito dos sistemas informação.
  • MetodologiaMethodology
    Theoretical-Practical teaching methodology, with interactive classes designed to introduce theoretical concepts and conduct exercises or system demonstrations. Practical classes aim to prioritize student autonomy and group work. Learning objectives (LO) (1)-(5) are assessed in two partial tests, or one exam, whose grade will be the theoretical component (TC) of the assessment. The final grade (CF) for each student will result from the application of the following formula: CF=TC*0.4+CP*0.6. The Practical Component (CP) grade is obtained by the following formula: CP=CP1*0.4+CP2*0.2. Where: CP1: Group Work CP2: Analysis and Discussion of an Academic Article To be approved for the course, the student must obtain a minimum grade of 10 in both the CP and CT.
  • LínguaLanguage
    Português
  • TipoType
    Semestral
  • ECTS
    6
  • NaturezaNature
    Mandatory
  • EstágioInternship
    Não