jacobcentofanti.com

Here is a snippet from a Project I did for a class "Data Analysis and Reporting." This is information provided is not sensitive information, this project was on the fictional "Adventure Works" company. The numbers were pulled with MS SQL Server, analyzed in Excel, and I used Excel to produce the visualization for this project. The whole project is available upon request as this is just a small highlighted section. Within this project, the work was rather strenuous on this project given the time we had to work on it, but I have not modified it to make it look better. I want things like that to highlight my ability to work under pressure of deadlines.

The following is a snippet from a capstone project that I did in my final semester for the Little Rock Fire Department(LRFD). I have been given permission by LRFD to present these images. The following seems a little cluttered, but under the LRFD's guidance, they wanted something interactive and to potentially show a predictive analysis between locations that they had incidents occur and businesses that had active inspection violations. This was technically not possible because there was no way to combine those tables.

What I ended up doing was using Excel CSV files, I used a list of addresses within the Inspection Violations list that they gave me and used Google's Geocoding API to produce latitude and longitudes for those addresses. Which I then used in the image below.

Here is where I used Visual Studio to create a Python program that would take the csv files, take the latitude and longitude from the csv files that had inspection violations, and match them with incident locations to figure out and help predict which businesses that had active inspection violations had related incidents occur on location (within 30ft of the location).

With those matched locations and incidents I was able to summarize the information and produce key influencers as per the incident type that occurred. This will allow LRFD to take a look at what businesses were likely contenders to certain incident contenders, and utilizing my other included interactive pages, they could select the business name and produce a list of incidents and active violations for that business.