Dashboard: Visa Application Fraud

This dashboard was created to help Special Agents detect fraudulent visa applications using unstructured data from the Department of Homeland Security. I used Power Query in Excel to clean and structure the monthly datasets and collaborated with visa fraud experts to identify the most relevant red flags and risk indicators. These were then visualized in Power BI to highlight potentially suspicious cases.

The tool provided agents with an interactive dashboard to filter by key variables, track repeat offenders, and prioritize investigations based on a data-driven likelihood of fraud. I worked closely with the agency’s data science team to help automate the dashboard pipeline for regular use.

Tools Used: Power BI, Excel, Power Query
Focus Areas: Immigration fraud detection, data cleaning, dashboard development, investigative analytics
Key Insight: Empowered federal investigators to quickly identify and investigate high-risk visa applications using structured DHS data and red-flag indicators.