Esther Bergen
Portfolio of Data Projects
Welcome! This portfolio contains a mix of both personal projects and schoolwork from my M.Sc. in Data Science.For details about my education and work experience, check out my LinkedIn page or email me for a resume.
Regression Model: Early Intervention
In this machine learning project, I used Portuguese school system data to predict which students would benefit from early educational intervention. It is written as a report to a board of directors with limited technical knowledge.Tools: Python, Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn
Patent Licensing Form
I created these forms for Ohio State University's patent licensing office when government regulatory changes required a shift in reporting procedures. The form allowed the compliance officers to efficiently obtain the required details from the licensing officers, then use the generated data to complete their reports in a timely manner.Tools: Microsoft Forms
Top 20 Video Games
My husband wanted to make a compilation video of our friends' most beloved video games of all time. He invited everyone to send in their top 20 lists.I took charge of collecting and organizing the data. I used Excel to answer some questions I was curious about:
- Which games were the most popular?
- How popular were the games chosen by each person?
- How many games were exclusive to each person?
- What was the correlation like between different people?
- Which games did [person 1] and [person 2] have in common?Tools: Excel
Tableau: Sales Trends
This Tableau workbook dives into sales data broken down by category, quarter, region, and more. It includes multiple types of charts, a dashboard, and a Tableau story with insights and suggestions.Tools: Tableau
Netflix Data Preparation
In this SQL file, I created and cleaned a table of Netflix data to prepare it for analysis. The cleaning steps included finding and handling null values, fixing errors in consistency, and reworking columns to make them more helpful for analytical purposes.Tools: PostgreSQL