Taking Applications to the Next level with Data Mining

Why Data Mine
- Too much Data not enough Info
- Enables Data exploration
- Use to solve following Buisness Scenarios
- Identify responsive and unresponsive customers
- Detect fraud
- Target Promos
- Forcast Sales
- Cross-selling
Whats in SQL 2008
- Has 9 Algorithims to extract Data
- Decisions Trees - Most Popular
- Clustering - Finds naturl groupings
-Sequence Clustering
- Naive Bayes
- Line Regression
- Logistic Regression
- Association Rules
- Time Series
- Neural Net
Data Preparation
- Significant amount work is normally involved in getting data ready for Data Mining. It helps greatly if you plan for this when designing your Database.
Data Mining Visualization
-OLTP and OLAP will return exactly what is asked, be careful you ask for thins correctly
-Can use Analysis Services Project in VS to help