Hanna Lee- Data Storyteller and Analyst

Welcome to Hanna Lee’s e-portfolio! Take a look at how I utilized Power Query, R, SQL, Power BI, Tableau, Qualtrics, and Canva to clean the data, find stories in the dataset, and visualize findings. To connect with me, click here.

SUNY enrollment reports using Power Query + API

Click here and then “Learn more about how to get datasets using API” to learn more about how I fetched the data from data.ny.gov using API.

Data visualization examples using Tableau

All Historical enrollment report examples The query pipeline

*Note: detailed data are blurred.

Fetch API data using R and visualize in Power BI

Research question: How does retention rate impact completion rate across different racial groups?
Model: Linear regression
Data source: College Scorecard API
Factors:
Independent factors (X): retention_rate, race
Dependent factor (Y): completion_rate
Additional factors: institution_type (4 years, less than 4 years)

The visualization will be updated here once it is ready to be shared. Click here to check out the most recent R script.

Qualtrics dashboard examples

Designed a Qualtrics survey to assess the sense of belonging among international students at Washington University at St. Louis and received 103 responses. Approved sharing the findings, and some survey questions are blurred.

Infographics using Canva

Building Slate queries with SQL

Click here and go to the tab “For advanced users” to learn how I used various SQL commands to customize fields to build numerous Slate queries and reports.