Transformation and Load of Data into Tableau Server

Project Description

We are setting up a new data analytic environment.  The environment resides in a Amazon Web Services (AWS) private cloud.  At this stage our combined data is less than 500 GB and spread across a number CSV files.  The data represents ~8 domains. We need to load our data into a base set of tables, and then connect the data to Tableau where we can define relationships and produce an extract file for ongoing analysis. 

We would like to achieve the transformation and load over the next 2 days.  Today is 10/21/2014.