Dimensions : products, period and customer
Measures : Internet sales
Evaluate the sale performance for each product and customer; company can design the sale strategy such as advertising and promotion.
Order count by product line by customer report
Dimensions : , products, period and geography
Measures : Order count
Analyze number of order for each product and geography and design the plan and assign the resources for each location.
Sale by geography by employee report
Dimensions : geography, period and employee
Measures : Internet sale
Analyze number of employee for each location can generate how much sale, company can design the resources, improve the cost saving and increase process efficiency
Noted the OLAP reports you've added !
ReplyDeleteAside from units sold and sales revenue, other measures or data items may be used such as freight cost, gross profit margin, average sales amount, etc.
ReplyDelete