This project presents a comprehensive immigration and security data analysis system using MySQL for backend data management and R for data visualization. The dataset includes visa applications, border entry logs, geospatial risk points, and regional security alerts. Through structured queries, indexed schema, and spatial analytics, the project extracts actionable insights such as visa approval trends, high-risk border zones, and anomalous travel patterns. Visualizations created with ggplot2 enhance interpretability of SQL-derived results. This portfolio project demonstrates advanced SQL, database optimization, and analytical storytelling with R

This project presents a structured MySQL-based system designed to manage and analyze immigration-related data, including visa applications, border entry logs, security alerts, and geospatial risk points. It features optimized database design, indexing strategies, geospatial functions, views, and stored procedures to support real-time decision-making and trend analysis. Key insights include visa approval trends, high-risk border locations, and anomaly detection in travel patterns.