The Data Analytics Challenge was a project where we received a large .csv file of various medical records. Our job was to clean up the data, and analyze the data. We used Tableau Prep to clean and organize the data. Tableau Prep made it really easy to omit the data that we weren’t interested in, as well as locate spelling errors, and other issues in the data. From there we used tableau, and excel to create spreadsheets, and graphs showing how the data changed over time. This allowed us to answer the following questions: 1. Which rare diseases had the most trials? 2. Can you identify future trends in clinical trials?
We also used the data to create an infographic. This infographic helped us visualize our conclusions in the challenge, and properly lay out the work we did.