top of page

Hi,
welcome to my work space.

A process of research, collection, analysis, and presentation. 

ABOUT ME

Kexin(Kate) Wang

     I am a new Business Analytics major graduate of University of Cincinnati with a heart filled with passion about data and visualization, always feel exited about problem solving and new challenges.
     Except address ways to interpret data information, I also value the aesthetics displayed in my works, caring about the experience of audience receiving messages is on of my priorities. 
     I am fully ready to bring my energy and enthusiasm to next role.
WeChat Image_20210902174237_edited_edited.jpg
2021-2022
Cincinnati, Ohio
University of Cincinnati, MS in Business Analytics
2017-2020
Cincinnati, Ohio
University of Cincinnati, BA in Marketing

POTFOLIO

Analysis and Prediction of Airline Passenger Satisfaction During COVID-19

In this project, an Airline Passenger Satisfaction dataset is used to answer the key question raised by low ticket prices and decreasing passenger satisfaction score since COVID-19 started: How can I help airline companies cope with decreasing passenger satisfaction levels? 

​

The primary goal is to predict binary dependent variables: satisfaction results (Satisfied/Neutral or Dissatisfied), through logistic regression models and a classification tree, and to further discover demographic characteristics and correlation relationships among different variables. This dataset includes more than 120,000 records and 24 columns, and dummy, integer, and categorical data types. Several tools were used to complete this analysis including 1) SQL for data management and further analysis; 2) R for data preparation and analysis; and 3) Tableau for data visualization and storytelling.

Gradient Background

AREAS OF INTEREST

A peak of key features in my projects.

Database Management

Data Analytics

Insights and Storytelling

Kexin Wang

©2022 by Kate's Portfolio. Proudly created with Wix.com

bottom of page