Skip to content
View elaine-yuan's full-sized avatar

Block or report elaine-yuan

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
elaine-yuan/README.md

πŸ‘‹ Hi, I'm Elaine

I'm a Data Analytics Consultant and Data Visualization Expert. I organize and leverage data through data visualization.

πŸ”‘ Key Skills

  • Tableau
  • Alteryx
  • Microsoft Excel, Google Sheets
  • SQL
  • Project Management

πŸ’Ό Interactive Resume

πŸ“Š Data Viz Projects

See more: Tableau Public

πŸ“ Project Samples

Always Alien: An Analysis of Anti-Asian Hate Crimes | SQL, Tableau, PowerPoint

  • Analyzed 219,576 records of national hate crime data and 1,296 records of NYPD hate crime data
  • Queried NYPD hate crime data using SQL to understand when and where anti-Asian hate crimes occurred in New York City and utilized geospatial data files in Tableau to build visualizations
  • Calculated the increase of anti-Asian hate crimes from 2019 to 2020: a 94% increase nationally contrasted with a 2700% increase in New York City
  • Determined Queens to be the safest borough with a rate of 4 anti-Asian hate crimes per 100,000 Asians using SQL and visualized the incident count per capita in each borough using Tableau
  • Designed interactive dashboards in Tableau for audience members to explore a three-decade history of national hate crimes and recent hate crimes by bias in New York City

Journey to the Best: Global and Chinese Growth in Green Energy | Excel, Tableau, PowerPoint

  • Studied 9,745 total records of renewable energy data and 34,936 records of global power plant data
  • Examined the worldwide growth of renewable energy generation and global power plant capacity in Tableau and discovered a 445% increase in hydroelectricity generation from 1990 to 2019
  • Surfaced insights and animated visualizations on Chinese leadership in the green energy sector using Tableau: in 2019, China produced 30% of global hydro energy, 28% of global wind energy, and 33% of global solar energy
  • Recommended the development of nonrenewable nuclear energy: although nuclear power plants are <1% of total power plants, they accounted for 7.15% of global power plant capacity

πŸ… Certifications

πŸ“« Contact

Pinned Loading

  1. asian_hate asian_hate Public

    Always Alien: An Analysis of Anti-Asian Hate Crimes

    1

  2. energy energy Public

    Journey to the Best: Global and Chinese Growth of Green Energy

  3. marketing_analytics marketing_analytics Public

    2022 Q1 Marketing Report

    Jupyter Notebook 1

  4. data_with_danny_8_week_sql_challenge data_with_danny_8_week_sql_challenge Public

  5. petmind petmind Public

    Product Recommendations for Monthly PetMind Subscription Boxes

    Jupyter Notebook

  6. travel_assured travel_assured Public

    Understanding Customers to Better Advertise Travel Insurance

    Jupyter Notebook