10 Reasons you really need predictive analytics

Uli Bethke analytic functions, Best Practice, Business Intelligence, data mining, Data Warehouse

SPSS have recently posted and article called "10 Reasons you really need predictive analytics". I thought it would be interesting to post the main points from this article to illustrate that not all predictive analytic projects involve Data Mining, but involve a number of different techniques and looking the the business data in a different way. Yes data mining can ...

Comparative Window Functions: Proposed Extensions to Analytic Functions

Uli Bethke analytic functions, Oracle, SQL for Analysis

I promise that this will be the last post on analytic functions this month; but I came across this proposal to extend analytic functions with a comparative window function on Tom Kyte's blog yesterday (also make sure to review the actual paper). Basically this new type of analytic function would allow you to compare the current row in a window ...

SQL quiz revisited: ROW_NUMBER, LAST_VALUE, FIRST_VALUE and the SQL knights value problem.

Uli Bethke analytic functions, Oracle, SQL for Analysis

Thank you all for your entries to the recent quiz. The guys from Packt should be shortly sending out the e-books to the winners. Today I will walk you through some of the possible solutions and also briefly touch upon performance of these. Last week's contest was based on a classic SQL problem. Anthony Molinaro, the author of the SQL ...