Data Mining and OLAP in SSIS

Data Mining:

It is a set of processes to analyzing and discovering useful and actionable knowledge buried deep beneath large volume of data store or data sets.Data Mining requires large volume of data including history data as well as current data to explore the knowledge.

Data Mining Life Cycle:

• Find out business problems
• Knowledge Discovery
• Implement the Knowledge
• Analyze the Results.
•  

OLAP vs Data Mining: 

• OLAP helps organizations to find out the measures like Scales drop, Productivity, service response time.
• OLAP tells us what has happened.
• Data  Mining helps to fin out the what it has happened at the first place.
• Data Mining can also be used to predict what will happen in the future with the help of data patterns available with the organization and publicly available data.