CVM Dashboard

THE PROBLEM
Since 1987, almost 1 million adverse event reports have been collected on Veterinary Drugs and sent to FDA CVM. They are stored in a JSON file format  on OPENFDA that is not user friendly for the general public and the animal health industry. 

THE SOLUTION
Using Sharepoint Lists, Python and Tableau, I created a dashboard for the  Center for Veterinary Medicine at the FDA. The goal is to increase access data and increase transparency. The dashboard shows adverse event reports from a variety species and active ingredients.  

I started with downloading the data using the OPEN FDA AI and unziing the files using python. 

1. What problem were you trying to solve?
2. Was the problem well defined from the start or did you have to define it more clearly? How did you do that?
3. What difficulties did you encounter in solving the problem and how did you overcome them?
4. How did solving this problem/project change how you think about this type of problem? Does your learning extend to other problems of a similar nature?

RESULTS(Insert screenshots as needed)

FINAL THOUGHTS

 

I learned through this process about how different services like AWS or SharePoint pose different levels of security threats to the FDA. It took some time to find a solution that would work with FDA IT department. Also, I learned about the different costs of databases to run a dashboard. So, this made me have to evaluate the most cost effective option for this project. 

3. What difficulties did you encounter in solving the problem and how did you overcome them?

4. How did solving this problem/project change how you think about this type of problem? Does your learning extend to other problems of a similar nature?

PROJECT WEBSITE
For more details, check out the project's website here.