Skip to content

lokesh97jain/H1B-Visa-Analytics-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 

Repository files navigation

H1B-Visa-Analytics-Dashboard

Project Overview

This project showcases a comprehensive Power BI dashboard for visualizing H1B visa application data in the United States. The interactive dashboard provides insights into application counts by state and city, industry distributions, and historical trends with predictive analytics for future applications.

Features

  • Interactive Dashboard: An intuitive interface to navigate through H1B visa application statistics.
  • Multifaceted Data Analysis: Industry-specific breakdown, geographic distribution, and application outcomes (approvals and denials).
  • Historical Trends and Predictions: Analysis of application trends over the years with predictive modeling for future trends.

Data Source

The dataset used for this dashboard is obtained from the United States Citizenship and Immigration Services (USCIS), detailing various aspects of H1B visa applications. The cleaned dataset for H1B visa applications from 2009 to 2023 can be found on Kaggle:

USCIS_H1B_Data_Cleaned_2009_2023

USCIS_Uncleaned_Data_2009_2023

Dashboard Sections

Interactive visualization of the H1B Visa Analytics Dashboard

Key Visualizations

Historical data and predictive trend of total applications. Sum of Total Application by Petitioner State Total Approval and Denial Counts Application Distribution by Petitioner City Industry-specific Application Analysis

Predictive Analysis

The line chart "Total Applications by Year" includes a shaded area representing the predictive model's forecast for future application volumes. This model is based on historical application data and trends, providing a forecast into the next few years.

Data Model

Data model showcasing relationships between the entities.

How to Use

  1. Clone the repository to your local machine.
  2. Launch Power BI Desktop and navigate to the cloned project directory.
  3. Open the H1B_Visa_Analytics.pbix file from the /dashboard folder.
  4. Refresh the dataset within Power BI to ensure the latest data is loaded.
  5. Explore the various visualizations and interact with the dashboard elements.

Tools & Technologies

  • Power BI for visualization and interactive dashboard creation.
  • Python for data preprocessing and predictive modeling.

Dashboard View -

image image

Model View

image