Skip to content
View pengw710's full-sized avatar

Block or report pengw710

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
pengw710/README.md

A collaborative and results-focused data analyst with a passion to turn data into business decisions, experienced in project financial management and account disputes solutions, proven abilities in business understanding, problem-solving, details-oriented data analysis, and people skills.

Competencies:

  • Data Visualization, Data Analysis, Project Financial Management, Disputes Management Solutions

Skills:

  • SQL, Python, R, SAS, Tableau, Power BI, VBA, Advanced in Excel, MS Office, SAP FI

Pinned Loading

  1. SQL-Bank-Database-Design SQL-Bank-Database-Design Public

    SQL project including tasks of creating database and tables, identifying constraints, Client log in control, and Customer Accounts Details inquiries.

    TSQL 1

  2. Python-Data-Modelling Python-Data-Modelling Public

    Created the data model for an HR training record to identify the critical factors that impact the trainee’s future career decision. Used Python (Jupyter) pandas and matplotlib went through the whol…

    Jupyter Notebook 1

  3. VBA-Advanced-Excel---Office-Automation VBA-Advanced-Excel---Office-Automation Public

    Practiced EDA using advanced Excel skills included Charts, PivotTable, and Macro. Formatted tables using VBA, designed User Forms to collect client’s profile from users’ inputs, added client’s info…

  4. SAS-Bike-sharing-analysis SAS-Bike-sharing-analysis Public

    Analyzed 3M+ records of 2018 bike-sharing data of Washington city, identified the different user riding patterns between registered and casual customers, analyzed the key factors of converting casu…

    SAS

  5. R-Household-Expenses-Analysis R-Household-Expenses-Analysis Public

    Studied a household income & expenses report, identified the relationships between key attributes, analyzed and visualized the distributions of each variable.

    R 1

  6. COVID19DailyUpdate COVID19DailyUpdate Public

    Tableau dashboard visualization for COVID-19 daily update with historical trend, and business insights on COVID Response staffing plan.

    1