This project is aimed at gaining insights on mental health consisting of 5 factors
- Depression
- Eating Disorder
- Anxiety Disorder
- Bipolar Disorder
- Schizophrenia
The link for the datast is https://ourworldindata.org/grapher/burden-disease-from-each-mental-illness
- SQL server
- Tableau
- SSMS
After importing data in SQL, Queries were fired to get data for :
- YoY change for different countries across the world from 1990 to 2019
- Percentage change in the number of cases reported
- Number of distinct countries in the dataset
- Getting data based on specific country and year
- Top and bottom performers based on the parameters
- Top and bottom performers based on the Year
- Top 5th Region based on the parameters.
Queries can be refrenced here.
After getting the results for comparison, next step involved creating dashboard on Tableau which allows the user to toggle between 3 navigation buttons:
- To see yearly trends
- To make comparisons globally
- To add and make comparisons on countries of choice Click for the Tableau dashboard
Here are the few insights :
- In general Anxiety Disorder has been reported to be increasing over the years 1990-2019
- Bipolar disorder cases saw sharp increase in the years 2000-2003
- Depression has seen decrease in the cases after year 1998 with negative changes over years from 2001-2007 which is a good thing
- Eating disorder and Schizophrenia has seen increasing trend
- Top and bottom countries for Anxiety disorder are Portugal and Uzbekistan respectively
- Top and bottom countries for Deprsseion are Uganda and Brunei respectively.
- Most of the top countries reporting depression are from African continent exception being Greenland
- Most of the top countries reporting Schizophrenia are from developed nations with USA with maximum cases and Somalia on the lower end witgh the least cases.
- Asian countries Taiwan, China and North Korea are towards the end for cases related to Bipolar disorder and New Zealand on the top
- For most of the regions over the years depression is the main mental health contributing factor.
-
Given the increasing trend, promoting awareness and early intervention is crucial.Encourage stress management techniques, mindfulness, and seeking professional help
-
Address stigma around mental health to facilitate open conversations
-
Support systems play a vital role; encourage family and friends to be understanding and patient
-
Promote mental health education in schools and workplaces. Encourage physical activity, social connections, and seeking professional help when needed.
-
Educate healthcare providers about early signs and effective interventions.Foster a supportive environment for those struggling with eating disorders
-
For Schizophrenia acknowledge the burden in developed nations and prioritize community-based care.Advocate for research funding to improve understanding and treatment
Regional Considerations:
- In African countries reporting high depression rates, invest in mental health infrastructure.
- Collaborate globally to share best practices and resources.
- Tailor interventions based on cultural context and local needs.