Fractal_pulak.pptx

  • Uploaded by: anirudh chaudhary
  • 0
  • 0
  • April 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Fractal_pulak.pptx as PDF for free.

More details

  • Words: 374
  • Pages: 11
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

More Documents from "anirudh chaudhary"