At first glance, the evolution of human behaviour labelled as "crime" and the increase in the proportion of offences observed by police and gendarmerie services remains one of the most important challenges facing humanity. Affecting lives, and costing people, communities and countries significantly now and in the future, the crime rate affects all countries around the world and disrupts national economies, impacting in particular a range of sensitive sectors, depending on the severity of this scourge as tourism.
For many years, this phenomenon has become a worrying problem in the consciousness of governments, which must face this imminent danger, considering finding a delicate balance between reducing short-term crime rates through a series of drastic measures to be undertaken, such as achieving a low unemployment rate, and long-term planning, by measures such as investment in education, which can be a basic pillar to be implemented to combat the impact of crime and a guarantee of annual growth in the tourism sector’s figures. Our analysis will therefore aim to answer a series of questions, if possible: how canEnsure that the positive impact of educational measures to combat crime will affect the development of the country and in particular the tourism sectors most exposed to the danger of this scourge?
- Population de l’Inde par ville : https://www.indiabudget.gov.in/economicsurvey/doc/stat/tab87.pdf
- Tourisme INDE 2014-2020 : https://www.kaggle.com/datasets/rajkachhadiya/india-tourism-20142020
- Crimes Records of India States by city : https://ncrb.gov.in/en/crime-in-india-table-addtional-table-and-chapter-contents
- School Enrolment in India: https://data.worldbank.org/indicator/SE.TER.ENRR?locations=IN
- Taux de chômage en Inde : https://unemploymentinindia.cmie.com/kommon/bin/sr.php?kall=wsttimeseries&index_code=050050000000&dtype=total
- Indian School Education Statistics : https://data.gov.in/catalog/school-educationstatistics?filters%5Bfield_catalog_reference%5D=4241621&format=json&offset=0&limit=6&sort%5 Bcreated%5D=desc
- Microsoft SQL Server Management Studio
- Microsoft SQL Server Integration Services
- Power BI
- Python (for web scraping)
- I1: What year had the highest/lowest crime rate.
- I2: Which cities have the highest/lowest crime rates this year.
- I3: The most common types of crimes in India.
- I4: What is the population in India by city.
- I5: Relationship between unemployment rate and crime rate.
- I6: Relationship between school loss rate and crime rate.
- I7: Relationship between tourism rate and crime rate.
