asked on

Web site suggestion that provide functionality similar to Microsoft Excel and Maps

I have generated a tool that collects tweets from twitter. I typically use Microsoft Excel and Maps to generate reports. I would like to provide the option to my clients to do this themselves over a web page. The twitter information sits on a SQL database which I have hosted by Microsoft Azure’s service.
OnyakTech does have some dot net nuke components that provide the Excel partition of what I am looking for, below is a link to them:

http://dnn-module.com/DotNetNukeDemo/ChartsDNNModule.aspx
http://dnn-module.com/DotNetNukeDemo/DataViewer/StandardDataDisplaywithExport.aspx

I am looking for some type of prebuilt solution for the web portion of what I am working on. My time is limited and better off working on the Twitter API instead of a web site.

Any suggestions or input would be greatly appreciated.

ASKER CERTIFIED SOLUTION

bbao

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

PortletPaul

Is DotNetNuke

mandatory ?
preferred ?
irrelevant ?

i.e. what are the technical constraints

You need a "data grid" and some charting of that.
Any specific features that must exist?
e.g. what chart type(s) are required

rye004

ASKER

I have an extensive background in .Net, so DNN is preferred, but not mandatory. I figure any coding that is needed I can attempt to do it myself before getting help.

I am looking for features sets similar to the pivot and graph options in Excel.
In regards to heat maps, I am looking to create a state based map (United States), showing were most of the tweets are coming from.

I would be interested in any suggestions that you have.

rye004

ASKER

Bbao,
I will look into that. Azure may offer that.
Kind Regards,
Ryan

bbao

> Azure may offer that.

yeah, SharePoint and its related services are essential, integrated part of Azure, since beginning.

PortletPaul

I was just trying to better understand the requirement. Unable to offer any recommendations for you.

a0k0a7

Take a look at Google Spreadsheets, in the past I used them to collect geo location and custom data for my markers in Google Maps and Google Earth. I enabled clients to use the free tool and share with them so they can add new content to the spreadsheets.

rye004

ASKER

SharePoint Excel Services seems to be the best method. I just now need to find a Map Control that will work in SharePoint Excel Services.