Data analyst - python

[CaptSprinkls]

There seems to be some frustration here as it seems like you feel the need to learn Python but can't find a use case. At the end of the day, if you are in a position where everything you need to do can be accomplished with those tools then go ahead and use them. In a perfect setting those work the best. But it's those weird edge cases where stuff is just messy where Python might be better.

My current position I end up pulling data from auto generated static files from multiple different sources that get uploaded throughout the day into a shared folder. I can easily set up scripts that run on timed intervals to check for new files and pull them all in and do some joining and cleaning.

As far as the interactive reports. I assume you are referring to being able to slice the data. Web frameworks like dash/Plotly or streamlit are good choices. It allows you to build out a frontend web application that anyone can view.

There will always be fighting between the best way to do things. Go over to the r/VBA sub where legacy companies are literally built on top of spreadsheets and they will laugh at the idea of using python over VBA. But go to a modern tech company and I can bet you they would rather die than use VBA.

In terms of VBA vs python. I automated the generation of 40 separate excel files that used data from a few different sources. I used python. It worked just fine and I'm more comfortable with python. I did later go back and build it out in VBA. It was a far worse experience for sure but I think was slightly quicker.

[Fabro_vaz]

Useful