<div dir="ltr">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. <div><br></div><div>If you are not planning to do custom programming on your own then content types, node references, views and views export should work for you.</div>
<div><br></div><div>I am assuming that you are going to do the analysis outside of the system in say libreoffice spreadsheets.<br><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><div><font color="#000000" face="tahoma, sans-serif">Thanks</font></div>
<div><font color="#000000" face="tahoma, sans-serif"><b><br></b></font></div><font style="font-size:small;font-family:tahoma,sans-serif"><b><font color="#000000">Anoop John</font></b><br></font><div dir="ltr" style="font-size:small;font-family:arial">
<font face="arial, helvetica, sans-serif" color="#444444">Chief Technology Officer</font><br><div style="color:rgb(153,153,153);font-weight:bold;font-family:tahoma,sans-serif;display:inline"></div></div><div dir="ltr"><b style="font-size:small;font-family:arial;color:rgb(51,51,51)"><font style="color:rgb(153,153,153)"><div style="font-family:tahoma,sans-serif;display:inline">
</div><br></font></b><div style="font-size:small;font-family:arial"><div style="color:rgb(103,78,167);font-family:tahoma,sans-serif;display:inline"><img src="http://cdn1.zyxware.com/images/email-signature/zyxware_logo.png" alt="Zyxware Technologies"></div>
<span style="font-family:tahoma,sans-serif"></span><font color="#674ea7" face="tahoma, sans-serif"></font><div style="font-family:tahoma,sans-serif;color:rgb(103,78,167);display:inline"></div><span style="font-family:arial,helvetica,sans-serif;font-style:italic"><font color="#666666"><div style="font-family:tahoma,sans-serif;display:inline">
</div></font></span><div style="font-family:tahoma,sans-serif"><font color="#999999"><span style="font-family:arial,helvetica,sans-serif">Be the change you wish to see in the world</span><font style="font-family:arial,helvetica,sans-serif"><span style="font-style:italic"> </span>- <b>M. K. Gandhi</b></font></font><span style="color:rgb(0,0,0);font-family:Arial;font-size:24px;line-height:24px;white-space:pre-wrap"> </span></div>
</div><div style="font-size:small;font-family:tahoma,sans-serif"><div style="color:rgb(102,102,102);font-family:arial,helvetica,sans-serif;display:inline"><span style="font-size:15px;font-family:Arial;color:rgb(153,153,153);font-weight:bold;vertical-align:baseline;white-space:pre-wrap"></span><div dir="ltr">
<table style="border:none;border-collapse:collapse"><tbody><tr style="height:0px"><td style="border:1px solid #ffffff;vertical-align:top;padding:8px 6px 8px 0px"><img src="http://cdn1.zyxware.com/images/email-signature/skype_logo.png" width="18px;" height="18px;"></td>
<td style="border:1px solid #ffffff;vertical-align:top;padding:9px 0px 0px 0px"><p dir="ltr" style="line-height:1;margin-top:0pt;margin-bottom:0pt"><span style="font-size:13px;font-family:Arial;vertical-align:baseline;white-space:pre-wrap;color:#15c;text-decoration:underline">aj_zyxware</span></p>
</td><td style="border:1px solid #ffffff;vertical-align:top;padding:6px 0px 0px 4px"><p dir="ltr" style="line-height:1;margin-top:0pt;margin-bottom:0pt"><span style="font-size:18px;font-family:Arial;vertical-align:baseline;white-space:pre-wrap;color:#aaa">|</span></p>
</td><td style="border:1px solid #ffffff;vertical-align:top;padding:8px 6px 8px 5px"><img src="http://cdn1.zyxware.com/images/email-signature/web_icon.png" width="16px;" height="17px;"></td><td style="border:1px solid #ffffff;vertical-align:top;padding:9px 0px 0px 0px">
<p dir="ltr" style="line-height:1;margin-top:0pt;margin-bottom:0pt"><a href="http://www.zyxware.com" style="text-decoration:none" target="_blank"><span style="font-size:13px;font-family:Arial;color:rgb(17,85,204);background-color:transparent;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap">www.zyxware.com</span></a></p>
</td><td style="border:1px solid #ffffff;vertical-align:top;padding:6px 0px 0px 4px"><p dir="ltr" style="line-height:1;margin-top:0pt;margin-bottom:0pt"><span style="font-size:18px;font-family:Arial;vertical-align:baseline;white-space:pre-wrap;color:#aaa">|</span></p>
</td><td style="border:1px solid #ffffff;vertical-align:top;padding:8px 6px 8px 5px"><img src="http://cdn1.zyxware.com/images/email-signature/fb_logo.png" width="18px;" height="18px;"></td><td style="border:1px solid #ffffff;vertical-align:top;padding:9px 0px 0px 0px">
<p dir="ltr" style="line-height:1;margin-top:0pt;margin-bottom:0pt"><a href="http://www.facebook.com/zyxware" style="text-decoration:none" target="_blank"><span style="font-size:13px;font-family:Arial;color:rgb(17,85,204);background-color:transparent;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap">www.facebook.com/zyxware</span></a></p>
</td></tr></tbody></table></div></div></div><div style="font-family:tahoma,sans-serif"><br></div></div></div></div><br><div class="gmail_quote">On Fri, Nov 15, 2013 at 4:24 AM, Chris Miller <span dir="ltr"><<a href="mailto:cjm@tryx.org" target="_blank">cjm@tryx.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-size:10pt;font-family:arial,helvetica,sans-serif"><div>Hi Folks,<br></div><div><br></div><div>I'm working on a data collection / analysis application. I need some advice.</div>
<div><br></div><div>I'm pretty sure I can use normal Drupal forms to collect the data, but when it comes to analyzing, I'm not sure that normal forms is the way to go. I have NO idea how that data would be structured in the database.</div>
<div><br></div><div>So, am I better off figuring out how:</div><ol><li>to explore the data as stored by Drupal </li><li>to make Drupal store the data in the form I like</li></ol><div>It will not be simply statistics; the questions will be part of what is collected; questions will be posed by participants and answers given and we need to make sense of all of it. We will need to record who poses which questions, and we are interested in comparing profiles of both posed questions and answers, so you can see it can't be reduced to summary math like averages and standard deviations.<br>
</div><div><br></div><div>How should I approach this?<br></div><div><br></div><div><span name="x"></span>Chris.<br><div><br></div><a href="tel:916.799.9461" value="+19167999461" target="_blank">916.799.9461</a><span name="x"></span><br>
</div></div></div><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br></div></div></div>