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

Curious what in-house lawyers are doing for pro bono (Model Rules recommend 50 hrs/yr). Feels harder in-house because organizations like Legal Aid seem to pair with firms or expect you to be practicing with a firm.

like

In person panel event - how Brands and Creators Win Together on TikTok. Let’s get together! DM @linkagency.official on IG if you would like to join

Post Photo
likefunny

Looking for tips on where to go in Caribbean in March. Ideally a great SPG/Marriott/Hyatt on the beach with solid local nightlife in walking distance.

like

I struggle to understand the overwhelming buzz and excitement about a Starbucks roastery coming to Chicago.
Has anyone been to one of their roasteries and found something decent?

Absolutely love my direct supervising partner, hate the firm management, pay is mediocre and I could get a 5 digit bump elsewhere, what do I do? (Mid-size insurance defense firm in southeast region)

like

Did anyone receive Form 16. I got mail but couldn't find in HR Workways

like

Any recommendations for patent prosecution practice management software for a small firm? Currently not using anything and want to be able to better manage and monitor associates.

People of Color, how do you deal with an all-white team who doesn't acknowledge your (worthy) accomplishments while pats all incompetent employees?

likefunny

How much minimum and maximum % hike can we expect after a year's appraisal.
Also if they provide any kind of yearly bonus if yes than how much can we expect the min and max

What do you think about the upcoming recession
Does crisil fire employees in case of the recession

Hi Team, I have joined GlobalLogic last week only and have been asked to join one client from cyber security domain but after joining got to know that client is chaning few things is team and because of that only they are also not sure if I will be assigned to that project or not. ( discussion still in progress with client )
What should I do ? Do they have enough project to accomodate me in different project ?
I also have offer from cognizant.
YOE - 8.7

like

anyone looking to case today?

like

469k new construction
No washer dryer or refrigerator included
Added these at cost, downgraded to basic grey paint throughout, removed blinds and builder accepted 460. Feeling cheated :/

What would have been a better offer?

like

Hello everyone. My joining date is 20/10/22 in natwest.But still i did’nt get any mail regarding my joining formalities.can anyone explain me that how many days it will take to complete my pes verification.

like

Which navigation apps do you prefer using besides google maps for driving long distances?

like

Consultants, would you join the Fed is given the opportunity?

like

Best school districts? I looked online but have seen mixed reviews

Hi - Can anyone share some light on the EY-Parthenon GDS service line? Is it similar to overall EY GDS or are there any EYP related differences? I heard they support the EYP case teams and work-life balance is a challenge.
Any EYP professionals here please weigh in with your thoughts.

like

CFGI offers anyone recently? Consultant level NYC what did you get offered

like

Additional Posts in Data & Analytics Consultants

My manager continues to ask me to help other teams and do work on other billable projects. I’m sick of it .. and I’m going to explicitly say that no I can’t do it because my hours are taken by the existing project we are doing. Is this appropriate?

like

Hello all, I’m a senior studying business and data science. Are there any entry level (2023) data science or SWE positions you recommend for me? I’ve really enjoyed ML and I’m proficient in Python and data science models like regression, decision trees, and k-means clustering etc

like

New data offering: name.co, or namesoftware.com for the main domain? I’m leaning toward name.co, but I worry about not having the .com.

like

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

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

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

What tech companies are best for Data Analysts? Looking for $120k base + equity that’s gonna be worth a lot + other great benefits + possible remote.

funny

What's the best way to compare the similarity of text between a smaller set of documents with a larger set of documents? Therefore, two vectors of vastly different sizes.

like

I have a undergrad finance degree and 5 years of big 3 credit rating agency work experience, what will help me more to get into a SFA role or product role at a tech company, a T15 MBA or a Georgia tech masters in analytics degree?

like

I'm non US citizen and thinking of moving back to EU. My plan is getting remote opportunities across the world and work as a freelancer. My speciality is Data analytics and BI (Qlikview, Tableau). 1) How likely I can get a gig from the US? 2) if a job looking for a remote 2-3 months contract do they care what country I'm in? 3) how can I compete Indian rates as I'm in Europe 60-70$ per hour as a BI consultant is a good rate but I see online rates as low 10$😫?

like

Have a lay-off meeting lined up, and now look for next opportunity. My background is around building machine learning models, data wrangling, visualization, feel confident with python. Open to any industry. Appreciate any lead on job opportunity. 3yrs of work experience

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

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

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

Anyone made the jump from EY DnA to Bain AAG (or vice versa)? I’m wondering how they stack up across technical capabilities, project mix, WLB, etc.

like

Have zero data experience. Best way to start self learning?

like

For those with experience with Apache Superset, please tell me more. Why do you prefer it, which environment does it work best in, pros/cons, and why should I choose it over Tableau/PowerBI?

like

Anyone here work or has interviewed for a data science role at DataRobot? Would love to get some insight. Third interview coming up.

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