Quantity
Proven Formula
Price per Transaction
Numbers of Products for each Product key
Product Centric
x Avg Sale Amount
Numbers of Transaction for each Channel
Channel
x Avg Sale Amount each Channel
Numbers of Transaction each Year
Date
x Avg Sale Amount each Year
Numbers of Transaction for each Country
Geography
Descriptive Category x Avg Sale Amount each Country
Numbers of Transaction for each Product
Product
x Avg Sale Amount each Product
Numbers of Transaction for each Store
Transaction Centric Store
Dimensional Analysis
x Avg Sale Amount each Store
umbers of Transaction for each Product
N
at each Channel
umbers of Transaction for each Product
N
Packaging Algebra Structures Diagnostic (Cat-Cat) at each Store
Unattractive products
Ingredients
umbers of Transaction for each Product
N
at each Country
Obsolete channels
Internal factors
Increase store traffic
Ineffective advertising Numbers of Sales per store
Increase % shoppers
High price Channel Centric Sales per Store
Increase Quantity bought
New, better products Size of the basket
1
Increase avg revenue per product
Drop price Competitors
Numbers of Customer
Shift to different distribution channels Customer Centric
x Avg Sale Amount
Business Environment
External factors
Store 1. % of visitors visit store 2. % of those put product into cart 3. % of those who buy
Economic Growth
Opposite Words
Online 1. % of visitors stay on site 2. % of those visit product page 3. % of those put product into cart 4. % of those who buy
Behavior Funnel method
Customers' changes Catalog Sale Amount of Agency each time period
Income Agency
Reseller
Supply
2 Channel Sale Amount per Channel
Demand
Date Sale Amount of all Transaction
verage Sales Price = Sale Amount/ Sale
A Sum of segments Geography Sale Amount all Geography
Quantity Hierachy
Pricing Product Sale Amount all Product
Category Price
Price Mix Store Sale Amount all Store
% Numbers in category
Contoso Sales
% new customer -> Ship dates New customer
Analysis Store Ppl visit stores Ppl pickup product % of pickers that buy $ spent per buyer
Channel
umbers of new stores (market
N
Others channel
penetration)
Lost customer Process Structures
Customer Customer Customers know product Customers find it in selling channel Customers get interested to buy Customers pick up from shelves
Numbers of closed stores (attrition rate)
Income
Year
Job
Demographic Current customer Quarter
Age
Month
Date
Family situation
Day
Units by Categories
New Product Is Work day?
% new product sales/ Total Sales Conceptual Frameworks
Product easons: AsiaSeason,
S
NorthAmericaSeason, EuropeSeason
Unit sold/ location/ month
Rate of Sales
City
Shipments
State/ Province
completed orders = Actual shipped/
%
Geography
Total Orders
Region/ Country
Level of complete
on-time orders = Actual Ship Date -
%
Order Date Continent
Service
Long lead-time Product name
Inventory issue Problems Product description
Product unavailable Manufacturer
ales per person = Amount sales/
S egmentations
S Brandname
numbers of salesman
(Descriptive Numerical)
Sales-person Classname
Compare with quota
Colorname
Size
Product
Weight
WeightUnitMeasure
UnitCost
UnitPrice
Product Category
Product Sub Category
Store
Channel Channel name
