US Border Crossing Entry (1996-2021)

Completion Date:

06-01-2021

Project Overview

Gathering Border Entry and Freight information from Transportation Service Index (TSI) plays a vital role in economic ties between border countries and potentially useful economic indicator for the relationship balance and directions for policymakers to use.
The Data would be crucial to make valuable and sound decision on Security, Safety of the Road to maintain the existing one and building or expanding services and entry point personnel such as Boarder agents, wait and search areas, and more to provide a quick service on checking on Documents for travelers Freight information. Based on the data in hand and decisions made dependent upon will maintain safety and security of the country, building roads, bridges and Railroads depending on what is the most used entry point and for what purpose, and personnel assignments.

Role:

Power BI Developer

Problem Statement

Border crossing Entry to the US especially in high seasons and holiday become a nightmare for travelers to stay for hours in the process.
The job of Custom and Border Protection (CBP) at Entry points is not an easy task to fasten the process because of many restrictions, from individual paperwork to what they can bring into the US. Looking and cross-checking identification of individuals entering and deter unauthorized personnel entrance, searching vehicles from Drugs like Heroin and Methamphetamine hidden in vehicles and goods that are disguised as shipments took the heavy lifting on the CBP agents’ attention with the help of trained K9 Dogs.
The number of Border Crossing Entry is on the rise and needs a swift method to minimize the longer wait times especially on those busy entry ports. The Number of border crossing entries are up by more than 28% from the previous year and unless the process changes it would continue to be a problem, especially in holidays.

Executive Summary

Data Dictionary

Key Takeaways

Next Steps

Solutions (What to do Next)
1- By using the data trends, planning personnel management and infrastructure expansion should be done in less travel months.
2- Using Technology that detects vehicles can be placed further in the line and save time and would be non-intrusive inspection.
3- Flagged agricultural products should be informed for incoming passengers rather than ticketed and pulled over for each small thing that contribute to the longer wait times.
4- Finding informative ways to let the travelers know how long the wait time once entered will make them aware and prepared