[dgudkov]

May I suggest your non-tech users to try EasyMorph[1] (I'm the founder)? It's easier than PowerQuery (it's completely no-code) and at the same time more powerful. 80% of PowerQuery capabilities require coding. Our tool is 100% visual (and has a free edition).

[1] https://easymorph.com

[ModernMech]

Respectfully, “easier” and “more powerful” are meaning-free descriptors. How is your product easier and more powerful? If you’re going to post an ad, at least do me the courtesy of telling me something I don’t know.

[dgudkov]

I agree, brief descriptions like sound vague and empty. So let me support my claims: EasyMorph is easier for non-technical people because unlike with PowerQuery all of its functionality is available without coding. Also, EasyMorph is more powerful than PowerQuery, because it has a bigger library of available data transformations, for instance, interval merge (a join where a key value must fall in a range specified by two fields), fuzzy matching, binning, de-aggregation (breaking down a total), or replacing substrings using a lookup table.

In terms of programming, EasyMorph is basically a high-level functional programming language (but entirely visual) with immutability, pipelining, automatic parallelization and concurrency. It allows arranging loops similar to FOR..NEXT, FOR..EACH, DO..WHILE/UNTIL loops in programming languages. It has subroutines, conditional IF/THEN/ELSE branching, exceptions, mutexes, and a built-in key-value storage.

Besides that, it combines data preparation with no-code automation because it has many so called external actions for exporting to/updating databases, sending low-level HTTP requests to web APIs, performing file operations (download, rename, delete, clone, zip, unzip, etc.), running external applications, and even executing SSH commands on remote machines. The full list of capabilities is rather extensive to list in one post and can be found here: https://easymorph.com/all-integrations.html.

Finally, EasyMorph is just faster due to its in-memory columnar engine with several tiers of data compression and aggressive optimizations that leverage CPU cache. We regularly see customers that switch from PowerQuery because EasyMorph is 1-2 orders of magnitude faster.

At the same time, EasyMorph is 5 times less expensive than Alteryx and has a very generous (as our users say) time-unlimited, data volume-unlimited free edition.

We're entirely bootstrapped, profitable, and almost double our revenue every year for the last several years.

[ModernMech]

Thank you! This comment was very informative.

A couple more questions: do you have a roadmap for supporting non-windows systems? And also do you have plans for open sourcing any of your code?

[5ghlo]

I am really curious: How does this compare to Knime (quite popular in EU). I have onboarded a couple finance departments and I agree with you that the flow approach is easier for the teams.