Inspiring Ingenuity

Alteryx, Bicycles and Teaching Kids Programming.


Alteryx: In Database Processing (Project LockIn)

The Alteryx engine is known for being fast.  I would like to think that the processing engine is as fast or faster than any other data engine out there.  I learned how to program on a computer with 16 KB of memory and a 2 MHz 8 bit CPU.  Learning how to program in an environment like that forces you to learn how to count bits and clock cycles.  Taking that mentality and applying it to a modern computer leads to very quick processing.

The difficulty though is that Alteryx is limited to the speed it can read & write data from where it is stored.  Having  a super fast data processing engine doesn’t help if you have to pull a terabyte of data from a data warehouse only to find a subset of it and produce a report.  It doesn’t help to be fast if it is slow to get the needed data.

Continue reading