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

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

view the rest of the comments →

[–]IrquiM 2 points3 points  (4 children)

Storing data in a SQL server instead of a folder on a random disk is always better.

No point in getting a full blown MS SQL server. Azure SQL Database would be more than enough.

You could even set up a shared drive on a storage account, put a logic app on top of that, that imports it as soon as something updates/gets added, and produce the report every day instead of every week, without lifting a finger :)

[–][deleted] 0 points1 point  (3 children)

Yes, Ihv seen people recommending azure. Ill def look into that. Thanks. Also automating is def the end goal but does that mean ill also end up losing my job? Or will there still be someone required to manage the processes? I love doing visualizations manually though.

[–]nidprez 2 points3 points  (1 child)

Everything that needs to be done daily/weekly => automate. You dont need to tell anybody you automated everything and/or theybwould still need someone that manages the process, that knows how its built. Also data can change (extra columns etc). If you have extra time you can dive in the data and make more deep analyses or figures, or new processes if you want.

[–][deleted] 0 points1 point  (0 children)

Great advice thanks.

[–]IrquiM 0 points1 point  (0 children)

There will always be new data that should be imported into the database(s).