To analyze the Online Booking Orders to help Management review the current performance of the Business in order to make strategic decisions.
- The business problem was defined and the right data was collected.
- The data was driven towards report ready and tailored to suit the business question.
- Some analysis was carried out on the data which involves formular insertion, creation of new column, insertion of pivot table and charts.
- Reports were generated which was used to prepare a dashboard.
- Dashboard Visuals were used to gain insight on the business performance and in making recommendations for strategy business decisions.
- For the period under consideration the business made a Total profit of 6.79M with a total settled booking transactions of 66,535.
- From the Business performance chart, the business shows a consistency in growth year on year which speaks to the effectiveness of the different initiatives deployed by the company in increasing market share and improving sales. The Customer ratings is a testament to this performance as the Business received a rating of Good as first rank rating and Excellent as the second rank rating and these speaks volume to the Business growth and potentials.
- Speaking about the Business Partners, All the financial institutions had even distribution of customer preference and this shows their significant contribution to the business together with the different payment mode used.
- Callout of the Top 10 Hotels based on customer preference was also made in line with customer preferred duration of stay at the hotel.
