Investigative Dashboard

This dashboard was created to detect fraudulent employer data using unstructured data. 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 investigators 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