Having data in a spreadsheet is great, but what's even better is to be able to explore it with graphical visualizations.
If your data is in Google Drive, getting it into DataHero is fast and easy. After logging in, click on the connect button in the middle of the left panel:
This will bring up an array of options:
Select Google Drive, and you will be prompted to authenticate to your Google account. Choose the account where your data lives and click Accept to arrive at this screen:
Walk through the pages and DataHero will find all the files in your Google account that contain data you can use. Select the "coffee_tweets_output" file and click Import.
DataHero will pull in the data and make guesses about what data type is in each column. You'll need to fill in column names. Once you've done that, click "It Looks Good!"
Your data is now imported and ready to work with. There are some suggested graphs, but you can make your own to communicate exactly what you want:
To get your own data flowing into DataHero you'll need to know a little bit about using Pig on Hadoop. Pig is the tool that will transform vast quantities of data to manageable aggregations usable by Google and DataHero.