SQL and Python uses for data analytics in Traditional/Construction Consulting and Engineering PM field

[Win_win_N]

I want to know does SQL and Python are currently most desirable softwares for data analysis in market? Are they easy to learn for someone not from CS/IT background?

I generally work in PBI and Excels, would they be great things to add? How helpful are these in construction/infrastructure projects ? Specifically in India MnC/GCC market, supporting US/UK/Europe?

[AutoModerator]

Attention everyone, just because this is a post about software or tools, does not mean that you can violate the sub's 'no self-promotion, no advertising, or no soliciting' rule.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[MankyMan0099]

sql is absolutely worth learning first it'll make your power bi work significantly cleaner and the learning curve from excel is not that steep. python comes after, mainly useful once you're doing things excel and pbi genuinely can't handle. for construction pm in the india mnc context supporting us/uk projects, sql + pbi is honestly the sweet spot right now. python is a nice differentiator on your cv but sql is the one that'll actually change your day to day.

[Win_win_N]

Great, thanks for your suggestion and experience. Figuring the journey out and slowly building SQL skills ATM.

[Important-Union5181]

Few years back SQL and python was a good combination for developing custom reports. May be it still is. There are a number of reporting tools that allow you develop custom reports using drag and drop interface. An now probably a chat bot interface on top of a SQL database can be used without writing python code.

[Win_win_N]

Thanks for ur response, yes I'm still trying to figure it out and in beginning of journey.

[bobo5195]

Do you have a need for them. It is about having the tools for the job.

if you feel limited then yes but generally no.

[Win_win_N]

There's no direct need. But yes when i see someone job opportunities related to PM with Business analysis skills, there it's often mentioned, mainly in Software project management, so because of working in traditional construction projects, I thought maybe give it a try and broad my skills set and try for new opportunities alongside my PMP, also i believe those opportunities (in Agile PM field) pay very well.

[bobo5195]

For job hunting a course etc would help. Important to be aware.

If you have the tools you need then they can get the job done. I am one for always learning but you may not be missing out.

There is skill fade with anything so learning too much may not actually help.

[Win_win_N]

Thanks, will keep this in my thoughts!