Fundamentals of Predictive Analytics using Google Sheets | August 6 to 8, 2025 |PHP3100.00 | via ZOOM
Embedded Files
Description: Users can easily perform predictive analytics in Google Sheets which includes accessibility and powerful built-in functions along with real-time collaboration in a familiar cloud-based environment. The smooth integration of add-ons XLMiner and Simple ML with Google Sheets allows beginners to create models and extract insights without needing to write any code. It provides a smooth transition from elementary spreadsheets to advanced data analysis tools while enabling quick learning and prototype development.Â
Day 1: Foundations of Predictive Analytics
Introduction to Predictive Analytics
Real-World Applications of Predictive Analytics
Descriptive vs. Predictive vs. Prescriptive Analytics
Google Sheets for Predictive Analytics Add-ons: XLMiner, Simple ML
Data Import and Preparation
Data Cleaning and Transformation
Exploratory Data Analysis (EDA) in Sheets
Descriptive Statistics
Frequency Distributions and Summary Tables
Basic Data Visualizations
Day 2: Predictive Modeling with Google Sheets
Simple Linear Regression in Google Sheets
Introduction to Classification
Logistic Regression Basics
Predictive Modeling with XLMiner/Simple ML
Model Evaluation Metrics: Accuracy, Precision, Recall, MAE, RMSE
Day 3: Advanced Techniques and Applications
Time Series Forecasting: Moving Averages & Exponential Smoothing
Cluster Analysis and Customer Segmentation
Scenario and What-If Analysis (Goal Seek, Data Tables)
Creating Dashboards in Google Sheets
Communicating Predictive Insights Effectively(LookerStudio)
Page updated
Google Sites
Report abuse