The U.S. Food and Drug Administration (FDA) is a federal agency responsible for safeguarding public health in the United States. It oversees various areas, including food safety, pharmaceuticals, medical devices, cosmetics, tobacco, and veterinary products. The FDA evaluates the safety and efficacy of drugs, biological products, and medical devices, conducts inspections, and enforces regulations. It also regulates food production and distribution, conducts research, provides public health education, and monitors and responds to emerging health risks. The FDA's mission is to protect and promote public health by ensuring the safety and effectiveness of a wide range of products and substances.
--> Final Dashboard
- MySQL---> Qurey writing parts
- Power BI---> Visualization parts
Part - 1 SQL Queries:
- Task 1: Identifying Approval Trends
- Task 2: Segmentation Analysis Based on Drug MarketingStatus
- Task 3: Analyzing Products
- Task 4: Exploring Therapeutic Classes and Approval Trends
Part - 2 Power BI Visualizations:
- i). Visualize the yearly approval trends of drugs. Highlight any significant patterns and/or fluctuations, if any.
- ii). Explore approval trends over the years based on different sponsors. Uncover patterns and changes in approval rates among sponsors.
- iii). Visualize the segmentation of products based on MarketingStatus.
- iv). Show the total number of applications for each MarketingStatus. Enable users to filter by years and MarketingStatus for detailed analysis.
- v). Analyze the grouping of drugs by dosage form. Visualize the distribution of approvals across different forms. Identify the most successful dosage form.
- vi). Visualize drug approvals based on therapeutic classes. Identify classes with the highest number of approvals.