The following data has been extracted from the USCIS(United States Citizenship and Immigration Services) data hub and is unmodified.
The idea behind this is to be able to look at trends in approvals and denials over the years, states, cities,zips,NAICS's and companies by providing users the capability to drill down to several levels of data and get real time visualizations as per your requirement and make data driven decisions. You can click on the drop down and make selections of your choice or you can also search for your requirement by typing in the search box. If you want to select multiple options, then use the CTRL key to make your selections. Additionally, when you hover over the filters you will see an eraser button which you can click to clear your selections. Also, it looks like there is no standardization/validation of data in the fields. I can't take the decision of standardizing the data by myself, without getting in touch with USCIS, so if you see garbage here then that means there is garbage data in USCIS data hub!
For Example: Some of the company names, cities are almost the same with some letters interchanged. For corrections, suggestions, improvement and feedback, please email email@example.com.
For the best experience, use Power BI section in fullscreen mode on a laptop.
Copyright © 2019 AWESOME SQL DBA - All Rights Reserved.
Powered by Awesome SQL DBA