{ "media_type": "text", "post_content": "What’s everyone’s take on Alteryx?", "post_id": "5aee58adbb1e750013388ae3", "reply_count": 11, "vote_count": 2, "bowl_id": "5ace5097be6e660013abcc42", "bowl_name": "Data & Analytics Consultants", "feed_type": "bowl" }
null

What’s everyone’s take on Alteryx?

like
Posting as :
works at
You are currently posting as works at

Hate it as I feel like it creates bad habits. It is a crutch for people who dont want to bother to learn SQL. Then they refuse to learn SQL it seems. The redeeming feature is the prepackaged geospatial data sets.

Without the Geospatial data sets I'd rather have a real programmimg language (R or Julia) plus a database (Hive, spark, SQL server, postgis etc depending on data volume).

like

Love it

like

Incredible for visual programming. Personally it was a stepping stone to learn data science

helpful

Love it. It’s amazing for prototyping.

Absolutely love it. It’s more than just ETL. It dies spatial, it does modeling, it connects to datasets previously only dreamt of and if you know how to work it can automate the life out of your mundane tasks.

I don’t like to tout software but this is an exception

Alteryx can't even do a for loop... Seriously how can you love this software?

If you arent working with geospatial, have small to medium data sets, and must have a workflow based tool id recommend KNIME.

It is free and has sensible features like loops, try catch error trapping, reasonable integration with R, Java and Python, and you don't rerun every data set from the beginning of the workflow. It also works closer to a REPL than alteryx.

Side note but I expect you could build spatial capabilities into KNIME with minimal effort.

Thank you all for the feedback. It looks like I have some options to explore.

I have no need for geospatial analysis as I am using arcGIS. I am more looking for something to handle analyses of larger data sets that are beyond the capabilities of excel. With VBA I’ve created analysis templates that can run a pretty complex multipart analysis on 7 million+ records easily. My difficulty lies in exploring the data due to required changes in code. I’m not versed in python though I would like to learn as the arcGIS software has an interface for it.

D1 you can cache datasets in Alteryx so you don’t need to rerun them. Another way is to write them to Alteryx yxdb files which are super small due to its incredible compression and use that as you datasource while testing things out.

It sure what you mean about looping but you can definitely create macros to iterate runs which will loop through a set of criteria. Not to talk about creating an analytical app that the user just uses a simple form interface enabling them control inputs and outputs.

And it does have error trapping. You just need to enable it and configure what kind of errors you want to capture. Can even send you an email of the errors too
I will check out knime though. Haven’t tried it.

R has a number of spatial packages for querying spatial data. SQL Server and PostGIS are good options as well.

Additional Posts

Would you say the good majority of the financial models that y’all build are “quick and dirty”? Mine definitely are. Modeling is only part of the job. No need to spend more time than necessary

like

what’s your go to clothing staple for meetings

Will be joining McKinsey as an associate next month, any advice on must have clothes? My current work place is very informal so dressed in jeans and polo's most of the time.

like

Anyone looking for a roommate in Sunnyvale / MV / Palo Alto? I’d feel safe living with a fellow female 🐠

like

Looking for a fully remote company, please comment if yours is one and if you have open positions! I’d love to connect :)

I’m a supply chain professional with procurement experience. I studied business management and supply chain management.

like

Next month is my two year anniversary with my boyfriend… im 24. Im kinda scared of how serious my relationship is. Is this normal? Ps I love him so much, he’s perfect, sex is great but sometimes i think I could be missing something out there.

likefunny

Applying to a Digital Marketing Strategy role at a major bank, but not sure what the growth opportunities are, compared to consulting, where you can (in theory) make partner. Anyone in this type of role that could provide insight please? TIA!

like

Anyone else enjoying the river walk?

Post Photo
like

Is it just me, or can analyst culture be really toxic? No problems with C’s, M’s, or MD’s—they’re usually nice and happy to help me out. It’s the analysts that are cutthroat, rigid, and unhelpful

like

Quit my job. Leaving America in a week or so. What do I have to do before I leave?

like

Where is everyone taking their end of busy season vacation? I need ideas.

like

I was just let go from my company. I am their only in-house lawyer.

likehelpful

I’m surprised that most of my LinkedIn i mails from recruiters are Software Engineering roles. Most of my experience is Data Analytics. Anyway, I had a recruiter from Microsoft reach out for a Commercial Software Engineering role. I went ahead and applied, but I haven’t touched data structures in years. Any insight on the SWE process for CSE? (Assuming the recruiter doesn’t ghost me)

like

Apply or Stay Away?

Post Photo
like

How easy is it to get an MBA sponsored by Deloitte USI (consulting)? How many people get it every year?

like

Poorly explain what you do for a living

like

Does anyone have any insight into Leo Burnett, Detroit? Thriving or dying?

Can someone provide referral for PWC Cloud and Digital Team (Analytics) Manager position?

YOE:6+
Non Target MBA
MS in information systems

like

Which are some courses good to pursue as a Management Fresher while working?

like

Hi all, I wrote an article about solving student debt + why free college is a bad idea. Would really appreciate any feedback! (Link in comments)

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the Fishbowl app

For account settings, visit Fishbowl on Desktop Browser or

General

Legal