Mark. We not only need strategy data analysis on greeting cards and magazines, but also need real time data analysis for quick response.
For example, our sales on milk and juice tripled over last 4 years. We write a utility to calculate how many bottles of milk we sold between last delivery to now, time period detailed in minutes, and calculate how many bottles of milk we sold in last week, between the incoming delivery (say last Tuesday) to the next incoming delivery date (say last Thursday), time period detailed in minutes, based on the two historical figures, we calculate the order qty and adjust it with special events (school holiday, weather).
Our wastage and shortage of milk and juice has been minimized, suppliers provide extra support and increase the delivery frequency which in turn further reduce our wastage and shortage events, and increase our sales.
Real time analysis also used in many situations:
Such as import the suppliers data file of major/monthly/seasonal promotion, calculate the monthly and yearly sales data, and place order based on investment buy or shop plans on promotional activities.
Such as monitoring all key SKUs and take rapid response when majors has half price promotions.
Mark. We not only need strategy data analysis on greeting cards and magazines, but also need real time data analysis for quick response.
For example, our sales on milk and juice tripled over last 4 years. We write a utility to calculate how many bottles of milk we sold between last delivery to now, time period detailed in minutes, and calculate how many bottles of milk we sold in last week, between the incoming delivery (say last Tuesday) to the next incoming delivery date (say last Thursday), time period detailed in minutes, based on the two historical figures, we calculate the order qty and adjust it with special events (school holiday, weather).
Our wastage and shortage of milk and juice has been minimized, suppliers provide extra support and increase the delivery frequency which in turn further reduce our wastage and shortage events, and increase our sales.
Real time analysis also used in many situations:
Such as import the suppliers data file of major/monthly/seasonal promotion, calculate the monthly and yearly sales data, and place order based on investment buy or shop plans on promotional activities.
Such as monitoring all key SKUs and take rapid response when majors has half price promotions.
Sunny, as I’ve noted here for years, my focus here is not on convenience as I don’t see commercially valuable upside.