xlminer

1. www.xlminer.net www.cytel.com

2. Project by • Cytel Inc., Cambridge, Massachusetts • Dr. Nitin Patel • Development at Pune subsidiary, Cytel Statistical Software & Services Pvt. Ltd. • Marketed by C-BIA, Pune, India and statistics.com / resampling.com, Washington DC, USA

3. About C-BIA • Division of Cytel Software India Pvt. Ltd. a company founded by the co-founders of Cytel Software Corporation (www.cytel.com) , Massachusetts, USA: • Dr. Cyrus Mehta, a member of the faculty in the Department of Biostatistics, Harvard School of Public Health since 1979; and • Dr. Nitin Patel, a member of the faculty at MIT's Sloan School and the Operations Research Center since 1995. Previously, he was a Professor at the Indian Institute of Management, Ahmedabad. • Group of 40 people in Pune, India with expertise in Analytics, Data Management and Software Development

4. Business • Services • BI solutions Design and development of data warehousing and OLAP – Online Analytical Processing - applications • Development of BI Tools Custom designed tools for analytics using our library of analytical algorithms • Analytics services • On-site analytics services • Remote computing based offshore analytics services • Client specific analytics service on Internet • Training In-company and public programs in the area of Business Intelligence and Analytics, including Data Warehousing and Data Mining • Product Marketing and Implementation Services • XLMiner – Data Mining add-in for Excel • ProClarity – OLAP based Analytics tool

5. Management and Experts Panel Management • Mayank Shah Chartered Accountant Mayank has over 27 years' experience as Consultant, Executive and Academician in the field of MIS and BI applications for business. Mayank is Consultant and Director of Cytel Software India Pvt. Ltd. leading C-BIA activities and is a Visiting Professor at S. P. Jain Institute of Management & Research. • Ajay Sathe PGDM, IIM, Ahmedabad Ajay has over 17 years' experience in IT industry specializing in Software Development and Technology Management. Ajay is Director of Cytel Software India Pvt. Ltd. and heads Quantlink Solutions Pvt. Ltd. engaged in statistical software development for Cytel Software Corporation, Cambridge, MA, USA. • Shrikant Athavale Industrial Engineer Shrikant has nearly 36 years' experience in Industrial Engineering and Quality Management. Shrikant is Executive Director of Cytel Software India Pvt. Ltd. and spearheads the new initiatives in IT enabled services, especially in eLearning. Experts Panel • Nitin Patel, Ph. D. Dr. Patel is a leading expert on the development of fast and accurate computer algorithms to implement computationally intensive statistical methods. Dr. Patel is Founder and Co-Chairman of Cytel Software Corporation, Cambridge, MA, USA and Visiting Professor. MIT Sloan School of Management. • Sunil Lakdawala, Ph. D. Dr. Lakdawala has over 20 years' of consulting experience in IT applications for business including Data Warehousing and Data Mining. Dr. Lakdawala is a consultant in BI applications and is visiting professor at S. P. Jain Institute of Management & Research. • V. Chandran, Aeronautical Engineering Chandran has over 22 years' experience in technology functions, including CTO positions in companies with sizeable software teams. Chandran is Vice President with Quantlink Solutions Pvt. Ltd. heading Technology Management function besides managing consulting assignments.

6. XLMiner™ is a comprehensive data mining add-in for Excel. • Data mining is a discovery-driven data analysis technology used for identifying patterns and relationships in data sets. • Supervised Learning • Classification – predicts classes • Prediction – predicts values • Unsupervised Learning • Clustering • Dimension reduction • Affinity

7. XLMiner – A Data Mining Tools • Data Management • Sampling • Model building • Classification • Prediction • Data reduction • Data exploration • Charts • Scoring Model

8. Overview of Techniques - Classification Classification

9. Overview of Techniques - Prediction Prediction

10. Overview of Techniques – Unsupervised Learning Clustering and Dimension Reduction Market Basket Analysis / Affinity

11. Architecture Excel add-in Engines VBA Excel

12. Some of the Commercial Users • Northrup Grumman • National Institutes of Health • Westing house (Savannah River) • JD Powers • NASA • Bell Atlantic • Pitney Bowes • Centers for Disease Control • Gillette, UK • Monsanto • ExxonMobil • US Army • FDA • Experion • National Inst. of Standards & Technology • Fidelity Investments • Blackstone Group • More…

13. XLMiner-Pro • XLMiner – Pro is offered as a solution to enable completion of all Data Mining tasks and generate results directly usable by a business manager. • The bundle includes following product and services: • XLMiner, an Excel add-in software that runs on Excel platform, using Excel as a user interface. XLMiner embeds world class Data Mining algorithms and leverages Excel’s computational capabilities to create easy-to-use environment for business managers. The software has ability to connect with popular data bases such as SQL Server, Oracle and Access. Five user licenses are offered in a bundle. • Two days training for developing XLMiner-Pro based application, with hands on exercises and Two days case study based on client data base. • E-mail support services • Additional services: • Customization services to create data marts suitable for different applications of XLMiner-Pro (Per data mart) • Customized interactive reporting features. • Customized application development based on XLMiner- Pro.