These tools are great and I love DabbleDB. But I think the powerful version of these same concepts is a 'Data Repository and Reporting' service. A service that lets you suck in data from many sources (csv, Web Feeds, Database Queries, Emailed Reports, SMS, mailing lists, etc). It would not be scared to hold all this data for me and keep it secure (and would charge me for usage so that people with lots of data pay their due). It would then give me a very flexible "Crystal Reports 2.0" meets DabbleDB interface to relate, dedupe, create conflict rules and schedule data refreshes. It would then let me create beautiful reports that can be embedded in a CMS, emailed, published like a Google Doc and versioned. If anyone is working on something like this, I have lots of ideas of how it should work that I would be happy to share.
1) Do you think this should be specific to a particular business process (like managing sales force performance, managing inventory, etc.) or open ended enough to just consume data in whatever form and let the user mold the application to their liking? I guess the short version of this question is: Will they know what they want?
2) You mention admin web interface to the app. Do you think this interface has a chance of being used by a non-IT people? Will business users have conceptual appreciation for data quality issues (great majority of problems with data analysis) like deduplication, incompleteness, errors, etc. Will creating clean data repositories (and therefore QA) be the core of this service or should the user be in charge at every point, allowing him/her to even get the "garbage in" and, what follows, "garbage out"?
3) Would the ability to create private data mashups with data provided by the service provider, other publishers, or publicly available be something of core importance or nice to have?
I have a lot of other questions, since I've started working on a web solution to this problem that would work in a way that is quite similar to what you've described. I would be great if you could share your responses/other thoughts further, either here or privately on my email (in the profile). Thx!
