presentation to october 2014 masoud charkhabi director – advanced analytics canadian imperial bank...

Presentation to

October 2014

Masoud CharkhabiDirector – Advanced AnalyticsCanadian Imperial Bank of Commerce

Public

Oracle Open World

Extending the Power of In-Database Analytics

| 2

All values and figures in the following presentation are intended for the purpose of demonstration. They do not necessarily reflect any literal data from historical studies. Any opinions presented are solely those of the presenter and do not necessarily represent those of the Canadian Imperial Bank of Commerce.

Disclaimer

| 3

1. Business Insights and Oracle

2. Defining Business Insight

3. The Importance of In-Database Analytics

4. Distributions, Relations and Ratios

5. All Subset Methods

6. A Success Story

7. Conclusion

1

Agenda

2

3

4

5

6

7

| 4

Business Insights and Oracle1

*** The main message ***The most valuable business insights come from rapidly challenging distributions, ratios and relations with data

| 5

Business Insights and Oracle1

Big Data technologies solve for cost, scale and time-to-market1.1

| 6

Defining Business Insight2

“…The theorem is… that the probability of finding a gold coin in a heap of manure tends to 1 as the size of the heap tends towards infinity. This theorem is false.” -David J. Hand

2.1

…The theorem is… that the probability of finding something interesting in a heap of manure tends to 1 as the size of the heap tends towards infinity. This is true.

2.2

…Interesting is; what seems to be X is in fact Y.-Gerard P. Cachon

2.3

| 7

The Importance of In-Database Analytics3

The long journey of data is mostly in data preparation3.1

Bring the math to the data3.2

Distributions, Ratios and Relations4

| 8

DistributionsThe Pareto Distribution of wealth: 20% hold 80% of the wealth

4.1

Distributions, Ratios and Relations4

| 9

Distributions4.1

RatiosA high ratio of promoters recommend to friends and family

4.2

Distributions, Ratios and Relations4

| 10

Distributions4.1

Ratios4.2

RelationsAs age increase income increases then evens out, assets continue to build

4.3

| 11

All Subset Methods5

Insights are hidden in subsets5.1

All Subsets Regression5.2

Recursive Hierarchical Clustering5.3

| 12

All Subset Methods5

Insights are hidden in subsets5.1

All Subsets Regression5.2

Recursive Hierarchical Clustering5.3

| 13

All Subset Methods5

CL1_394 343

CL2_342 CL3_435

CL3_242 CL4_634

- 1345

PARENT_ID CHILD_ID

Insights are hidden in subsets5.1

All Subsets Regression5.2

Recursive Hierarchical Clustering5.3

-5

-2

40

1

NPS

| 14

A Success Story6

Client Complains

About Holds

Affluent Banker Deeply Offended Attrition AcknowledgeRelationship

Client Complains

About Holds

Needs Accessto Funds

NegativeWord of Mouth

Short TermBorrowing

Day-to-Day Banker

| 15

Conclusion7

*** The main message ***The most valuable business insights come from rapidly challenging distributions, ratios and relations with data

| 16

Questions