This project delivers a multi-page Power BI dashboard analyzing more than a decade of U.S.–Canada border crossing activity. Using advanced data modeling, optimized DAX measures, and interactive geospatial visuals, the dashboard provides clear insight into movement patterns, top-performing states and ports, and year-over-year traffic trends.

The report features KPI cards, drill-through navigation, comparative border metrics (U.S.–Canada vs. U.S.–Mexico), seasonal and long-term trends, and a global port map built for rapid decision-making. Data was cleaned and modeled using Power Query, while DAX functions handled dynamic time intelligence, ranking, and YoY percentage change calculations.

This project demonstrates my ability to analyze large datasets, design intuitive analytical experiences, and translate complex mobility data into actionable insights suitable for government agencies, transportation planning, and cross-border operations.