Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

14
SQL database options? Short term and long term
Post Flair (click to view more posts with a particular flair)
Post Body

So I work in a midsize healthcare company as the only data analyst. We mostly worked on excel only and google sheets. Recently got powerbi to do analytics. Most of our work happens on google sheets with multiple employees making updstes on google sheets and then I use this data for reporting. We have manageable number of employees so its not chaotic but we are planning to expand.

I am looking to get a sql database that could connect to these google sheets (nt sure if thats possible) for me to query data and send reports on regular basis (instead of copy pasting data every day for daily updates)

Im new to tech world and know sql a little but there are so many options out there that Im confused. Someone told me Azure sql is best, my friend recommended google query and another one recommended snowflake. Im more leaning towards a microsoft product but def open to any.

Also we may get a new sofrware in future to do stuff what we do on google sheets so please keep that in mind that the two softwares (future replacement for google sheets and sql database) should be able to connect.

Im also planning to start using microsoft access to get some handson and also act as a base to explain my manager how a database works.

Please shower me with some ideas

Author
Account Strength
20%
Account Age
1 year
Verified Email
No
Verified Flair
No
Total Karma
3,575
Link Karma
1,297
Comment Karma
2,278
Profile updated: 5 days ago
Posts updated: 3 weeks ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
9 months ago