[support] Data collection and analysis

[Metzler, David]

I have a report writing module that might be of interest to your project:

http://drupal.org/project/forena

If your SQL skills are up to snuff, then it might make some of the work lighter for you.

I have done some of this in the past using web forms, including some fairly complicated analysis, but it sounds like you want more than web forms will realistically offer.   Building a custom app with a custom data structure seems most straightforward, along with some statistical tables.

From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On Behalf Of Chris Miller
Sent: Thursday, November 14, 2013 3:27 PM
To: support at drupal.org
Subject: Re: [support] Data collection and analysis

From: "Anoop John" <anoop.john at zyxware.com<mailto:anoop.john at zyxware.com>>
To: support at drupal.org<mailto:support at drupal.org>
Sent: Thursday, November 14, 2013 3:06:56 PM
Subject: Re: [support] Data collection and analysis

If you are a planning to do custom programming on your own then I think that custom database tables and custom queries and views integration would be the way to go.
Yes.  I write code, so this confirms that there is reason to investigate this approach further.



I am assuming that you are going to do the analysis outside of the system in say libreoffice spreadsheets.
There will not be "spreadsheet" kinds of analysis.  The problem is to analyze the questions and compare the answer profile of one group with the answer profile of another.  We're interested in presenting how A compared with B in five categories  {A posed, B answered}, {A answered, B posed}, {A answered, B answered}, {A answered, B ignored}, {A ignored, B answered}, so you see it is messy stuff.  The first problem is to identify the five sets of questions. There is also a question authoring component which seeks to identify and match duplicates.  It just gets messier and messier.  I'm trying to reduce the messiness as much as I can, so using the least messy design in Drupal is important.



Thanks for the help,

Chris.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20131115/950b669e/attachment.html