sales_overview

1. Overview

Purpose of measure

  • This is a composition measure to show the report of other business measures about sales like: Total sales, Net sales, profit margin %, Gross Sales, Invoices in a period of time.

  • We also provide the comparasion with the same previous of time (vs previous week, vs previous month, vs previous year)

Measure Code

  • Strapi: sales_overview

  • OLAP:

  • LUIS: sales_overview

2. Data design

Data source

OLAP Design

3. Strapi Question Design

3.1.Available dimensions for "sales_overview"

  • 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 "sales_overview"

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

3.3.Question Parameter

Measure

sales_overview

Dimension

Select a dimension that match with the type of question.

  • by_store => dimension is store
  • by_category => dimension is category .....

Chart type

There are two types of question for sales_overview measure**

  • Summary table with measures as rows and comparasion as columns

strapi-sales-overview-table.png

  • By a dimension with values of the dimension as rows and the data comparasion as columns

strapi-sales-overview-by-store-chart.png

3.4.Expected Result

sals-overview-yesterday.png

3. LUIS Training

3.1 Question to ask

  • Sales summary this month
  • Sales by store last month
  • Sales of category apple from 10 feb to 15 feb
  • Sales by category
  • Sales by subcategory
  • Sales by channel
  • Sales by SKU
  • Daily sales this month
  • Weekly sales this quarter
  • Monthly sales this year
  • Sales of sku 8905 this week

3.2 MeasureList: sales_overview

sales-overview-phrase-list.png

3.3 Luis Training

luis-sales-overview-straing-labeling.png