The biggest issue we find is that we do not know how to set up the right labels to properly import the data to get all of the great functionality we see from systems like Microstrategy, IBM Watson Analytics, Tableau, etc.
We are thinking to keep the data in the cloud but will need help with setup, organizing/loading the data, connecting an analytical tool, running initial analysis, and setting up some basic reports with static data initially. ... For the initial project, we have roughly 280 individual Excel files (the data dumps were so large that they had to be pulled by year for each location) and we need to get them all stored in the cloud (we’re thinking Dropbox, Google Cloud/BigQuery or Amazon Cloud) and connecting a suggested tool (ideally from the list: Microstrategy,
Tableau, Watson Analytics, etc.). We need help with regard to the proper setup for grouping the data in ways that will allow a layman to use the analytical software to see different visualizations.