Retrospective data collection and analytical techniques