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.
So I recently joined a small healthcare as the first data analyst and soon after we purchased powerBI. I cirrently work on excel to clean data and powerbi to import and analyze, prepare dashboards/reports. While this is very simple to what I want to do as a data analyst (especially that we are expanding our services currently). While this also means more data and more complexity.
Currently I store data in a drive that is hosted by our IT department.
I know basic SQL and want to keep that knowledge growing by using it at my work. I talked to my manager and he said if you think sql will help us any better than the regular drive where we store data, then we can get sql.
Whats the best SQL thing (not a technical person here) that I can use in my company that will help me maintain a database, use sql commands frequently and what would be the benefits of using a sql database vs regular drive where I store data manually. Also is ms sql a good option or azure sql database?
Just so you understand the nature of my work. We have 50 employees submitting 50 records everyday on google sheet. I take that data and paste in in excel, save the file with the employees name and date/year and store it in the drive. Every week, Im suppose to send a report saying how many records are submitting by each employee and whats the average, how many offices the reports were sent to and stuff like that.
Id appreciate a deep insight on what to use, how to convince manager and how to get sql in my organization
Subreddit
Post Details
- Posted
- 1 year ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/dataenginee...