小弟剛來人大論壇， 嘗試找了下類似的資料但是沒找到 所以上傳了這個給大家 同時希望高手們可以提供類似的練習用項目和code。 感激不盡 第一次發帖， 如果重複了請幫忙刪除
Sample Data Trends

Find out these trends

1.       Find out the Year over year (2003 versus 2004) sales growth?

2.       Which quarter has highest Sales peak and in which month?

3.       Which territory generates the largest sales volume?

4.       Which quarter has a slight drop in sales for the year 2004?

5.       Which productline accounts for highest % of sales volume?

6.       Find out the average of orders by the customer per year? Who (customer) gave highest no of orders per year?

7.       Find out The shipping times (the difference between OrderDate and ShippedDate) for different locations.

8.       On average which customers send their payments faster?

9.       Find out the brand new customers in EMEA that will start placing orders soon.

10.   Find out the average of MSRP? And range?

11.   Each order contains how many 9 unique products?

12.   Which year contains incomplete data?

13.   Find out the % of status as shipped?