We help IT Professionals succeed at work.

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.
Comment
Watch Question

IT Consultant
Commented:
do you have a SharePoint server in place?

if so, the most easy way might be to export  the Excel file to the SharePoint server's Excel Services, if enabled.

FYI

"Excel Services is a service application that enables you to load, calculate, and display Microsoft Excel workbooks on Microsoft SharePoint 2013. Excel Services was first introduced in Microsoft Office SharePoint Server 2007. By using Excel Services, you can reuse and share Excel workbooks on SharePoint 2013 portals and dashboards"

https://msdn.microsoft.com/en-us/library/office/ms546696.aspx
PortletPaulEE Topic Advisor
Most Valuable Expert 2014
Awarded 2013

Commented:
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

Author

Commented:
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.

Author

Commented:
Bbao,
I will look into that.  Azure may offer that.
Kind Regards,
Ryan
bbaoIT Consultant

Commented:
> Azure may offer that.

yeah, SharePoint and its related services are essential, integrated part of Azure, since beginning.
PortletPaulEE Topic Advisor
Most Valuable Expert 2014
Awarded 2013

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

Commented:
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.

Author

Commented:
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.