Skip to main content

ISLA IPGT 26070

Data Analysis Tools

Tourism, Hotel and Restaurant Management
  • ApresentaçãoPresentation
    The course module "Data Analysis Tools" aims to equip students with fundamental skills in the manipulation, exploration and interpretation of data, combining knowledge of descriptive statistics and digital tools, with a particular focus on Microsoft Excel and Power BI   Scope and Field of Application This course module falls within the field of data analysis and processing, with applications across various disciplines, such as management, economics, engineering, social sciences and health. The knowledge acquired will be essential for data-driven decision-making and for solving quantitative problems in different professional contexts.   (Areas of Intervention) Students will learn to: Apply descriptive statistics to data analysis Use Excel to process and visualise information; Create basic regression models and interpret results; Build pivot tables and dashboards to support decision-making.
  • ProgramaProgramme
    1. Descriptive statistics Measures of central tendency and dispersion, graphical representation of data, simple linear regression and confidence intervals. 2. Excel for data analysis Basic functions and statistical functions, filters, sorting, lookup and reference functions, and creating custom charts. 3. ETL and data preparation The concept of ETL, data processing and structuring, integration of data sources and preparation for analysis. 4. Power BI, pivot tables and dashboards Introduction to Power BI, data modelling, creating pivot tables, data segmentation, custom calculations, DAX measures and building interactive dashboards.
  • ObjectivosObjectives
    Knowledge Understand the key concepts of descriptive statistics, linear regression and confidence intervals, as well as the main features of Excel and Power BI for data analysis and visualisation.   Skills Apply statistical techniques to data analysis, use Excel and Power BI to process information, and build pivot tables and interactive dashboards.   Competencies Interpret and communicate statistical results clearly, using digital tools to support data-driven decision-making
  • BibliografiaBibliography
    Levine, D. M., Stephan, D. F., & Szabat, K. A. (2017). Estatística: Teoria e Aplicações Usando o Microsoft Excel em Português (7ª ed.). São Paulo: Pearson Education do Brasil. 784 páginas. ISBN 978-85-221-2765-0. Spiegelhalter, D. (2019). A Arte da Estatística: Como Aprender com Dados . Lisboa: Temas e Debates. 448 páginas. ISBN 978-989-644-587-3. Wheelan, C. (2017). Estatística: O que é, para que serve, como funciona . Rio de Janeiro: Zahar. 320 páginas. ISBN 978-85-378-1032-8. Walkenbach, J. (2018). Excel 2019 Bible . Indianapolis: Wiley. 1120 páginas. ISBN 978-1-119-51479-2. Jelen, B., & Alexander, M. (2018). Microsoft Excel 2019: Data Analysis and Business Modeling (6ª ed.). Redmond: Microsoft Press. 624 páginas. ISBN 978-1-5093-0616-9.
  • MetodologiaMethodology
    Use of visual aids Use of infographics, diagrams and graphical representations to illustrate statistical concepts, data processing procedures and the features of Excel and Power BI. Practical teaching using digital tools Real-time, teacher-led demonstrations applying the course content in Excel and Power BI, using real-world datasets for exercises in data analysis, interpretation and visualisation. Ongoing support and feedback Support sessions to answer questions, monitor students' progress and provide regular feedback, with a view to reinforcing learning and improving performance.
  • LínguaLanguage
    Português
  • TipoType
    Semestral
  • ECTS
    6
  • NaturezaNature
    Mandatory
  • EstágioInternship
    Não
  • AvaliaçãoEvaluation

    Teste de avaliação Parte A ( 20% ) + Teste de Avaliação Parte B ( 30% ) +

    Trabalho prático - Dashboard Ultima aula do semetre (apresentação) .Submissão até às 23h59 do dia anterior dos ficheiros no Moodle. 50%

    Avaliação por Exame da Época Normal ou de Recurso, com valorização de 100%.