I want to know if Tableau could be a solution for me, but with all of my reading I don't fully understand any potential roadblocks.
I operate a company that tracks and analyzes player injuries for teams in the 4 major North American sports leagues. The teams register as members at my website (Wordpress CMS) where they access weekly player and team updates, tables of data, and some data visualizations. Only clients with accounts (Wordpress username and password access) can view the updates, data tables, etc on the site.
I've been searching for solutions to the cumbersome process I now have to update the data on the site, and how it is stored outside of the website. All data is stored and processed (lots of data manipulation and processing required and Excel remains the solution) on my local machine in Excel with backup copies on OneDrive. Data tables viewable on the website are uploaded as csv files to a Wordpress plugin that gives some nice functionality for the data (sorting, searching, etc.), but they are static. If I redo an analysis locally, I then have to re-upload updated csv data tables to the site.
My data visualizations are created in Google Sheets and uploaded to the site. Again, they are static and if updated locally have to be re-uploaded to the site.
I also have an enormous data table that I can only send to clients by email. It contains all players and all teams and their games and is 900+ columns and 1500+ rows by season's end. It's not feasible to display this table on the site with the current Wordpress plugin I use for displaying interactive tables.
So, all of this to ask if Tableau is a reasonable solution for me.
I would need to
1. Determine if Tableau Public, Server, etc. is a reasonable solution
2. Provide views of Tableau spreadsheet data on my site, including the 900 column 1500 row monster. Have all table views be interactive (sorting, searching), but read-only.
3. Have Tableau create my normal visualizations for me, and provide views on the site.
4. Block access to data in Tableau for anyone who isn't a client. Ideally to have client log in credentials on my website also control access to the Tableau data. I wouldn't want clients to have to log in to Tableau or require me to create a Tableau account for them.
5. Securely store proprietary data with Tableau, or have Tableau access the data securely stored in me OneDrive (or elsewhere).