A carregar...
Publicação
Business Intelligence e Ciência de Dados Aplicados ao Mercado de Arrendamento Estudantil - Uniplaces
| Nome: | Descrição: | Tamanho: | Formato: | |
|---|---|---|---|---|
| 5.84 MB | Adobe PDF |
Orientador(es)
Resumo(s)
O presente relatório descreve o trabalho desenvolvido no âmbito do Estágio Curricular do Mestrado em Ciência de Dados, realizado na empresa Uniplaces, integrando o departamento financeiro. O estágio teve como principal propósito a aplicação prática de competências analíticas na função de Data Analyst Intern, assumindo um papel transversal na otimização dos fluxos de informação e no suporte à tomada de decisão estratégica de todas as equipas da organização.
A crescente importância da Ciência de Dados no panorama empresarial contemporâneo reside na capacidade de transformar vastos volumes de dados brutos em conhecimento estratégico. Através da implementação de processos analíticos e da automatização de fluxos de informação, torna-se possível mitigar a ambiguidade na tomada de decisão, otimizando recursos e identificando oportunidades de crescimento baseadas em evidências empíricas, fundamentais para a competitividade em mercados dinâmicos.
As atividades técnicas centraram-se na gestão do ciclo de vida dos dados, desde a extração até à visualização final, servindo as necessidades de múltiplos departamentos. O trabalho envolveu a utilização de linguagem SQL (Structured Query Language) para a manutenção de bases de dados, bem como a criação de scripts de automação e lógicas complexas em folhas de cálculo (Google Sheets). Complementarmente, foram desenvolvidas soluções de Business Intelligence recorrendo a ferramentas como Looker Studio e Tableau. Destaca-se a intervenção na correção de scripts de extração, na resolução de inconsistências de dados e na estruturação de mecanismos automáticos para a priorização de tarefas.
Os contributos do estágio traduziram-se num aumento significativo da integridade da informação corporativa e na eficiência dos processos de análise. Através da centralização de métricas e da automatização de relatórios, foi possível transformar grandes volumes de dados brutos em insights acionáveis para as diversas áreas de negócio. Este percurso permitiu consolidar conhecimentos técnicos em manipulação e visualização de dados, demonstrando o valor acrescentado da Ciência de Dados num contexto empresarial dinâmico.
This report describes the work carried out as part of the Master’s in Data Science placement, undertaken at Uniplaces within the finance department. The main purpose of the placement was the practical application of analytical skills in the role of Data Analyst Intern, taking on a cross-functional role in optimising information flows and supporting strategic decision-making across all teams within the organisation. The growing importance of data science in today’s business landscape lies in its ability to transform vast amounts of raw data into strategic insights. Through the implementation of analytical processes and the automation of information flows, it becomes possible to reduce uncertainty in decision-making, optimise resources and identify growth opportunities based on empirical evidence, which are fundamental to competitiveness in dynamic markets. The technical activities focused on data lifecycle management, from extraction to final visualisation, serving the needs of multiple departments. The work involved using SQL for database maintenance, as well as creating automation scripts and complex logic in spreadsheets (Google Sheets). In addition, Business Intelligence solutions were developed using tools such as Looker Studio and Tableau. Notable contributions included correcting extraction scripts, resolving data inconsistencies and structuring automated mechanisms for task prioritisation. The contributions made during the internship resulted in a significant improvement in the integrity of corporate information and the efficiency of analytical processes. Through the centralisation of metrics and the automation of reporting, it was possible to transform large volumes of raw data into actionable insights for various business areas. This experience enabled the consolidation of technical knowledge in data manipulation and visualisation, demonstrating the added value of Data Science in a dynamic business environment.
This report describes the work carried out as part of the Master’s in Data Science placement, undertaken at Uniplaces within the finance department. The main purpose of the placement was the practical application of analytical skills in the role of Data Analyst Intern, taking on a cross-functional role in optimising information flows and supporting strategic decision-making across all teams within the organisation. The growing importance of data science in today’s business landscape lies in its ability to transform vast amounts of raw data into strategic insights. Through the implementation of analytical processes and the automation of information flows, it becomes possible to reduce uncertainty in decision-making, optimise resources and identify growth opportunities based on empirical evidence, which are fundamental to competitiveness in dynamic markets. The technical activities focused on data lifecycle management, from extraction to final visualisation, serving the needs of multiple departments. The work involved using SQL for database maintenance, as well as creating automation scripts and complex logic in spreadsheets (Google Sheets). In addition, Business Intelligence solutions were developed using tools such as Looker Studio and Tableau. Notable contributions included correcting extraction scripts, resolving data inconsistencies and structuring automated mechanisms for task prioritisation. The contributions made during the internship resulted in a significant improvement in the integrity of corporate information and the efficiency of analytical processes. Through the centralisation of metrics and the automation of reporting, it was possible to transform large volumes of raw data into actionable insights for various business areas. This experience enabled the consolidation of technical knowledge in data manipulation and visualisation, demonstrating the added value of Data Science in a dynamic business environment.
Descrição
Palavras-chave
Ciência de Dados Business Intelligence SQL Visualização de Dados Automação