Erin A. Tsai
Data Analyst / Data Scientist
Work
Here are some projects I have completed showcasing my abilities to create dashboards, presentations and conduct data analysis using Python, R, SQL and Excel.
Table of Contents
Dashboards in Tableau
PowerPoint Presentations
Various Papers using Data Analysis and Research
PowerPoint Presentations
PowerPoint Presentation on Loan Origination System (LOS) Review
We were asked to compare the two Loan Origination Systems and to provide a report on the results.
Coding Language: Python to conduct analysis
Software Used: Excel for creating a calculated column for days of processing, and to easily filter out unneccessary data
PowerPoint Presentation on Proposal for New Data Structure to Increase Efficiency
We were asked to present a proposal to shift the company into a different data structure that would break the silos.
PowerPoint Presentation on Hulu Case Study
We were asked to choose a company to do a case study, identify a problem, and offer solutions. My group chose Hulu to compare to other video streaming services based on the low profit seen in 2019.
Various Papers using Data Analysis and Research
Is a new Mexican border wall really necessary?
We were asked to find data sets to analyze using R. I pulled data from the United States Department of Homeland Security regarding arrests at the Mexican border to analyze President Trump's claim that a Mexican border wall was necessary because of the increasing number of illegal Mexicans criminals entering the United States.
Coding Language: R
2012-2014 Gun Deaths in the United States
We were asked to choose a data set and create visualizations in MicroStrategy and conduct predictive analytics through any software of our choice. I created visualizations in MicroStrategy including various bar charts and line graphs. Additionally, I used RapidMiner to conduct predictive analytics to generate a model.
Software Used: MicroStrategy, RapidMiner >
We were asked to choose a data set and create visualizations in MicroStrategy and conduct predictive analytics through any software of our choice. I created visualizations in MicroStrategy including various bar charts and line graphs. Additionally, I used RapidMiner to conduct predictive analytics to generate a model.
Software Used: MicroStrategy, RapidMiner >
The Hunt for Vehicle Theft Predictors
We were asked to find a data set where we could apply regression analysis using Excel to identify significant predictors. Our group obtained statistics from the U.S. Census Bureau. We obtained demographic data from 1981 to 2008 and vehicle theft data from 2001-2016. We used the overlap time period of 2001-2008 to conduct our analysis. We used the census data to identify statistically significant predictors to predict future vehicle thefts. We used Microsoft Excel to create scatter plots and created a regression model based on our data. Our resulting model aligned well with our data.
Software Used: Microsoft Excel (PivotTables, VBA)
We were asked to find a data set where we could apply regression analysis using Excel to identify significant predictors. Our group obtained statistics from the U.S. Census Bureau. We obtained demographic data from 1981 to 2008 and vehicle theft data from 2001-2016. We used the overlap time period of 2001-2008 to conduct our analysis. We used the census data to identify statistically significant predictors to predict future vehicle thefts. We used Microsoft Excel to create scatter plots and created a regression model based on our data. Our resulting model aligned well with our data.
Software Used: Microsoft Excel (PivotTables, VBA)