You have already calculated the profit for each category and subcategory. In this segment, you will calculate the third metric: average profit per order. Let’s watch the next video and find out more about this.
You observed that the average profit per order for furniture products is low (₹75.23) compared with that of the other product categories.
In the next video, let’s compute the fourth and last metric: average profit percentage per order. While coding along with Shreyas, you must have observed that he examined each table to check whether there are any other metrics that could be useful for the analysis.
You observed that the average profit percentage per order for furniture products is quite low (2.27%) compared to the other product categories. Such low values of the average profit and profit percentage per order for furniture show that these products are not doing well. Their sale should ideally be stopped or the company should come up with a robust plan to deal with this issue.
You have now calculated all the required metrics that were specified in the problem statement. Notice how you derived additional insights by calculating the total number of orders for each product category. While performing any analysis on a data set, you should always look for additional metrics that can help you understand the trends in the data set.