RTV 2

DESCRIPTION:
The project will focus on analyzing customer transaction data from the past 3 years and the data from various channels such as online registration and physical registration and activation programs will be included. Candidate’s transaction data was extracted from the company’s google docs and excel database.

METHODOLOGY:
The data sets were brought to life as a result of a union between all tables; being Data Analytics and Business Intelligence courses for Lagos and Abuja candidates split into midweek and weekend sessions. As well as the UIUX and System Admin course products. I created the progress bar because, there was no measurement of the payment, it was done to monitor the activities of the sales team to ensure the payment dates were fully collated.
Furthermore, the results shows us a track of the candidate journey from when they found out about the business, signed up and became activated till when they got their success stories. More insights can be found in the data sets from the query.

BUSINESS BENEFITS:
This project helps to identify key customer segments, track registration and activation patterns and training method preference (Online or Physical). Applying the data sets, I was able to determine that candidates tend to prefer physical training to online training, indicating potentials for targeted upselling as the business has resources for classrooms and physical trainers/training.
Female candidates are higher in number, while a fraction of the male candidates were only present because, a female they know informed them and ensured that they paid for the class. Also, The older aged candidates prefer physical attendance than the younger candidates.

Information gathered from this data can be used to develop and target marketing campaigns towards more female prospects and focus display on physical classes being held when creating a marketing campaign

DASHBOARD:
Find live report below