IT'S NOT THE SIZE OF YOUR DATA

desertcockatooData Management

Nov 20, 2013 (3 years and 4 months ago)

70 views

DATA MINING

IT'S
NOT THE SIZE OF YOUR DATA
IT'S
WHAT YOU DO WITH
IT

Presentation by

Adam Jorgensen (@
ajbigdata
)

adam@pragmaticworks.com


Devin Knight (@knight_devin)

dknight@pragmaticworks.com

Data Mining with Tabular?

BI
-
300


2

Agenda

What is Data Mining and how
do you use it?


SQL Server Data Mining


Data Mining with Office
2012



BI
-
300


3

Real Life examples

4

Track #


Session #

What does Data Mining Do

BI
-
300


5

Explores
Your Data

Finds
Patterns

Performs
Predictions

Value of Data Mining

BI
-
300

6

SQL Server

OLAP

Reports (Adhoc)

Reports (static)

Data Mining

Business Knowledge

Simple Complicated

Usability

Relative business value

Excel

BI
-
300

7

Decision Trees

Clustering

Time Series

Sequence
Clustering

Association Rules

Naïve Bayes

Neural

Networks

Introduced in SQL Server 2000

BI
-
300

8

Data Mining Process

Flatten Dataset

Create Model

Train Model

Test Model

Update Semi
-
Regularly

BI
-
300

9

Temporary Model

Excel Data Mining Architecture

BISM Multidimensional

Permanent Model

Results

Results

v

Demo

Excel Data Mining

Thank You

Please fill out speaker evaluation


Email
:
adam@pragmaticworks.com

Twitter:
@
ajbigdata


Email: dknight@pragmaticworks.com

Twitter: @knight_devin

BI
-
300


11