Improving operations through data collection and analysis

: a case study at The Feeting Room

Abstract

The emergence of the omnichannel marketplace has fundamentally transformed the way organisations interact with customers through various channels, highlighting the importance of a solid strategy supported by swiftly adjusting to market fluctuations and satisfying consumer preferences through precise, well-defined, and flexible plans and processes, providing a competitive advantage over competitors. This project was carried out as part of a curricular internship at The Feeting Room, focusing on improving process efficiency and integrating analysis tools to streamline and facilitate decision-making. An exhaustive examination of the procedures for product entry and returns was carried out to reveal complexities and identify shortcomings, therefore enabling the implementation of solutions. Two Excel templates were created to optimise the process of product creation, reduce errors and consequently, handle stock and mitigate information loss. These templates sped up creating products, guaranteeing precision and thoroughness in accordance with company protocols and standards. Additionally, three Power BI dashboards were constructed to collect sales, inventory, and profitability data for the Merchandising Department and Board to analyse and make educated decisions. Administrative department staff were assessed to determine the effects of implementing and using these problem-solving tools, promoting a critical view of their performance and usefulness.

Date of Award	12 Jul 2024
Original language	English
Awarding Institution	Universidade Católica Portuguesa
Supervisor	Vera Lúcia Miguéis Oliveira e Silva (Supervisor)