IT'S NOT THE SIZE OF YOUR DATA

desertcockatooData Management

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

93 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