Let’s start solving the business problem by calculating the metrics that we discussed in the previous segment. In the next video, you will write the queries that are required to find the profits for all the product categories and subcategories. Which of the metrics (if any) discussed in the previous segment are actually useful? Let’s watch the video and find out.
As you learnt in this video, all the product categories report good profits. Hence, they do not contribute to the solution, as you cannot identify the reasons for any loss that the company is facing. However, the profit per product category is still an important metric that can be used for creating business reports. The profit per product subcategory is a useful metric, as it shows the subcategories that report heavy losses.
Before calculating the third metric, let’s first find out if there is any relation between the Order IDs table and the Order Numbers table.
As Shreyas explained in this video, the Order IDs table and the Order Numbers table do not have a one-to-one relation. Why does this matter? It proves that there are customers who have ordered products more than once. It is important to identify frequent customers so that you can offer discount coupons to them in exchange for their loyalty.