Recent Articles

analytic functions,

Window Functions (aka Analytic Functions) in Spark.

As of Spark 1.4.0 we now have support for window functions (aka analytic functions) in SparkSQL. At Sonra we are heavy users of SparkSQL to handle data transformations for structured…

Uli Bethke July 3, 2015

analytic functions,

Time series in OBIEE. Analytic functions and range window as an alternative to OBIEE AGO function.

All intellectual credit for this post goes to my colleague Maciek Kocon. I am simply documenting this. We had some performance issues recently using the OBIEE AGO function for time…

Uli Bethke June 1, 2011

analytic functions,

ODI and analytic functions (again???)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes My friend and colleague Maciej Kocon has come up with the…

Uli Bethke May 20, 2010

Downloading, Setting Up & Running Oracle Data Miner

As the awareness of Oracle Data Miner increases so does the interest in trying out and playing with Oracle Data Miner (ODM). The following set of instructions steps you through…

Uli Bethke March 8, 2010

analytic functions,

10 Reasons you really need predictive analytics

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…

Uli Bethke February 4, 2010

analytic functions,

Comparative Window Functions: Proposed Extensions to Analytic Functions

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…

Uli Bethke November 16, 2009