Report 1:Internat sales amount by Geography by product by date
we can see the buyer behavior and the trend in different country in this report,
therefore we can using these pattern to predict the future behavior.
And identify Cross selling opportunities among existing customers ,who are likely to buy as a result of direct mail campaigns and promotion .
As key sales period for given items . by performing market segmentation analysis as a way to fine – tune promotions and campaigns for different countries
we can see the buyer behavior and the trend in different country in this report,
therefore we can using these pattern to predict the future behavior.
And identify Cross selling opportunities among existing customers ,who are likely to buy as a result of direct mail campaigns and promotion .
As key sales period for given items . by performing market segmentation analysis as a way to fine – tune promotions and campaigns for different countries
Report 2 : Total Product Cost, Sales Amount, Gross Profit and Goss Profit Margin by Date by Product
In this report we can more understand the profit between each merchandise. We can base on the analysis to design more highest value products and identify which items can stop the manufacture. In between we should planning sales promotion for the lowest stock movement items..
In this report we can more understand the profit between each merchandise. We can base on the analysis to design more highest value products and identify which items can stop the manufacture. In between we should planning sales promotion for the lowest stock movement items..
Report 3: Order Quantity, Freight Cost and Order Count by delivery date by Geography by Product
Above analysis can help us for classify group of the shipping and production schedule.We can setup the order cut off date to centralize the order for planning the delivery to reduce the freight cost.
Above analysis can help us for classify group of the shipping and production schedule.We can setup the order cut off date to centralize the order for planning the delivery to reduce the freight cost.
Well-organized reports ! Good variety of measures are selected to appear in the reports.
ReplyDeleteRegarding Report # 1, OLAP queries can be used to detect patterns and trends in data from the past, for example, which are the peak sales periods for each product and sales region.
However, OLAP can't be used to directly predict future behavior or identify cross-selling opportunities. Data mining is needed to extract these insights from the data warehouse.