About me

Hi there! I'm Yan Li

I graduated from MS Business Analytics program from SMU Cox School of Business in May 2020. As a data enthusiast, I'm skilled in Machine Learning, Database Management, Data Visualization, and Big Data Processing. And I am eager to utilize my analytics professions to define business problems, apply analytics techniques, and transform data into actionable insights to solve business problems and deliver business values.

To know more about me, here is my resume, or you can contact me via the following channels.

My Skills

My analytical skillset includes:

  • Data mining
    - Python, R, Advanced Excel

  • Data Visualization
    - Tableau, Power BI, R (ggplot2), Python (matplotlib, seaborn)

  • Database
    - SQL Server, ETL (Visual Studio, Alteryx), MySQL

  • Machine Learning
    - Regression: Linear regression, Polynomial regression, SVR
    - Classification: Logistic regression, KNN, SVM, Naïve Bayes, Decision Tree, Random Forest
    - Clustering: K-means, Hierarchical clustering
    - Association Rules
    - Natural Language Processing: Bag of words, Sentiment Analysis, Topic Model
    - Deep Learning: ANN, CNN
    - Dimensionality Reduction: PCA, LDA
    - Times Series Analysis: Winter’s method, Decomposition method, ARIMA models

My Projects

Following is a list of my top data analysis projects:

Time Series Forecasting

Generated Q3 EPS in 2019 forecast for Dollar Tree by analyzing FactSet data to extract insights on company, industry, macro economy, and potential risks

Database Design

Built a SQL Server database using data collected from Meetup, and developed an interactive shiny application to provide group and activity recommendations, visualize events information, and enable users to network effectively

Contact Me