Tianwei Xing Email and Phone Number

Led a team in integrating data using SQL and analysed data from over 1 million shared bikes in Los Angeles through a time series model. Clearly communicated actionable and final insights to stakeholders.Managed this project from data preparation through to analysis, overseeing collaboration of team members to ensure timely and accurate results.Increased bike utilization by 15 percent and enhanced member retention and satisfaction.

Analyse NSW2018-2022 accident data and operate Python to build predictive models (logistic regression models) to assess impact of weather and road conditions on crash rates in NSW.Restructured prediction accuracy by 25 percent, allowing insurers to adjust premiums more effectually based on identified risk factors. These insights led to a 10% increase in profit margins by better aligning pricing with risk.

Sentiment analysis of 85,000 tweets using R, NodeXL, and NLP.Led to increase positive sentiment by 20% at Boeing's public events through raised real-time communication and collaboration with key influencers.

Analysed biodiversity and tree health by Power BI, projecting carbon reduction for environmental improvements through boosted tree biodiversity.Improved health of trees on campus by 12% and jointly developed a sustainability plan report.