Istambul Insurance Event May 2011 Customer Segmentation&Clustering for Product Design in 15 Minutes By Josep Arro

1. Istambul Insurance EventMay 2011CustomerSegmentation&ClusteringforProductDesign in 15 MinutesBy Josep Arroyo CEO

2. Introduction to Quiterian • Founded by Josep Arroyo in 2003 • Dynamic Data Web – The Fastest Advanced Analytics and Predictive Self-Service BI for all users European Headquarter Barcelona European offices Madrid Sevilla Valencia Lisboa US Headquarter Miami, FL North America Offices Los Angeles, CA México DF, México Business Partners Worldwide Quiterian and its BI platform DDWeb appear in the ‘Magic Quadrant for BI Platforms' report, for 'having made Data Mining and Statistical Analysis of large-scale data user-friendly and accessible to all business users‘.

3. Positioning: Advanced Analytics complementing current BI Focus on dynamic visualization and drill down Focus on getting more value from data. Easy analysis techniques, Self-service BI and big data Focus on control and Reports distribution Stability - NO CHANGES Rapid Changes, Anticipation Centralized Info – IT Dependency 100% Self-Service What Happened? Why happened? What Next?

4. Our Experience:

5. CustomerSegmentation&ClusteringforProductDesign in 15 Minutes Do you think is really hard to understand where the opportunities are? • Let us show you how to find the fast path to find the opportunities.

6. In 15 Minutes? Yes, let me show it to you. • Using powerful and easy to use analytic techniques • Giving autonomy to business users • Reducing dramatically IT workload • High Performance with large data volume • No need for cubes or metadata

7. Scenario • Insuranceservices marketing department • Data modelDDWebloaded: • Prospect • Customers • Products • Transactions • Campaing • Response • ContactHistory • Postcode

8. Scenario

9. Scenario

10. Content 1 Scenario 2 Theirneeds 3 Problemresolution

11. Needs • The marketing area want: Identify the most profitable customers Identify cross-selling opportunities What? How? Who? Identify the most profitable channel Identify characteristics of customers

12. Content 1 Scenario 2 Theirneeds 3 Problemresolution

13. Cross-selling opportunities • Insuranceinstitutionoffersdifferentproducts What is the category of best sellers? Products How it relates to te other categories? Text

14. Cross-selling opportunities With Dynamic Data Web, quickly and visually, using Venn diagrams have found a new business opportunity and we have defined the target

15. Cross-selling opportunities • The marketing area want : Identify the most profitable customers Identify cross-selling opportunities What? How? Who? Identify the most profitable channel Identify characteristics of customers

16. Customer value • Determine the current and/or future customer value What are the most profitable customers? It is possible to determine the future probability of customers? What their potential value?

17. Customer value We give our analysis of added value. Combining information from different tables imported DDWeb is easy to create new information that we had in our original base

18. Customer value • The marketing area want: Identify the most profitable customers Identify cross-selling opportunities What? How? Who? Identify the most profitable channel Identify characteristics of customers

19. Identify the most profitable channel • Identify the most advantageous promotion channel What will be the most effective channel? How we approached our target?

20. Identify the most profitable channel Again, to reach easily and intuitively DDWeb decipher the most interesting channel for our promotion

21. Identify the most profitable channel • The marketing area want: Identify the most profitable customers Identify cross-selling opportunities What? How? Who? Identify the most profitable channel Identify characteristics of customers

22. Identify the best customers • Identify the profile of best customers What characteristics define the most profitable customers? What makes them different from other?

23. Identify the best customers • Identify the profile of best customers With Profile decipher the profile of our best customers quickly.Learn how they are and confirm our intuitions

24. Identify the best customers • The marketing area want: Identify the most profitable customers Identify cross-selling opportunities What? How? Who? Identify the most profitable channel Identify characteristics of customers

25. Target for promotion • Determine target for our promotions We have identified a business opportunity, the profile of people you want to address and promote the most appropriate channel We can exactly detect the target at which we want to go?

26. Target for promotion • Using the mouse, without need complex SQL queries we have determined our target and exported data for complete the mailing

27. WanttoknowthebestProducttoRecommend ? • Decisiontree, easytounderstand, quicktomanage…

28. What makes us different and unique? • Using powerful and easy to use analytic techniques • Giving autonomy to business users • Reducing dramatically IT workload • High Performance with large data volume • No need for cubes or metadata

29. Thank you for your attention!! QUITERIAN PARTNER IN TURKEY Umit Kantel New Business Director Yaz Bilgi Sistemleri Büyükdere Cad. Prof.Dr.Bülent Tarcan sk. no:1 Gayrettepe 34349 212-2885370 umit_kantel@yaz.com.tr European Headquarter Barcelona European offices Madrid Sevilla Valencia Lisboa US Headquarter Miami, FL North America Offices Los Angeles, CA México DF, México QUITERIAN EMEA Francisco Viana EuropeChannel Manager (+34) 933 714 470 Skype: f.viana fviana@quiterian.com www.quiterian.com www.quiterian.com info@quiterian.com