Online Retail - Algoritma Trial Class
Team Algoritma
August 30, 2021
Slide ini dibuat untuk kebutuhan Trial Class Algoritma
Trial Class ini adalah pengalaman belajar singkat di kelas Algoritma. Materi trial class ini berupa data wrangling, visualisasi, dan membuat laporan.
Studi Kasus: Online Retail
Sampel Data Retail
| Row.ID | Order.ID | Order.Date | Ship.Date | Ship.Mode | Customer.ID | Segment | Product.ID | Category | Sub.Category | Product.Name | Sales | Quantity | Discount | Profit |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | CA-2016-152156 | 11/8/16 | 11/11/16 | Second Class | CG-12520 | Consumer | FUR-BO-10001798 | Furniture | Bookcases | Bush Somerset Collection Bookcase | 261.9600 | 2 | 0.00 | 41.9136 |
| 2 | CA-2016-152156 | 11/8/16 | 11/11/16 | Second Class | CG-12520 | Consumer | FUR-CH-10000454 | Furniture | Chairs | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back | 731.9400 | 3 | 0.00 | 219.5820 |
| 3 | CA-2016-138688 | 6/12/16 | 6/16/16 | Second Class | DV-13045 | Corporate | OFF-LA-10000240 | Office Supplies | Labels | Self-Adhesive Address Labels for Typewriters by Universal | 14.6200 | 2 | 0.00 | 6.8714 |
| 4 | US-2015-108966 | 10/11/15 | 10/18/15 | Standard Class | SO-20335 | Consumer | FUR-TA-10000577 | Furniture | Tables | Bretford CR4500 Series Slim Rectangular Table | 957.5775 | 5 | 0.45 | -383.0310 |
| 5 | US-2015-108966 | 10/11/15 | 10/18/15 | Standard Class | SO-20335 | Consumer | OFF-ST-10000760 | Office Supplies | Storage | Eldon Fold ’N Roll Cart System | 22.3680 | 2 | 0.20 | 2.5164 |
Gambaran Umum: Total transaksi
Kasus 1:
Bagaimana perbedaan proporsi jenis pengiriman barang? mode pengiriman apa yang paling sering digunakan?
| Ship.Mode | jumlah | proporsi |
|---|---|---|
| Standard Class | 5968 | 0.60 |
| Second Class | 1945 | 0.19 |
| First Class | 1538 | 0.15 |
| Same Day | 543 | 0.05 |
Kasus 2:
Pada Category dan Segment apa terdapat rata-rata profit tertinggi dan terendah?
| Segment | Category | mean_profit |
|---|---|---|
| Home Office | Technology | 89.152 |
| Corporate | Technology | 79.724 |
| Consumer | Technology | 74.446 |
| Home Office | Office Supplies | 24.034 |
| Corporate | Office Supplies | 22.103 |
Kasus 3:
Siapa customer (Customer.ID) yang membuat profit paling besar untuk masing-masing Segment?
| Customer.ID | Segment | max_profit |
|---|---|---|
| RB-19360 | Consumer | 6719.981 |
| TC-20980 | Corporate | 8399.976 |
| TA-21385 | Home Office | 3919.989 |
Kesimpulan
Dari hasil pengolahan kita tau bahwa:
Bagaimana perbedaan proporsi jenis pengiriman barang? mode pengiriman apa yang paling sering digunakan?
Standard Class dengan proporsi 59.7% dari seluruh jenis pengiriman
Pada Category dan Segment apa terdapat rata-rata profit tertinggi dan terendah?
Home Office dari category Technology menghasilkan rata-rata profit tertinggi, sedangkan Segment Consumer dari category Furniture menghasilkan rata-rata profit terendah.
Siapa customer (Customer.ID) yang membuat profit paling besar untuk masing-masing Segment?
- Segment Consumer: RB-19360
- Segment Corporate: TC-20980
- Segment Home Office: TA-21385