Analyse forum activity
Review site stats to inform persona for a later site redesign.
I mined the Breast Cancer Care database of 45,000 registered users to discover types of users and their behaviour to inform persona design.
I used my knowledge of SQL and Excel to query the database and perform analysis. I created graphs and wrote a report to document my findings.
Breast Cancer Care found the information useful because it confirmed what they suspected from moderating the forums but had no hard evidence for. The new forum launched in 2013.