Sales Analytics and Modeling in Excel with ChatGPT
Created by Team Mammoth
01
Skill level
All levels
02
Sections
9
03
Lectures
57
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
9
Sections
✓
57
Lectures
✓
57
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ Introduction 2 lectures
01.01 Course Requirement
Locked
Course Requirements
Locked
+ Measuring Performance with KPIs 6 lectures
02.01.Project Preview
Locked
02.02. Sales Key Performance Indicators (KPIs)
Locked
02.03.Measuring Salesperson Performance Using KPIs
Locked
02.04.Marketing And Financial KPIs
Locked
02.05.Customer-Related KPIs
Locked
Source files
Locked
+ KPI Case Study 6 lectures
03.01.Project Preview
Locked
03.02.Case Study Involving KPIs
Locked
03.03. Joining Data Tables In Excel
Locked
03.04.Cleaning Data Using Filters In Excel
Locked
03.05.Determining Lead Conversion Time
Locked
Source files
Locked
+ Analyzing Sales Data 4 lectures
04.01. Project Preview
Locked
04.02. Aggregating Data By Regions, Categories, And Time Dimension
Locked
04.03.Evaluating Salesperson Performance
Locked
Source files
Locked
+ Visualizing Sales Data 9 lectures
05.01. Project Preview
Locked
05.03.Charting Region-Wise Percentage Contribution
Locked
05.04.Charting Category-Wise Average Order Value
Locked
05.02.Creating Charts To Visualize Sales Data
Locked
05.07.Building A Sales Dashboard
Locked
05.06.Analyzing Salesperson Performance
Locked
05.05.Analyzing Lead Generation Trends
Locked
05.08. Additional Charts For Sales Modeling
Locked
Source files
Locked
+ Sales Modeling and Prospecting 12 lectures
06.01.Project Preview
Locked
06.02.Building The Whale Model
Locked
06.05.Case Study On Lead Segmentation
Locked
06.04.Excel Preparation For Analysis
Locked
06.03.Lead Segmentation Using Decision Trees
Locked
06.07.Interpreting Results From Tree Nodes
Locked
06.08.Interpreting Results Based On Classification Criteria
Locked
06.06.Building A Model In Excel
Locked
06.10.Making Predictions Using The Trained Model
Locked
06.11.Advanced Customization Options For Models
Locked
06.09.Drawing Inferences From Model Results
Locked
06. Source file
Locked
+ Maximizing Customer Value 4 lectures
07.01.Project Preview
Locked
07.02.Market Basket Analysis For Cross-Selling Opportunities
Locked
07.03.Predicting Values Using The Trained Model
Locked
Source file
Locked
+ Sales Forecasting 9 lectures
08.01.Project Preview
Locked
08.02.Modeling Trends And Seasonality
Locked
08.03.Additive And Multiplicative Time Series Models
Locked
08.04.Linear Regression Model For Sales Forecasting
Locked
08.06.Building A Linear Regression Model
Locked
08.05.Preprocessing Data For Regression
Locked
08.07.Predicting Values Using The Trained Model
Locked
08.08.Using Xlstat For Forecasting
Locked
Source file
Locked
+ Customer Lifetime Increase 5 lectures
09.01.Project Preview
Locked
09.04.Evaluating Model Accuracy Using A Confusion Matrix
Locked
09.03.Predicting Churn Probability Using The Trained Model
Locked
09.02.Building A Logistic Regression Model For Churn Prediction
Locked
Source file
Locked
Instructors
Taught by people who ship.
Team Mammoth
Instructor
Produced by a team of Mammoth Club industry experts. Over 14 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.
Ready to start building?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.