Report 1 - Gross Profit Margin by Date by Product by Sales Channel
Measures: Gross Profit Margins
Dimensions: Date, Sales Channel, Products
Insights:
#1 Gross profit margins of accessories (product) is the highest across the product-lines, sales channels and the period FY02-04.
#2: Gross profit margins of selling bikes (product) through Resellers (channel) are low, but it is highly profitable selling through internet (Channel).
#2: Gross profit margins of selling bikes (product) through Resellers (channel) are low, but it is highly profitable selling through internet (Channel).
#3: It is highly profitable selling clothings (product) through internet (channel), and is a new product since FY2004
Implications: The company can improve its financial performance by using the right product line-sales channel mix, i.e. selling bikes through internet, but discontinue selling through resellers.
Report 2 - Discount Percentage, Average Unit Price and Gross Profit Margin by Product by Promotion
Screen shot on Dundas OLAP Services Online
Measures: Discount Percentage, Average Unit Prices and Gross Profit Margins
Dimensions: Promotion (sorted by promotions of Resellers), Product and Date
Insight: Company incurs substantial lost on clearing inventory for excess goods and discontinued products.
Implications: Review and optimized demand forecasting and /or supply chain planning toer on stock out instead of mark down.
Report 3: Internet Sales Amount by Customer by Sales Territory by Product
Screen shot on Dundas OLAP Services Online
Measures: Internet Sales Amount
Dimensions: Sales Territory, Product Category and Gender of customer demographics
Insights:
#1: North America region has bring largest sales amount to the company
#2: Bikes is the best selling category amongst the others, but sales performance for clothings are not impressive.
#3: Female and Male customers spending patterns are similar
Implications:
Company should continue all 3 regions for internet selling, but they should develope new marketing plan for targeting Asia Pacific. As the sales performance for clothings are low, probably due to the sizing problems, more pictures, indications or information about the sizing should be provided for the target customers, or appropriate aftersales services should be provided as well to increase the sales on clothings.
發表文章
These reports are well-organized and the insights/implications you have derived from them are excellent as well.
回覆刪除OLAP allows users to quickly and interactively get answers to complex questions such as these. These kinds of capabilities are not possible with database reporting software alone (e.g. MS ACCESS).