Tempe, Arizona, United States
1K followers 500+ connections

Join to view profile

Activity

Join now to see all activity

Experience & Education

  • Avnet

View Chengliang’s full experience

See their title, tenure and more.

or

By clicking Continue to join or sign in, you agree to LinkedIn’s User Agreement, Privacy Policy, and Cookie Policy.

Courses

  • Analytical Decision Modeling

    -

  • Applied Analytics

    -

  • Business Analytics Strategy

    -

  • Data Mining

    -

  • Data Visualization

    -

  • Data-Driven Quality Management

    -

Projects

  • COVID-19 Data Visualization with Tableau Desktop

    - Present

    Visualize the latest Covid-19 situation in the United States, developed a dynamic data visualization dashboard to show the total cases, deaths, and death rate for state and county.

    See project

  • Transportation Process Improvement - Honor Health

    - Present

    • Analyzed 20 predictors of security risk with frequency analysis and identified top 3 important predictors based on suppliers' profile and third-party data
    • Developed a new weighted methodology with 15 key parameters and improved the assessment of inherent risk
    • Generated a dynamic quadrant framework of security and inherent risk, identified top 10 risky suppliers from 1000 cases and developed more efficient Tableau dashboard for leadership to monitor risky suppliers

  • Logistic Regression with Python in Kaggle – Telecom Customer Churn Prediction

    -

    • Generated a relational database schema, imported and cleaned 7,000 customer data with SQL query
    • Identified statistically significant features, imputed categorical variables and Conducted data visualization of the correlation matrix using Python
    • Constructed a logistic regression model to predict customer churn with an 80% accuracy based on cross-validation

  • Used Car Price Prediction – Multiple Regression with Python in Kaggle

    -

    • Cleaned and imported 1.4 GB data into MySQL Workbench and extracted target information using SQL
    • Conducted EDA analysis, imputed missing data and generated feature engineering with statistical models
    • Developed a baseline model with multi-linear regression and predicted car price with 76% R Square accuracy

  • Information Security Supplier Risk Management - Accenture

    -

    • Imputed, visualized, and analyzed 45,000 hospital data for the transportation department with Python
    • Defined 3 statistical metrics to evaluate the performance of process control with Tableau dashboard
    • Utilized DMAIC analysis, created transportation process flow, and fishbone charts, analyzed time delay in each stage with simulation and improved weekly completed rate by 15%

  • Monte Carlo Simulation in Excel - APS Solar Energy Prediction

    -

    • Developed a Monte Carlo simulation model of solar power with 35,000 hourly data in Excel to observe output while changing input variables
    • Obtained Sunlight data through open-source API, generated predictive model of demand, production, and cost within two-level hierarchical clustering and uniform distribution to simulate changes of increasing solar panels
    • Delivered prescriptive analysis and provided useful insights with 20% lower cost based on simulation results

  • Data warehouse Design and Visualization in Tableau – World Classic Movies Rental

    -

    • Designed star schema with fact and dimension tables to analyze global sales, revenue, and quantity
    • Applied ETL from MySQL database with 50,000 transactions and created multi-dimensional dashboard in Tableau with descriptive analysis
    • Generated business insights with the most profitable item and states as well as historical trends through months

Honors & Awards

  • MSBA International Scholarship: $5000

    Arizona State University

Test Scores

  • GRE

    Score: 323

  • TOEFL

    Score: 97

More activity by Chengliang

View Chengliang’s full profile

  • See who you know in common
  • Get introduced
  • Contact Chengliang directly
Join to view full profile

Other similar profiles

Explore collaborative articles

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Explore More

Others named Chengliang Liu

207 others named Chengliang Liu are on LinkedIn

See others named Chengliang Liu

Add new skills with these courses

See all courses