Group Assignment: Post #2

Try to make use of OLAP Service Online Demo

Report 1: Internet Order Quantity by Product by Customer by Date

We can see the flow of the product, sales volume in particular period, how popular of the product easily in this report.

Purchase department can forecast the quantity of up coming orders by seeing the report. They can estimate how many quantity do each customer needs in a particular period, say monthly. By knowing the quantity of each product of order for each customer, marketing and sales department can find out what kind or which style of product that their customer would like. And, base on the data to develop next project.

Report 2: Sales Amount by Product by Sales Channel by Date

By seeing the sales amount of each channel, sales can know what kind and how much resourse should put into which channel. They could consider which kind of promotion should use in which channel to increase amount. Sales can also know which kind of product should sell by which chanel. Purchase department can forecast the quantity for each chanel.

Report 3: Reseller Sales Amount by Geography by Product by Date

According to this report, sales could know what kind of product is more popular in which area. They can plan the promotion and sales project depend on the sales amount of the product according to different area. Purchase can find out how many product sold by particular period and arrange the next order.