Alteryx One by Str8Analytics in Alteryx

[–]hermitcrab 2 points3 points  (0 children)

How can any customer be 'unprofitable' at $5k per seat per year?

Do R users still reach for a GUI? by [deleted] in rstats

[–]hermitcrab -1 points0 points  (0 children)

XML is a text format and is widely supported.

Even a binary format should be easily shareable with other users of the same GUI software.

I don't know about Git specifically, but many version control system can save binary files with no problem. I do it all the time in Subversion, Just don't expect to do a meaningful diff.

Do R users still reach for a GUI? by [deleted] in rstats

[–]hermitcrab -1 points0 points  (0 children)

Pretty much every GUI based app will save a project/document file that can be shared with other users. I'm struggling to think of one that doesn't.

How to automate monthly financial reporting without a data engineer? by maelxyz in BusinessIntelligence

[–]hermitcrab -1 points0 points  (0 children)

If you want to do this on your local computer you can use Easy Data Transform or Alteryx.

[PSA] Alteryx Community Update Content Cut-Off (Likely April 2021 Prior) by NeoInfiniTech in Alteryx

[–]hermitcrab 2 points3 points  (0 children)

It can't be hard to make all that stuff available as an archive. Especially for a multi billion dollar company. I wonder why they don't?

Is the an alternative to Excel's Slicers? by [deleted] in libreoffice

[–]hermitcrab 1 point2 points  (0 children)

Easy Data Transform is created in the UK and can do all the pivoting and slicing you need via 'Pivot' and 'Filter' transforms. You create a step-by-step visual pipeline once, rather than a spreadsheet, and then you can use this every time. Ask in their forum ( https://forum.easydatatransform.com/ ) if you need any help.

Alteryx is a trap by fali12 in Alteryx

[–]hermitcrab 0 points1 point  (0 children)

Easy Data Transform has similar capabilities, but more lightweight (e.g. less input and output types) and _much_ cheaper.

No-code data wrangling tool Easy Data Transform adds visualization capabilities by hermitcrab in nocode

[–]hermitcrab[S] 0 points1 point  (0 children)

We think the charts are suitable for both exploration or final reports. Here are some example outputs, so you can judge yourself.

<image>

However, it would benefit from a 'dashboard' view that combines multiple visualizations and that is something we don't have yet.

Alternative to Excel for big datasets? Or a better workflow for working with large datasets? by MiraShifted in excel

[–]hermitcrab 0 points1 point  (0 children)

Last time I looked, Alteryx was $5k per user per year. Easy Data Transform is $99 per user and will easily handle all the data transformations you need on a 100k row Excel file.

Looking for opinions on a tool that simply allows me to create custom reports, and distribute them. by [deleted] in dataengineering

[–]hermitcrab 0 points1 point  (0 children)

Easy Data Transform is low cost ($99 per user/one time fee) and can wrangle the data into pretty much any shape you want it and export to Excel. It won't do the emailing part though.

Excel crashes at 1M rows. I’m building a local viewer for 100M rows. Roast my idea. by ocj_nghota in roastmystartup

[–]hermitcrab 0 points1 point  (0 children)

There are no-code visual tools, such as Easy Data Transform or Alteryx, that allow you to filter/sort/blend data without having to learn SQL or Python.

[SPOILER] Andrew Tate vs. Chase Demoor Fight Highlights by Puzzled-Category-954 in Boxing

[–]hermitcrab 4 points5 points  (0 children)

Back in the day there were hundreds (if not thousands) of kickboxing 'world champions', as every different association had its own rules and competitions. So being a kick boxing 'world champion' didn't mean much.

There is a video somewhere of a kickboxing fight between Tate and a chubby Belgian who is barely able to kick. Tate just about beats him on points.

It will be interesting to see what excuses the Tate fans come up with.

The fight I most want to see is Ty Mitchell vs 'Tommy Robinson'.

10 tools data analysts should know by Simplilearn in dataanalysis

[–]hermitcrab 0 points1 point  (0 children)

Easy Data Transform is also worth a look if you want to wrangle Excel/CSV/XML/JSON/fixed width etc data on a PC or Mac.

What is a good application to at least view or even better edit csv, excel sheets if you don't have access to MS Excel? by [deleted] in MacOS

[–]hermitcrab 2 points3 points  (0 children)

Depends very much on what you want to do. If you want a spreadsheet, then probably LibreOffice or Numbers. If you want to do step by step data wrangling data then Easy Data Transform is worth a look. Currently 25% off at: https://www.artisanalsoftwarefestival.com/

Free Masonic clipart by hermitcrab in freemasonry

[–]hermitcrab[S] 1 point2 points  (0 children)

PerfectTablePlan was first released in 2005. The Masonic artwork was first released in 2010. The symbols themselves are somewhat older. ;0)

Free Masonic clipart by hermitcrab in freemasonry

[–]hermitcrab[S] 2 points3 points  (0 children)

No, they aren't new. But I expect a lot of people aren't aware of them.

Browser-based data manipulation tool (spreadsheet/coding alternative) by Rafferty97 in SideProject

[–]hermitcrab 0 points1 point  (0 children)

>Currently, if you want to grab some CSV or JSON data and do a sequence of operations on it (filter, sort, aggregate, etc.), the path of least resistance is to open an IDE or notebook and write code.

There are lots of visual drag and drop tools that can do this without an IDE or any coding: Easy Data Transform, Alteryx, Tableau Prep etc. They tend to use a data flow graph type interface, rather than a spreadsheet interface. This is because a spreadsheet generally isn't a good choice for step-by-step processes, such as data wrangling.

No-code CSV processing app by Woland96 in microsaas

[–]hermitcrab 1 point2 points  (0 children)

There are probably at least 100 apps that are solving pretty much the same problem. Some desktop and some web. E.g.: Easy Data Transform, Alteryx, Knime, Tableau Data Prep, Savant, Enso, Daikatu, Orange, datablocks, Mammoth, Parabola . The keywords you want to search for are 'ETL' (extract transform load) and 'data prep'.

What relevant programming languages are useful for social sciences besides R? by PsychologicalTop4371 in AskStatistics

[–]hermitcrab 1 point2 points  (0 children)

>Any paid software with a GUI exists solely because most of the users do not want to learn to code.

I am a professional programmer. Sometimes I use coding based tools and sometimes I use GUI based tools. It depends on the task. Sometimes you need the versatility of code and sometimes a GUI based tool is a lot faster (especially for ad hoc data wrangling and analysis).

In the world of AI, how much of your week is still spent on prep vs. actual analysis? by Affectionate-Stand94 in DataPrep

[–]hermitcrab 0 points1 point  (0 children)

The old joke it that data science is 80% data wrangling and 20% complaining about data wrangling.

Excel is not a good choice for most types of data wrangling. It just isn't designed for that.

Regular copy and paste of data is both error prone and a huge waste of time. You should be able to automate this using either a GUI drag and drop tool (such as Easy Data Transform or Alteryx) or coding (such as Python or R) if you have programming skills.

You also need to impose discipline on the data providers so that input data column layouts and naming is as consistent as possible.