IKH

Profitability Analysis – I psusql

In this segment, you will solve a business problem using SQL. In the first problem, you will identify the profitable product categories in the ‘market star’ schema. Let’s watch the upcoming video to get an understanding of the problem statement and learn about the metrics that can be used for solving it.

In this video, you were introduced to the problem statement, the required metrics and required tables, which can be summarised as follows:

Problem statement-Identify the sustainable (profitable) product categories so that the growth team can capitalise on them to increase sales.

Metrics: Some of the metrics that can be used for performing the profitability analysis are as follows:

  • Profits per product category
  • Profits per product subcategory
  • Average profit per order
  • Average profit percentage per order

Tables: The tables that are required for solving this problem are as follows:

  • ‘market_fact_full’
  • ‘prod_dimen’
  • ‘orders_dimen’

Report an error