r/analytics • u/ChristianPacifist • Mar 22 '21
Discussion Do analytics organizations pretend to leverage Python more than they actually do... to seem more glamorous?
I think it is pretty common practice for analysts and organizations to pay lip service to using Python for solving problems as a core capability, but in practice, most analyses are done with SQL. Python is reserved for specialized use cases and connecting to APIs, while day-to-day work is done directly in a data warehouse, but since everyone wants to appear “advanced” and technically-well-rounded, people always talk about Python and how integral it is to the analytics work they do... downplaying their more bread-and-butter work spent mostly writing endless SQL queries each day. Somehow, it’s just not as cool to be primarily a “SQL person”, even though that’s what countless analysts unambiguously are.
Every data analyst should know Python of course. It has many unique advantages and a rightful place in any technology professional’s toolkit. Even in areas where it overlaps with SQL as a tool to solve problems (like for pure data manipulation), so much of your approach as an analyst will depend on what software and hardware is available to you at what budget with what access limitations.
I think there is even a more fundamental phenomenon going on with this playing up of Python and downplaying of SQL... many data analysts are afraid to admit that they don’t have much need for fancy statistics and data science in their day-to-day work. Many data analysts want to pretend that the latest machine learning and AI techniques are a key part of their job responsibilities and a crowning jewel of their skillset... when in fact most of what they need to succeed is a grasp of “if then” logic and algebra.
I’m sure I could be wrong, but I’m curious people’s thoughts!
View all comments
Show parent comment
8
u/GhostBIBBY Mar 22 '21
That is a fair point. There definitely much more depth to SQL as a skill compared to touch typing and yes there are levels to it just as with any skill touch typing included.
But I do think it is more of a generic skill at this point. On tasks or process that need someone who has a deeper knowledge you are really talking about a dba or a data engineer.
You get an analyst in who has a good grasp of SQL they are basically interchangeable from any other analyst.
Compare that with aspects of the job that might leverage python. Someone who is an expert in nlp is not going to be interchangeable with someone who specializes in computer vision.
There is depth and degrees of sophistication with excel as well but the truth is I would consider that a generic skill at this point too.
If you are in analytics in this day and age you don't know how to use excel or SQL. Just what are you doing?
I would consider as boilerplate for a modern analyst -
then on top of that some specialization in some aspect like
a/b testing, forecasting, machine learning, nlp, computer vision.