I am Yifei Yan. I graduated from University of South Australia with program of Graduate Diploma in Data Science. I completed Bachelor of Science with majors: statistics, mathematics and biology in University of Canberra. I have acquired experience about data analysis during I was working on my project in University of South Australia. I am committed to providing the finest level of computer skills and statistical analysis on real-world research. I also have acquired the following skills and knowledge:
• Familiar with R packages in tidyverse such as readr, stringr, dplyr and ggplot2 to reading/manipulating/cleaning/analysing/plotting data. • Proficient in R with experience in using regular expression pattern to extract data from any text through searching and replacing strings. • Skills in R with dealing with big data through packages including ffbase, biganalytics and bigmemory. • Solid knowledge in ad hoc analyses of data through creating data visualisation report using R Shiny Flexdashboard, Power BI and DAX in order to sharing with end users. • Advanced skill in Microsoft SQL Server programming to manipulate, join, filter and aggregate data. • Advanced skills in MS Excel for both data analysis and visualization (data validation, Query Editor, Dynamic Pivot Table, Array Formula, Dynamic Array Functions, Lookup Function, Index Match Function, and Interactive Dashboards).
• Proficient in Power Query with experience in working with multiple excel datasets, ETL, data cleaning, data formatting and data merging. • Basic skills in Python with libraries such as, NumPy, Pandas and Matplotlib. • Familiar with SAS (SAS Enterprise Miner, SAS Enterprise Guide, SAS Visual Analytics) with experience in data summary, data analysis, data visualization and data modelling.