FRACTAL ANALYTICS INSIGHT
IMPACT
INNOVATION
ORANGE CABS CASE STUDY
CONTENTS OBJECTIVE CAR-TYPE WISE ANALYSIS DAY WISE CUSTOMER ANALYSIS
DAY WISE FARE ANALYSIS UI BASED ANALYSIS TOOLS USED CONTACT
objective To study the impact of discount offered on the Orange Cab for Sydney City using the data available of 3 weeks. Henceforth determining the insights for the model.
Car-type wise segmentation 18000 16000
Number of users
14000 12000
10000 8000 6000 4000 2000 0 Gold
Platinum Week1
Week2
Week3
Silver
Car Type Gold Platinum Silver Car Type Gold Platinum
Silver
Car Type Gold Platinum Silver
Total Users
Sum of fare
Average of fare(in $)
3714
68228
18.37
12234
367099
30.00
1255
54967
43.79
Total Users
Sum of fare
Average of fare(in $)
9326
173238
18.57
16408
514805
31.37
1374
59969
43.64
Total Users
Sum of fare
WEEK 1
WEEK 2
Average of fare(in $)
6376
113550
17.80
12739
381438
29.94
1061
43830
41.31
WEEK 3
DAY WISE CUSTOMER ANALYSIS 7000
6000
NUMBER OF USERS
5000
4000
3000
2000
1000
0 0
1
2 WEEK1
3 WEEK2
4 WEEK3
5
6
DAY WISE FARE ANALYSIS DAY
FARE (IN USD)
WEEK-1
WEEK-2
WEEK-3
0
36698
57205
62384
1
50594
82280
68737
2
68551
100224
74258
3
83125
115283
102167
4
97942
203199
103082
5
94252
118360
79055
6
59132
71461
49135
UNIQUE CUSTOMERS
WEEK-1
WEEK-2
WEEK-3
GOLD
2183
5395
3729
PLATINUM
6980
8692
7137
SILVER
723
506
603
REPEAT CUSTOMERS
WEEK-1
WEEK-2
WEEK-3
GOLD
1531
3931
2647
PLATINUM
5254
7716
5602
532
868
458
SILVER
Device
UI BASED ANALYSIS
bada java orange.com sms symbian windows-phone
Device bada java orange.com sms symbian windows-phone
Device bada java orange.com sms symbian windows-phone
Gold
Platinum Silver Grand Total
423
1056 85 15 29 298 10830 1170 6
10
3281
Gold
Platinum Silver Grand Total
1051 1 16 8256 2
Gold 637 1 12 5724 2
1564 15 39 298 15281 6
1492 95 14 23 1 388 14487 1278 4
2638 15 40 388 24021 6
Platinum Silver Grand Total 1106 12 29 286 11301 5
76 1 983 1
1819 13 42 286 18008 8
Features of Excel such as Pivot Table, Sorting, Mathematical Formulae, Filtering, Duplicate Removal, Charts have been used for the analysis.
PULAK MALIK NSIT
[email protected] 9711449386