Yifan Li

Detail-oriented Master of Statistics with advanced expertise in statistical methodologies and data analysis. Skilled in leveraging statistical software tools such as R and Python to derive actionable insights from complex data sets. Adept at data visualization and reporting, with the ability to communicate complex statistical concepts to non-technical stakeholders effectively.

Indian Liver Disease by Using Bayesian Inference

Individual Project                     November 2023 - December 2023

• In a data analysis project studying Indian liver disease patients, utilized R for data cleaning, and modeled sample data based on a logistic regression model. Generated a posterior distribution with 5000 iterations using the Markov Chain Monte Carlo algorithm (Gibbs sampling).
• During the exploratory data analysis phase of the project, optimized the data model and identified key factors affecting liver disease diagnosis in patients through the visualization of the posterior distribution (MCMC trace plots, marginal plots, and credible interval plots).
• The Bayesian inference-optimized model improved the accuracy of liver disease diagnosis in patients by 10% and increased efficiency by approximately 30%

QVC Database Design and Data Analysis

Project Member                       October 2023 - December 2023

• In the QVC database project, analyzed customer requirements to identify necessary data to be recorded. Used MySQL Workbench to construct an entity-relationship diagram (ERD) with 10 data tables and imported the data
• Wrote and optimized MySQL queries to retrieve key data from a database with over 10,000 records in an average of 0.5 seconds, significantly enhancing system read/write efficiency and improving system response speed.
• Addressed customer requirements by importing necessary data into MongoDB, writing MongoDB queries to achieve the same results as MySQL, and performing visualization analysis on the dataset.