Professional Reports, Dashboards, & Software
The following are some of my formal, public-facing projects:
Interactive CalWORKs Resource Model
Stephanie Peng, Peter Amerkhanian, Joaquín Carbonell (2024)
Dashboard for The California Department of Social Services.
Live Report Dashboard Static Report
Summary: We produce an interactive tool to model the anti-poverty effects of state/federal supports on families participating in CalWORKs.
Contribution: Co-wrote R code-base, developed Tableau visual.
Tools: ipumsr, Tableau.
A Tale of Two Cities: Alameda and Alameda Point
Peter Amerkhanian (2023)
Consultant Report for The City of Alameda Department of Finance.
Report Executive Summary
Summary: I utilize various demographic and financial data to analyze redevelopment alternatives in the Alameda Point region.
Tools: geopandas, sklearn.
A Reexamination of Proposition 13 Using Parcel Level Data
Peter Amerkhanian, Max Zhang, and James Hawkins (2023)
Report for The UC Berkeley Institute for Young Americans.
Report Executive Summary Data Appendix
Summary: We utilize 12 million property records in California to estimate the tax discount effects of Proposition 13 across property types.
Contribution: Co-wrote R code-base, co-developed statistical design, wrote report draft.
Tools: tidyverse, marginaleffects.
Supporting Whole Families: SparkPoint® Community Schools
Peter Amerkhanian and Ena Yasuhara Li (2021)
Report for United Way Bay Area.
Report
Summary: I utilize client outcome data and interviews with clients and program staff to evaluate United Way Bay Area’s Community Schools program.
Tools: pandas.
Grade Migration Manager
Peter Amerkhanian (2019)
Software developed for Colegio Ismael Perez Pazmiño via The U.S. Peace Corps.
Code Slides Demo Video
Summary: I developed a full stack software application to migrate student grade data from a school’s excel-based system into the education ministry’s java application.
Tools: pyautogui, xlwings.
Teaching
The following are courses and workshops that I’ve taught, largely at UC Berkeley:
Python Data Wrangling Workshop
Peter Amerkhanian, Pratik Sachdeva, Tom van Nuenen, Aniket Kesari (2023)
Workshop designed and taught for the UC Berkeley D-Lab.
Code
Summary: I led a re-design of this 3-hour, flagship Python workshop for the UC Berkeley D-Lab. It provides an introduction to basic data wrangling actions – index, merge, group, and plot – using pandas.
Python for MBAs
Peter Amerkhanian (2023)
Workshop designed and taught for the UC Berkeley D-Lab.
Code
Summary: I designed this one and a half hour workshop and taught it to students at MBA students at UC Berkeley’s Haas Business School. The course directly connects pandas functions to equivalent workflows an intermediate Excel user would be familiar with.
Academic Course Papers
The following are some of my course papers from graduate school:
Simulating School Desegregation in San Francisco
Peter Amerkhanian (2022), Public Policy 275 Final Paper.
Paper Repo
Summary: I use a synthetic dataset of San Francisco public high school students and spatial optimization methods to simulate the effects of various busing strategies for racial desegregation outcomes.
Tools: geopandas, networkx. Methods: dijkstra’s algorithm, entropy/dissimilarity statistics.
Measuring Differences in California Politician Agendas in Press Releases
Peter Amerkhanian (2021), Information 254 Final Paper.
Paper
Summary: I use a novel dataset of press releases issued by governors and mayors in California to 1.) Develop a regression model to identify press release authorship, 2.) Cluster press releases by topic, and 3.) Estimate the political similarities between mayors and governors.
Tools: gensim, sklearn. Methods: logistic regression, latent dirichlet allocation.