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 report presents the initial exploratory data analysis of the SwiftKey text corpora. It includes word and line counts, distributions, and a plan for building an n-gram prediction algorithm and deploying it via a Shiny app.