Lee Yao

I am a Data Analyst

Lee Yao

I am a data analytics professional with excellent proficiency in coding and statistical programs such as EXCEL, SQL, Qlik Sense, Python, R, and Power BI. I also consider myself an active team player, Python-lover and Problem-solver. I have a huge passion for numbers, charts, and coding. I would love to use my skills to help organizations and myself grow within the role.

  • Katy, Greater Houston, Texas.
  • +1 347 749 3598
  • LeeYao.us@gmail.com
Me

My Data Analytic Skills

Microsoft Excel: Pivot Table, VLOOKUP, XLOOKUP
Microsoft SQL Server: JOIN, HAVING, CTE, SUBQUERIES
Qlik Sense: Back End and Front End editting, Dashboard building
Python: Numpy, Pandas, Matplotlib, Seaborn, Plotly
R/R-studio: tidyverse, ggplot2, readr, skimr, janitor
Microsoft Power BI: Power Query, Dashboard building

Microsoft Excel 70%
MySQL 55%
Qlik Sense 60%
Python 50%
Power BI 65%
R/R-Studio 25%
  • New York City Airbnb Datasets Tableau Dashboard Project

    New York City Airbnb Datasets Tableau Dashboard Project

     





    For detailed dashboard review, please click on New York City Airbnb Datasets Tableau Dashboard Project










  • Search This Blog

    Powered by Blogger.

    Blog Archive

    LOCATION

    Katy, Greater Houston, Texas

    EMAIL

    LeeYao.us@gmail.com

    TELEPHONE

    NONE

    MOBILE

    +1 347-749-3598