All the social event that were being organized by ebay generated some data, and this data was previously being stored in flat/excel files making it very difficult to manage and maintain. So we took up all the excel files, parsed them and squeezed it all into one database. Now all that scattered data is available at one place.
We have created a dashboard/portal which can used to view all that data in an organized manner. It also has filters (year,event, location) that presents the data in a more meaningful manner.
What inspired us? The sadness of the people who had to use and maintain these excels.
Target user - people at ebay and paypal involved in Social Innovation.
We have developed restful web services that consume excel files and upload the data into the system. There's the real magic in our code.