Sonya Zhang

@UCLy67jUoPAQu8ttUQSej_vg - 1.5K subscribers

Hi, I am a Professor of Computer Information Systems at the College of Business Administration, Cal Poly Pomona. My research interests include Data Science & AI (data visualization, machine learning, and NLP using Python and no-code tools) and web and mobile analytics using Google Analytics, Google Tag Manager, and Google Search Console), Web and Software Development, Digital Product Management, Internet Entrepreneurship, and Online Learning. My YouTube channel shares lectures and demonstrations on data analytics and software development.

Home Videos Live Playlists

Mobile Analytics with Firebase and GA4

Mobile Analytics with Firebase and GA4 Sonya Zhang

419 views - 4 months ago

Turning My SEO Research Paper into a Video with Google NotebookLM | AI for Scholars & Students

Turning My SEO Research Paper into a Video with Google NotebookLM | AI for Scholars & Students Sonya Zhang

172 views - 5 months ago

Tableau Tutorial for Beginners | 10 Popular Charts + Dashboard Step-by-Step

Tableau Tutorial for Beginners | 10 Popular Charts + Dashboard Step-by-Step Sonya Zhang

87 views - 5 months ago

Master GA4 Dimensions & Metrics with Real Google Merch Store Data

Master GA4 Dimensions & Metrics with Real Google Merch Store Data Sonya Zhang

90 views - 8 months ago

Chapter 7-1 Simple Linear Regression

Chapter 7-1 Simple Linear Regression Sonya Zhang

186 views - 10 months ago

Chapter 2-2 Creating Distributions from Data

Chapter 2-2 Creating Distributions from Data Sonya Zhang

259 views - 10 months ago

Chapter2 1 1 Using Data Types of Data

Chapter2 1 1 Using Data Types of Data Sonya Zhang

181 views - 10 months ago

Text Semantics - Vectorization, Embeddings, Key Phrase Extraction, and Summarization

Text Semantics - Vectorization, Embeddings, Key Phrase Extraction, and Summarization Sonya Zhang

224 views - 10 months ago

Chapter 2-4 Measures of Variability (Range, Variance, Standard Deviation, Coefficient of Variance)

Chapter 2-4 Measures of Variability (Range, Variance, Standard Deviation, Coefficient of Variance) Sonya Zhang

203 views - 10 months ago

Chapter 2-6 Measures of Association Between Two Variables (covariance, correlation coefficient)

Chapter 2-6 Measures of Association Between Two Variables (covariance, correlation coefficient) Sonya Zhang

432 views - 10 months ago

Chapter 7-3 Categorical Independent Variable

Chapter 7-3 Categorical Independent Variable Sonya Zhang

64 views - 10 months ago

Chapter 4-2 Association Rules

Chapter 4-2 Association Rules Sonya Zhang

118 views - 10 months ago

Chapter 4-1 Cluster Analysis

Chapter 4-1 Cluster Analysis Sonya Zhang

154 views - 10 months ago

Chapter 3-1 visualization and table

Chapter 3-1 visualization and table Sonya Zhang

143 views - 10 months ago

Chapter 7-2 Multiple Linear Regression

Chapter 7-2 Multiple Linear Regression Sonya Zhang

115 views - 10 months ago

How to work with MindTap Code It Exercises

How to work with MindTap Code It Exercises Sonya Zhang

315 views - 10 months ago

Chapter 2-5 Analyzing Distributions (percentiles, quartiles, z-scores, outliers, box plots)

Chapter 2-5 Analyzing Distributions (percentiles, quartiles, z-scores, outliers, box plots) Sonya Zhang

184 views - 10 months ago

Chapter2 1 2 Modifying Data in Excel (Sorting, filtering, conditional formatting)

Chapter2 1 2 Modifying Data in Excel (Sorting, filtering, conditional formatting) Sonya Zhang

235 views - 10 months ago

Chapter 2-3 Measures of Location (Mean, Median, Mode, Geometric Mean)

Chapter 2-3 Measures of Location (Mean, Median, Mode, Geometric Mean) Sonya Zhang

168 views - 10 months ago

Chapter 4-3 Text Mining

Chapter 4-3 Text Mining Sonya Zhang

98 views - 10 months ago

Introduction to Topic Modeling - LDA NMF LSI PLSA Explained

Introduction to Topic Modeling - LDA NMF LSI PLSA Explained Sonya Zhang

362 views - 10 months ago

How to Create a GA4 Path Exploration for Conversion Optimization

How to Create a GA4 Path Exploration for Conversion Optimization Sonya Zhang

758 views - 10 months ago

How to Create a Pivot Table and Pivot Chart in Excel for Sales Data Analysis

How to Create a Pivot Table and Pivot Chart in Excel for Sales Data Analysis Sonya Zhang

1.2K views - 11 months ago

Cosine Similarity Explained: How Spotify & Netflix Recommend What You Love!

Cosine Similarity Explained: How Spotify & Netflix Recommend What You Love! Sonya Zhang

473 views - 11 months ago

How to Create a GA4 Shopping Cart Conversion Funnel

How to Create a GA4 Shopping Cart Conversion Funnel Sonya Zhang

513 views - 1 year ago

How to Transform Categorical Variables into Dummy Variables Using Analytic Solver

How to Transform Categorical Variables into Dummy Variables Using Analytic Solver Sonya Zhang

365 views - 1 year ago

ChatGPT vs Google Colab AI: A Battle of Code Generation for K-Modes Clustering

ChatGPT vs Google Colab AI: A Battle of Code Generation for K-Modes Clustering Sonya Zhang

472 views - 2 years ago

How to Create an ERD in Lucidchart and Export SQL to Build a MySQL Database"

How to Create an ERD in Lucidchart and Export SQL to Build a MySQL Database" Sonya Zhang

14.3K views - 2 years ago

How to Use Excel Scenario Manager to Analyze Different Business Scenarios

How to Use Excel Scenario Manager to Analyze Different Business Scenarios Sonya Zhang

753 views - 4 years ago

How to Use Excel What-If Analysis Tools: Data Table and Goal Seek

How to Use Excel What-If Analysis Tools: Data Table and Goal Seek Sonya Zhang

3.8K views - 4 years ago

Time Series Forecast with Seasonality and Trend Using Regression in Excel

Time Series Forecast with Seasonality and Trend Using Regression in Excel Sonya Zhang

21.1K views - 4 years ago

Time Series Forecasting in Excel Using the Forecast Sheet (with Seasonality)

Time Series Forecasting in Excel Using the Forecast Sheet (with Seasonality) Sonya Zhang

7.3K views - 4 years ago

Time Series Forecasting in Excel Using Moving Averages and Exponential Smoothing

Time Series Forecasting in Excel Using Moving Averages and Exponential Smoothing Sonya Zhang

30.3K views - 4 years ago

Handling Categorical Variables in Excel Multiple Linear Regression

Handling Categorical Variables in Excel Multiple Linear Regression Sonya Zhang

15.6K views - 4 years ago

Multiple Linear Regression in Excel: Step-by-Step Analysis and Interpretation

Multiple Linear Regression in Excel: Step-by-Step Analysis and Interpretation Sonya Zhang

50.6K views - 4 years ago

Simple Linear Regression in Excel: Step-by-Step Analysis and Interpretation

Simple Linear Regression in Excel: Step-by-Step Analysis and Interpretation Sonya Zhang

3.4K views - 4 years ago

How to Calculate Euclidean Distance in Excel (Step-by-Step Tutorial)

How to Calculate Euclidean Distance in Excel (Step-by-Step Tutorial) Sonya Zhang

28.1K views - 4 years ago

Regression Decision Tree Using Analytic Solver

Regression Decision Tree Using Analytic Solver Sonya Zhang

3K views - 4 years ago

Classification Decision Tree Using Analytic Solver

Classification Decision Tree Using Analytic Solver Sonya Zhang

3.9K views - 4 years ago

KNN Regression Using Analytic Solver

KNN Regression Using Analytic Solver Sonya Zhang

1.5K views - 4 years ago

KNN Classification Using Analytic Solver

KNN Classification Using Analytic Solver Sonya Zhang

3.1K views - 4 years ago

Logistic Regression Using Analytic Solver

Logistic Regression Using Analytic Solver Sonya Zhang

5.9K views - 4 years ago

Analytic-driven Optimization

Analytic-driven Optimization Sonya Zhang

766 views - 4 years ago

Attribution Models in Google Analytics

Attribution Models in Google Analytics Sonya Zhang

558 views - 5 years ago

Regular Expression (RegEx) in Google Analytics

Regular Expression (RegEx) in Google Analytics Sonya Zhang

1K views - 5 years ago

Search Engine Marketing (SEM)

Search Engine Marketing (SEM) Sonya Zhang

686 views - 5 years ago

Search Engine Optimization (SEO)

Search Engine Optimization (SEO) Sonya Zhang

884 views - 5 years ago

Time Series Forecast Using Analytic Solver

Time Series Forecast Using Analytic Solver Sonya Zhang

2.1K views - 5 years ago

Box Plot Using Analytic Solver

Box Plot Using Analytic Solver Sonya Zhang

659 views - 5 years ago

Linear Regression Using Analytic Solver

Linear Regression Using Analytic Solver Sonya Zhang

3.3K views - 5 years ago

Text Mining Using Analytic Solver

Text Mining Using Analytic Solver Sonya Zhang

4.2K views - 5 years ago

Association Rules Using Analytic Solver

Association Rules Using Analytic Solver Sonya Zhang

7.2K views - 5 years ago

K-means Clustering Using Analytic Solver

K-means Clustering Using Analytic Solver Sonya Zhang

12.4K views - 5 years ago

Hierarchical Clustering Using Analytic Solver

Hierarchical Clustering Using Analytic Solver Sonya Zhang

5.9K views - 5 years ago

How to Create Custom Dashboards and Reports in Google Analytics

How to Create Custom Dashboards and Reports in Google Analytics Sonya Zhang

1.6K views - 5 years ago

SQL Tutorial: JOIN, GROUP BY, HAVING, and Subqueries with NOT IN & EXISTS

SQL Tutorial: JOIN, GROUP BY, HAVING, and Subqueries with NOT IN & EXISTS Sonya Zhang

3.2K views - 5 years ago

Detach and attach database in Microsoft SQL Server Management Studio

Detach and attach database in Microsoft SQL Server Management Studio Sonya Zhang

47.1K views - 5 years ago

How to Install MAMP and WordPress Locally on a Mac (Beginner-Friendly Guide)

How to Install MAMP and WordPress Locally on a Mac (Beginner-Friendly Guide) Sonya Zhang

757 views - 5 years ago

How to create table, primary key, foreign key, subquery using Microsoft SQL Server Management Studio

How to create table, primary key, foreign key, subquery using Microsoft SQL Server Management Studio Sonya Zhang

40.9K views - 5 years ago

Text Mining - Tokenizing and Clustering in RapidMiner

Text Mining - Tokenizing and Clustering in RapidMiner Sonya Zhang

12.6K views - 7 years ago