Interview Query

Evaluating Revenue Decline

Have you seen this question before?

An ecommerce company is experiencing a reduction in revenue for the past 12 months. You have the following transaction data:

  • Date of sale

  • Total $ Amount paid by customer

  • Profit Margin per unit

  • Quantity of item

  • Item category

  • Item subcategory

  • Marketing attribution source

  • % discount applied

How would you analyze the dataset to understand exactly where the revenue loss is occurring?

Next question: Active User Probability
MySQL 8.0.17
Loading editor
Use Shift + Enter to run query