SQL Data Mining Algorithms
Proper Selection & Use Methods
Home
Services
Demos
Analytics
Our Clients
Company
Contact Us
Industries & Clients We Serve
Sample Smart Client Applications
Request A Free Consultation
PCA Services
Our Design-Build Process
Business Process Consulting
Database Engineering
Project Takeovers
Maintenance & Support
Service Fees & Licensing
PCA vs. Your Alternatives...
Internet Database Solutions
Smart Client Applications
Sample Smart Client Apps
Sample Prototypes
Smart Clients vs. Browser Apps
More about Smart Clients...
Distributed & Internet Data
SQL Server over the Internet
MS Access over the Internet
Excel over the Internet
Database Engineering Services
SQL Server Development
MS Access Development
Conversions & Migrations
Top Reasons to Migrate
MS Access Migration Chart
MS Access to SQL Server
Excel to SQL Server
More Migrations...
Tuning & Optimization
MS Access Tuning/Optimization
SQL Server Tuning/Optimization
SQL Server Engineering Audit
Reporting & BI Solutions
Sample BI Applications
SQL Reporting Services
Crystal Reports
SQL Server Analysis Services
BI, Cubes & Data Mining
Microsoft SQL Data Mining Algorithms
The following table describes the different business use-cases that drive data mining adoption, and the relevant SQL Server Analytics Services (SSAS) algorithms:
Business Purpose
Description
Algorithm(s)
Market Basket Analysis
Discover items that are most frequently purchased together to optimize product bundles and placement
Association
Decision Trees
Churn Analysis
Anticipate customers who may be considering canceling their service and target communication/services to improve customer retention
Decision Trees
Linear Regression
Logistic Regression
Market Analysis
Define market segments by automatically grouping similar customers together and use segmentation to target the most profitable customers
Clustering
Sequence Clustering
Sales Forecasting
Predict sales and inventory amounts and learn how they are interrelated to foresee bottlenecks and improve performance
Decision Trees
Time Series
Data Exploration
Analyze profitability across customers, or compare customers that prefer different brands of the same product to discover new opportunities
Neural Network
Unsupervised Learning
Identify previously unknown relationships between various elements of your business to inform your decisions
Neural Network
Web Site Analysis
Understand how people use your Web site and group similar usage patterns to offer a better experience
Sequence Clustering
Campaign Analysis
Spend marketing funds more effectively by targeting the customers most likely to respond to a promotion
Decision Trees
Naïve Bayes
Clustering
Information Quality
Identify and handle anomalies during data entry or data loading to improve the quality of information
Linear Regression
Logistic Regression
Text Analysis
Analyze feedback to find common themes and trends that concern your customers or employees, informing decisions with unstructured input
Text Mining
BI / Analytics Solution Consulting
BI Consulting & Engineering
Popular BI Applications
SQL Analysis Services
Excel Pivot Tables
OLAP Cube Design
Cube Tuning/Optimization
SQL Data Mining
Data Mining Algorithms
SQL Server Consulting
SQL Server 2005 vs. 2008
SQL Server Consulting
SQL Server Engineering
Convert MS Access to SQL
Convert Excel to SQL Server
SQL Server Performance Tuning & Optimization
SQL Server over Internet
SQL Reporting Services
SQL Server Analysis Services