SPSS Workshop

Attending 2 SPSS Workshop on 18 November 2010 at IBM Innovation Centre

Sales Enablement Workshop for morning session and Technical Enablement Workshop for afternoon session

What is SPSS ?
im not going to describe what spss in detail
for further details please go to SPSS at wiki

There is 4 Main Categories in SPSS




(i) Statistics
- SPSS Statistics
(ii) Modeling
- SPSS Modeler
- SPSS Text Analytics
(iii) Deployment
- SPSS Decision Management
- SPSS Collaboration & Deployment Services
(iv) Data Collection
- SPSS Data Collection

Below are Document of product information on the two major core products :

i)IBM SPSS Statistics Base - full modules v19.0
ii)Modeler Premium

Download here IBM SPSS Document

any further info please proceed to www.spss.com

Think Outside the Box

Before You Think Outside the Box, Think Inside of It

"We've gotten so accustomed to thinking that ideas need to come about in new and exciting ways that we often neglect the utility of established paradigms. When crafting your ideas, first think inside the box before you look outside" - Adam Dachis

Most who think seriously about creativity agree that it entails not only novelty (that outside the box stuff) but also utility, and in order to be useful, it has to go above-and-beyond what is already known (that inside the box stuff).

"If you never venture outside the box, you will probably not be creative. But if you never get inside the box, you will certainly be stupid" - Christopher Peterson

First, Think Inside the Box [Psychology Today]

p/s: I love the article and copy paste it here to make a note for myself, this is not my writing

Previous Month Query

We always encounter this issue, how to query previous month data in sql statement
and as always we will get an easy idea, just subtract 1 from current date

example :
month(curdate())- 1

yes this is one easy way to do it, but we will encounter 1 big problem with this statement,current date month is January 2010 and the statement result for the previous month will be 0, that means your query will query month = 0 and your query will give you a null result

solution :
use interval in your query

month(curdate() - interval 1 month)
by using interval the query result is 12 when the current date month is January

this solution also apply to previous year
year(curdate() - interval 1 year)

interval unit available is
FRAC_SECOND (microseconds), SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR

this is just the basic of it, how to implement it to your query its up to you
but hey this is just my opinion, if there is any other better way please respond in comment area ^^