Yes, best advice - DO NOT use Tableau for this. Tableau should be used for the visualisation (basically the output from the data warehouse), but Tableau is NOT a data warehousing tool. Prep is not really a data warehousing tool. It will work for small scale work, but it won't work as well as your data warehouse gets larger.
I can talk to you more about this directly if you want to, there's a lot of options when you're at the start of the journey and it's easy to make good and bad decisions
Hi Chris, Thank you for replying. I have come to realize exactly what you said to be accurate. With these aggregated files that I am trying to upload, compare, and export - i found it easier to add to the spreadsheet that is imported and refresh in the connections. I am definitely open to any pointers you may have, or suggestions on places to learn different things. To date, I have not really used Tableau for what I believe it is for, data visualization. I have used Prep quite a bit now and am getting familiar with it, but I have found some limitations as far as the formulas it allows you to use and the actions I want. Thank you again Chris, appreciate any and all feedback! Have a great week.
Thanks Can you mark my answer as correct if it answered your question please ?
For small amounts of data a spreadsheet would be fine, for larger amounts you want to start looking at a database. Something like Snowflake is a great start and it will scale as you do. You can contact me privately (details in my profile) for more info