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.

Related Posts

My job is looking for a technical service manager that would primarily Interface with Skin care customer on a technical level. Based in NJ on site. Experience in the cosmetics industry is a plus. Message me if interested so I may refer you

Hi all i need 15 likes for dm please help

like

How safe is it to refer someone you don't know and then they get offer somewhere else and back out last minute?? 🤦

Ab office m jo Izzat ki watt lagi h bus pucho mut 🫣

like

Is Meetup legit and a good way to meet people? Looking to find new things to do with new people

like

Is there a limit to how many FAANG positions you can apply for in a month?

like

McKinsey & Company Hi Fishes...i have a 7 year of experience in reimbursement and AP profile and looking for change... please help 🙏 Boston Consulting Group JLL McKinsey & Company Deloitte KPMG PwC Tata Consultancy Accenture RBS

Has anyone started going to office? I went this week thrice! I did not like even a bit. Have started looking for remote jobs.

like

How would you sell ETFs in retirement since there is no average cost option for etfs?

like

What is the scope for RPA BA profile in terms of - Job security, Growth and salary?

like
like

Are you a morning person or night person?

like

Do you ever feel like upper management at your company has expectations so unrealistic that there’s no way anyone has ever managed to satisfy them? Sometimes I just have to stop and wonder where they got all these standards from and laugh.

like

Guys...could you please advise on 2 things below
Company INFOSYS JL6 lead/principal consultant?
1. Yearly hike on average rating
2. Variable payout on average rating

like

What are the director level salaries of Product Manager in SF/Bay area?

like

Does TCS employees get any special discount in Croma stores?

like
like

Has anyone put work in their book that the client denied? I wrote some pretty great lines for a client and it’s like they hate creativity. I really want to put them in my book, is that a bad idea?

How to find your legal team/ help? I am working on and iOS app and there are some legal areas I need straightened out before I sink anymore money into it. Where is a good place to find legal help

Hi HR Professionals! I am revising our current employment application form. Per SHRM, I was just curious if any HR Professionals completely removed the following fields: social security number, recommend salary, graduation dates, military discharge info, race, maiden name like (Ms. Mrs. Ms), & criminal history questions. I was just curious what other Employers/HR Professional have done. Any information is greatly appreciated. Thank you!

like

Additional Posts in Data & Analytics Consultants

If you were to hang your own shingle as a consultant what BI tool would you use to deliver dashboarding to clients?

Assume that you aren’t plugging in to source systems as I primarily work in CDD.

like

This might be a long shot ... but I have a Statistics assignment due for tonight in a few hours

Does anyone know how to do Linear Discriminant Analysis with more than one predictor - by hand? I know how to compute in R but my professor wants it done by hand .... fml

likefunny

Hi! Does anyone know what kind of knowledge is needed to crack the Data Scientist interview at Google?

I'm currently working in Marketing Analytics (primarily using SQL and a bit of pyspark). Apart from mastering SQL, I wanted to know from people working at Google what does it take to get there as a Data Scientist? (I'm very interested in Strategy Ops)

I plan to another 6-8 months in preparation and upskilling myself before I even apply.
Any help and guidance is appreciated! Thanks :)

like

Are there RPA use cases in data work?

like

I am finishing up a project and I’m trying to document what I’ve done for my resume. What are some good metrics for someone who mainly created user stories, created dashboards, interacted with the client and developed statistical models? One of my dashboards got deployed to production but it’s to early to see the impact. My other dashboards are almost done but I’m moving on to something else.

like

Docket + R - I have an container running a rocker image and I’m trying to launch a bash terminal and the RStudio server (/init) at the same time. Is this possible? I tried adding CMD [“/init”] too.

like

Anyone who has done masters in business analytics Singapore? Could you help on courses, Scholarships and careers and jobs. Looking for help.

Looking for technical data analyst in Austin, tx (also have remote available) to join a series E startup. Need strong python & sql experience. A lot of data munging and cross-functional work. Love to chat if this makes sense. Cheers!

helpful

Is cross validation just about using different combinations of data blocks to test and train different predictive models in order to find the best model?

like

I have been working in healthcare clinics and health techs for a few years now. I’m an independent consultant. Bust, a friend of mine referred me to a big bank job. The role is of data governance manager. What should I know for the interview, or how can I prepare for it? Any thoughts? They told me I don’t need financial background. Data is data, but they wanted to know metadata management and how do I build frameworks/implement enterprise systems.

like

Fellow data 🐟, plz recommend me something to do tomorrow. Existing weekend plans went up in smoke and I'm feeling like trying something new

like

Of all the job pitches that I have received, this is the most incomprehensible so far.

Post Photo
like

Best analytics tools to learn? Know Alteryx but I've heard people say they don't consider it an advanced analytics tool

How does everyone in this bowl feel towards master’s degrees in data science/analytics? I didn’t study this in undergrad so I’m looking to get an analytics degree but I’ve heard mixed reviews.

like

Can anyone give insight to what the day to day looks like for a workforce analyst and what skills would make them successful?

(Backstory) I was interviewing for an HR Business Analyst role with a company, I didn’t get the job but they referred me to a “Strategic Workforce planning Analyst” role they have open bc it would be a better fit. I’m an HR Analyst and have been working with HR metrics for a few years, but I’m not entirely sure what that transition would look like.

like

To all my data engineering friends out there, do you all feel like trash sometimes? Like people dont understand shit about what you do, and clients just want to see some bs ml model/pretty but useless dashboards?

likefunny

Has anyone else begun to resent data science?

like

I am currently working mostly in Data Analytics, but I want to transition into Data Engineering. I've applied to a couple Data engineer positions but it seems I don't have the qualifications for them. Should I maybe look for Jr. Data Engineer positions to get experience and try to move up from there? If so anybody know of any Jr. Data Engineer positions available?

like

Does your company split data science roles into different practices like data & analytics and software engineering? Does this inhibit collaboration & Where does a data engineer fall?

like

What is a data lake in basic terms?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
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

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal