"I have run into this situation frequently as a data analyst. Each situation is similar to others to a certain degree. In most cases, stakeholders want answers to questions that are not available because of the limitations of the data that is collected or of the database structure. In these situations, I worked with the stakeholder to develop an analysis to answer related questions that may give them an answer as close to what they are looking for as possible. In the process, I tried to offer them a basic understanding of the data available and of the database structures--nothing too detailed as I thought this may confuse them. In the long term, we developed a project to investigate whether we are able to collect the unavailable data. This ensured them that I understood their needs and was willing to work hard at trying to get them what they needed."