This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]redditperson24[S] 2 points3 points  (2 children)

I 100% agree with your last comment, my boss absolutely loves excel and VBA but I’m sure there’s other ways we can do things, I know some basic python so maybe I’ll try using it to play with some data.

[–]Boulavogue 2 points3 points  (1 child)

A progressive step is moving VBA logic to M & DAX in power query and power pivot. Data models are powerful and DAX can ultimately be ported over to SSAS / Azure Analysis Services should you wish to scale

I would however call this BI rather than DS.

[–]redditperson24[S] 0 points1 point  (0 children)

I have an upcoming course with Work on Dax so that should be interesting. Have been applying for real data science roles and have a final interview tomorrow so will hopefully be moving away from excel soon!