Abstract

This project focuses on analysing sales data to ensure a distinct understanding of National Tickets company as well as derive effective and constructive business decisions. According to National Tickets executives, the company has not been able to track trends in their sales data for the past years and they consider the lack of analysing sales data is the chief contributor to the near demise of their business. The primary aim of this project is to ensure detailed and transparent insights are drawn from the sales data provided by National Tickets, to instigate valuable and well-thought-out business decisions. The system of gathering, cleaning, manipulating and visualising data aids an organisation’s executives to make informed decisions (Kościelniak et al, 2015).

Data analysis is one of the essential processes that ought to be performed for business success this is because data-driven companies can experiment with numerous value propositions on different segments of clients to ascertain which are most effective. In addition, analysing sales data exposes many valuable insights that the company can utilise to cut costs and improve productivity.

To satisfy the request from National Tickets executives I utilised data cleaning and analytics tools such as Microsoft Excel and Python, and the Streamlit tool, which supports website application building, is utilised to ensure results are presented distinctively to the end user. It is of vital importance to note that results attained indicated that most of National Tickets' clients are individual clients and therefore there is an urgent need to create marketing strategies tailor-made for corporate clients to maximise profits. Additionally, the difference noted between the highest salesperson and the lowest salesperson in terms of sales achieved during the stipulated period, is extremely enormous and leaves a lot to be desired. National Tickets executives ought to strategise on how they can offer thorough training to their staff as well as re-strategise their recruitment process to ensure highly skilled individuals are employed for the benefit of the company. Moreover, performance audits to identify and execute tailored training to engage employees accordingly and work effectively and efficiently.

Analysing sales data to forecast business growth