Describe a challenging analytical problem you faced and how you resolved it when the data was incomplete or contradictory.