1 of 1 people found this helpful
An important factor that I am keeping in mind for this reply, is 'right size'. Since your organization is small and you have had success with using Excel, I'd suggest looking into Access. Yes, it's another Office software and yes many people don't like it, but it may fit your needs and be relatively inexpensive. There's plenty of forums and sites offering solutions for design help, conversion solutions and even potential pitfalls. However, if your organization is able to spend some money on conversion and hiring a database developer to help lay the foundation, it may be worth the additional cost now, versus converting again in five years. If that's the case, something more powerful like SQL server may be worth researching or even a cloud based solution. If you have any databases in mind it might be helpful to list them for any future replies.
Just my two cents, best of luck and hopefully an experience database developer chimes in.
Thanks for the reply, Wes.
I'm pushing for the SQL Server route as I'd rather do this once rather than do it all over again in a year when we realize we should have gone with SQL Server from the start I looked and MSFT Azure can host what we'd need for $15/mo which is awesome.
We administer our surveys through Survey Monkey and I found a service called Zapier that will insert rows into a database as surveys are completed, which is killer. But I know how data comes out of Survey Monkey and it requires a lot of manipulating in order to work with Tableau (like taking 100 questions and turning them into a question_ID to be looked up in a separate questions table I setup and converting string values like "often true" to a 4 and so forth), so now it seems that the majority of my questions are related to "how do I take survey monkey data and manipulate it via SQL so I can use it in Tableau?" Access seems like a sort of stop gap measure (as you rightly seem to suggest) and while it may be more difficult to setup the SQL Server route in the beginning, ultimately it does way more for us and gives us some great options, namely around that being able to have our surveys automatically inserted into a table which we can then connect clients to via a live connection with Tableau Server or Online.
Thanks for the help!
No problem and I hope you can convince leadership to consider a longer term solution.
I'll have to look into Zapier. One of our marketing teams uses Survey Monkey quite often and it might help them stage the data for one of our analyst.
Best of luck!
If that doesn't work, simply use SSIS (which comes freely with almost all SQL-Server installations)