Hi, I'm Xingzhou! 👋
Data Analyst, Digital Marketing Specialist, Sports Enthusiast
- Python
- Retail Store Customer Segmentation (Exploratory Analysis, K-Means Clustering, Elbow Method, Scatter Plot)
- Developing Models for Car Pricing (Linear/Polynomial Regression, Data Pipeline, Model Visualization, Model Evaluation)
- Data Cleaning for Laptop Pricing (Missing data, Replacement, Standardization, Normalization, Binning, Indicator Data)
- Google Analytics (GA4)
- Google Merchandise Store Analysis (Acquisition, Engagement, Funnel Visualization, Path Exploration)
- Data Visualization (Tableau)
- Excel (PivotTable, VLOOKUP)
- Regional Sales Data Across Canada (PivotTable, Line Chart, Bar Chart, Pie Chart)
- Exploring Parcel Delivery Data (VLOOKUP, IF(), SUM(), AVERAGE(), COUNTIF())
- SQL
- Data Cleaning for Housing Data (JOIN, SUBSTRING, PARSENAME, CASE, Rownumber())
- SQL Queries to Explore Covid-19 Data (JOIN, ORDERBY, GROUPBY, SUM(), MAX())
- Fan Engagement for Women Football (see my post!!!)
- Transformation of Sports Venue
- Holborn F.C Attendance Analysis
- Data Analysis with Python
- Visualization with Tableau
- Data Analysing Using Excel
- Databases and SQL for Data Science with Python
- Google Analytics (GA4)