Rax for BigQuery

Hello world! We are very pleased to announce yet another Rax integration: Rax on Google’s BigQuery. BigQuery is the fourth large-scale, in-the-cloud database supported by Rax, next to Amazon’s Redshift, Snowflake and Azure’s SQL Database. The biggest advantage of this new integration is that now it’s possible to use Rax to process Google Analytics 360 data directly where it lives …

Coders Co. wins hackathon Omgevingswet

The lucky streak continues.. or maybe there is something to it: we entered a hackathon for the third time this year and for the third time we won. This time it was a 2-day hackathon organized by Gemeente Amsterdam: Hackathon Omgevingswet. THE CHALLENGE The trigger for organizing this hackathon is the introduction of the new ‘omgevingswet’ …

ESOMAR congress

THE FUTURE OF MARKET RESEARCH IS NOT THAT SCARY Since the venerable ESOMAR congress (the 70th edition) took place in Amsterdam this year, all of us at Coders Co. got a chance to visit it. My turn was on Wednesday, the closing day of the conference. The disadvantage of visiting on the closing day was …

Big Data Expo and CRMin1day

Last week we visited both the Big Data Expo and CRMin1day. Then it was followed by a hackathon on Friday and Saturday, so it took a bit to digest all the information! I already posted some small pieces on LinkedIn, but I want to compare both events. My colleague Artem also chipped in with his …

Customer-journeys on Frankwatching

Check out Gosia’s article on customer journey analytics on Frankwatching: https://www.frankwatching.com/archive/2017/08/14/customer-journey-analytics-inzicht-in-klantreizen-met-actuele-data/

Coders Co. wins Eneco Data Challenge

After our successful appearance at WHAT datathon we decided to try our skills again and, together with an old friend of mine Konrad Banachewicz from TNG Quant Consultancy, we took part in Eneco’s Predictive Maintenance Challenge, a part of Dutch Data Science Week 2017. And yes, we won again! BUSINESS VALUE The competition was fierce and there were many great models created. …

Coders Co. wins Gfk Insights Challenge

Last weekend we took part in the WHAT datathon – a data science competition accompanying the WHAT behavioral data conference organized by Wakoopa.And YES, we won the Gfk Insights track! THE CHALLENGE The challenge was to uncover business insights in clickstream data. We got data of one month in 2016 of a Dutch panel that shows how people have been using …

Behavioral targeting with Rax

THE RISE OF PROGRAMMATIC BUYING More and more online ad space is sold nowadays via a process called┬áprogrammatic buying. What this means, is that every time a person visits a website or an app with an advertising space, this space is offered for sale on an auction. Advertisers can now bid for this person’s attention …

Rax 1.2 Released

Rax 1.2 with shiny new features is now available! Get your fee Rax for SQLite copy to try it out! Regular Expressions Rax supports now Perl-compatible regular expressions to simply matching text fields, for example URLs. Rax has two new match operators: =~ (match) and !~ (not match). For example, to select all web clicks …

Sort by Regex

Rax string reduction, /cat(), on the IMPALA backend was not trivial to implement. The IMPALA documentation states: GROUP_CONCAT … does not support the OVER clause, … Effectively this means no ORDER BY on GROUP_CONCAT in IMPALA. This must be implemented eventually, because the whole GROUP_CONCAT has limited use without it. Meantime, regexes can be used …