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.
rye004Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bbaoIT ConsultantCommented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PortletPaulfreelancerCommented:
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
0
rye004Author 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.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

rye004Author Commented:
Bbao,
I will look into that.  Azure may offer that.
Kind Regards,
Ryan
0
bbaoIT ConsultantCommented:
> Azure may offer that.

yeah, SharePoint and its related services are essential, integrated part of Azure, since beginning.
0
PortletPaulfreelancerCommented:
I was just trying to better understand the requirement. Unable to offer any recommendations for you.
0
a0k0a7Commented:
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.
0
rye004Author 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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft IIS Web Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.