profit margin

1. Overview

Purpose of measure

Measure Code

  • Strapi:

  • OLAP:

  • LUIS:

2. Data design

Data source

OLAP Design

3. Strapi Question Design

3.1.Available dimensions for ""

  • by_store
  • by_category
  • by_sku
  • by_subcategory
  • by_coupon
  • by_customer Group
  • by_channel
  • by_order_status
  • by_day
  • by_week
  • by_month
  • by_quarter
  • by_year

3.2.Available filters for ""

  • FilterStore
  • FilterSku
  • FilterProduct
  • FilterCategory
  • FilterSubcategory
  • FilterSalesChannel
  • FilterCustomerGroup
  • DatetimeV2
  • FilterDay
  • FilterWeek
  • FilterMonth
  • FilterQuarter
  • FilterYear

3.3.Question Parameter

Measure

Dimension

Select a dimension that match with the type of question.

.....

Chart type

3.4.Expected Result

profit-1.png

profit-margin-by-category.png

top-profit-sku.png

profit-by-store.png

profit-of-sku.png

3. LUIS Training

3.1 Question to ask

  • Profit Margin

  • Profit Margin last month

  • Profit Margin by store

  • Profit Margin by category

  • Profit Margin by subcategory

  • Profit Margin by sku

  • Profit Margin of store "a store"

  • Profit Margin of category "a category"

  • Profit Margin of sku "a sku"

  • Profit Margin of subcategory "a subcategory"

fGfprofit-1.png

3.2 MeasureList:

profit-2.png

3.3 Luis Training

profit-3.png