So I know someone (I swear, it's not me) who has collected a bunch of data from a bunch of survey respondents in a bunch of formats: PDF, Word docs, spreadsheets. Some of it is quantitative, some of it is narrative. There's about 150 pages of it. So kind of not a best-case scenario.
What he'd like to do is display this (anonymized) data on a website for the benefit of the community from which it was collected. He's already obtained consent. He'd like to be able to display the data by anonymized "person" (i.e., by profile), but also allow for the possibility of some rudimentary analysis or visualization (e.g., how many of these respondents are female? how many are both female and of this ethnicity?)
My hunch is that he's best off using Drupal + CCK + Views. I have warned him that he has a lot of data-entry and a steep learning curve ahead of him. Important caveat: he does not know any programming languages.
So my questions are these:
• Do you agree that Drupal is his best option?
• If Drupal is the way to go, are there modules that make sense for collecting, displaying, and visualizing this kind of information?
• Can you recommend particularly good books or other resources for this use of Drupal?
Thank you, as always.