Programming skills for a business role
Any programming languages you've found useful in a business role, e.g. PM? As a PM, I have only used Excel and Tableau for data analysis and visualization so far.
SQL tableau and python are mainly used I heard
This is what I heard as well but most people that work with tableau do no like their position from what I can tell
Oh really? Have they told you why they don’t like it? It’s just a visualization tool so it’s not as bad and good to know
R has been useful for some basic data manipulation that is too big for Excel.
Excel macros are something that might be worthwhile but I would stick with the pythons and sqls of the world
What are you doing with python that excel can't?
I mainly use SQL, trying to get into python these days.
For what sort of analysis are you turning to Python?
SQL, Power Query, DAX
I don't know how you can get by working as a software PM without having to do at least a little SQL or be able to take a query someone else wrote, understand what it's returning, adapt it a bit, then run it yourself. Python is probably not necessary but will allow you to make your life easier. You can automate a lot of routine things. It can also make up for a lack of knowledge in other areas like sql. You can get the same answer with a simpler Python script that you would need pretty advanced SQL knowledge to write a query to find. Also you can use it for web scraping and interacting with APIs. Pretty much every SaaS software you use has APIs you could be utilizing to make your job easier. You can also write scripts to monitor the competitions' websites, social media, etc. Nothing you can't do with other technologies or manually but with python you can automate it, set it and schedule it, get answers easier and faster, etc.
SQL and Python.
What have you used python for?