David Wang Email & Phone Number

Vancouver, Bc, Ca

Canada

Automated Excel processes using formulas and VBA macros to format data● Used Power Query in Power BI for data cleaning and preparation for analysis● Applied R packages (ggplot2, lm() function) for exploratory data analysis to identify trends in datasets● Created Power BI dashboards using DAX calculations and visualizations● Prepared written reports and verbal presentations detailing analysis results and findings

Vancouver, British Columbia, Canada

● Used SQL for data querying to create datasets of over 3,000 data points for statistical analysis.● Created pivot charts and pivot tables using Excel to analyze agricultural data on crop rotations.● Utilized R packages ‘tidyverse’ and ‘dplyr’ for data quality investigation and data cleaning.● Implemented Power BI to create interactive reports and dashboards for non-technical users.● Wrote a scientific report covering economic and statistical analysis of crop rotations.

Vancouver, Canada Area

Marker for a Statistics professor in Langara College.