BIPower BI for Designers

Sales Performance Model

One star schema: Sales and Targets facts surrounded by shared dimensions. All reports in this workspace bind to this model.

Sales.Customer ID → Customers.Customer IDSales.Product ID → Products.Product IDSales.Region ID → Regions.Region IDSales.Channel ID → Channels.Channel IDSales.Order Date → Calendar.DateTargets.Date → Calendar.DateTargets.Region ID → Regions.Region IDSalesfact · 36 fieldsCustomersdimension · 7 fieldsProductsdimension · 8 fieldsRegionsdimension · 5 fieldsChannelsdimension · 3 fieldsCalendardimension · 11 fieldsTargetsfact · 6 fields

Relationships

  • Sales.Sales.Customer ID → Customers.Customers.Customer ID (many-to-one, single)
  • Sales.Sales.Product ID → Products.Products.Product ID (many-to-one, single)
  • Sales.Sales.Region ID → Regions.Regions.Region ID (many-to-one, single)
  • Sales.Sales.Channel ID → Channels.Channels.Channel ID (many-to-one, single)
  • Sales.Sales.Order Date → Calendar.Calendar.Date (many-to-one, single)
  • Targets.Targets.Date → Calendar.Calendar.Date (many-to-one, single)
  • Targets.Targets.Region ID → Regions.Regions.Region ID (many-to-one, single)

Hierarchies

  • Date Hierarchy
    Year → Quarter → Month Name → Day
  • Geography
    Continent → Country → Region
  • Product Hierarchy
    Category → Subcategory → Product Name

Measures (22)

MeasureEntityFormatDescription
Total RevenueSales—Sum of Revenue across the filter context.
Total CostSales—Sum of Cost across the filter context.
Total MarginSales—Total Revenue minus Total Cost.
Margin %Sales—Total Margin divided by Total Revenue.
Total OrdersSales—Distinct count of Order ID.
Total UnitsSales—Sum of Quantity.
Total CustomersSales—Distinct count of Customer ID.
Average Order ValueSales—Total Revenue / Total Orders.
Average Selling PriceSales—Total Revenue / Total Units.
Revenue per CustomerSales—Total Revenue / Total Customers.
Units per OrderSales—Total Units / Total Orders.
Revenue YoYSales—Revenue change versus the same period last year.
Revenue YoY %Sales—Revenue growth versus last year.
Revenue MoMSales—Revenue change versus the previous month.
Revenue MoM %Sales—Revenue growth versus the previous month.
Margin YoYSales—Margin change versus last year.
Orders YoYSales—Order change versus last year.
Revenue TargetSales—Target revenue from the Targets table.
Revenue VarianceSales—Total Revenue minus Revenue Target.
Revenue Variance %Sales—Revenue variance relative to target.
Margin TargetSales—Target margin from the Targets table.
Margin VarianceSales—Total Margin minus Margin Target.