Product Sales Analysis

High Level Design

Overview

For retailers, understanding the sales and customers’ buying habits is highly valuable. Insights about customer satisfaction, demographics and buying price can drive decisions for marketing, sales and even inventory management.

Goals

Increase profit by optimizing the marketing efforts, increasing the number of sales and discontinue unprofitable products.

Objectives

  • Increase revenue by selling higher quantity at optimal selling price
  • Increase sales by improving marketing effectiveness through understanding of the customers’ buying habits
  • Increase profit by discontinuing products with dissatisfying revenue

KPI Architecture

Objectives KPIs Measures Data Source
Increase revenue by selling higher quantity at optimal selling price Drive sales with higher quantity per product # Orders per product Ordes, Dim products
Average quantity per order per product Orders, Order details, Dim products
Identify the optimal selling price Minimum, maximum and average selling price per product Order details, Dim products
Median selling prices for all products Order details, Dim products
Increase sales by improving marketing effectiveness through understanding of the customers’ buying habits Identify common buying habits Frequently bought together products: products bought in the same order, in more than 2 orders Orders, Order details, Dim products
# Orders trend over time and during US Holidays Orders, US Holidays, Dim Date
Identify customers satisfaction # Returning customer per product: customers with more than one order Orders, Order details, Dim customers, Dim Products
# Repeat buys per product: # of orders the same customer made per product Orders, Order details, Dim customers, Dim Products
# Customers Orders, Dim customers
Average # customers per product Orders, Order details, Dim customers, dim product
Identify customers demographics # customers by gender per product Dim customers
# customers by region per product Dim customers
# customers by Age Range per product Dim customers

Entities Relationship Diagram

Product Sales Dashboard

Plugins & Scripts Used

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation