Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel and PowerBI Automation Mastery with ChatGPT, Python, and Machine Learning: Practical Training and Practice Exam
ChatGPT for Sales Best Practices
01A Course Requirements (1:38)
01B Understanding ChatGPT (2:34)
01C The Role Of AI In Sales And Lead Generation (1:53)
01D Overview Of How ChatGPT Can Improve Outreach Strategy (1:34)
02A Project Preview (1:11)
02B How To Make Specific Asks (16:07)
02C Defining Terms For ChatGPT (3:15)
02D Understanding And Setting The Right Tone For Your Messages (13:05)
02E The Limitations Of AI In Sales And Lead Generation (12:45)
02F How To Utilize Chatgpt Effectively While Being Aware Of Its Limitations (16:09)
02G The Importance Of Checking And Editing AI Output (6:15)
Source files
ChatGPT for Outreach Strategy
03 Source files
03 01 Project Preview (1:18)
03.02 Defining Your Audience For Effective Outreach (19:40)
03.03 Using ChatGPT To Discover Audience Pain Points And How Your Product Solves Them (11:47)
03.04 Identifying Common Objections And Questions With ChatGPT (18:56)
03.05 Generating Cold Call Scripts, Elevator Pitches, And Battle Cards For Discovery Calls (15:16)
ChatGPT for Lead Generation
04 Source files
04 01 Project Preview (1:31)
04.02 Using ChatGPT To Generate Content Ideas For Nurturing Leads Through The Sales Funnel (19:10)
04.03 Sales Flow, Linked And ChatGPT (17:26)
Improve LinkedIn Sales with ChatGPT
05 Source files
05 01 Project Preview (0:59)
05.02 Understanding The Importance Of Linkedin For B2B Sales (3:04)
05.03A How To Use ChatGPT To Enhance Your Linkedin Sales Strategy (6:56)
05.03B ChatGPT And Linkedin Usecases (13:17)
05.03C Handling Lead Response With ChatGPT (6:48)
05.04 Best Practices For Using Chatgpt With Linkedin Message Templates For Higher Conversions- (8:36)
ChatGPT for Sales Role Play
06 Source files
06 01 Project Preview (1:33)
06.02A Using Roleplay To Anticipate Pain Points And Objections (5:13)
06.02B Conversational Role Play (15:14)
06.03A Advance Techniques For Utilizing ChatGPT In Sales (9:55)
06.03B Advance Tips For Brainstorming And Analyzing Pain Points (10:25)
06.03C Secret Prompts For Better Response (18:16)
07 01 Privacy Considerations (19:27)
07.02 Feedbacks For Continuous Learning (5:21)
Automate Excel with ChatGPT
01 Course Requirement (2:31)
02 Project Preview (1:36)
02A Set Up Excel Spreadsheet With GPT Add-In (8:37)
02B Excel With ChatGPT (4:51)
02C Write Excel Formulas With ChatGPT (9:39)
02D Use ChatGPT Formulas In Excel (16:18)
Module Reference
Source Files
Measure Sales Performance with KPIs in Excel and ChatGPT
01.01 Course Requirement (1:34)
02.01.Project Preview (0:57)
02.02. Sales Key Perfomance Indicators (KPIs) (10:16)
02.03.Measuring Salesperson Performance Using KPIs (5:48)
02.04.Marketing And Financial KPIs (6:49)
02.05.Customer-Related KPIs (10:20)
03.01.Project Preview (0:38)
03.02.Case Study Involving KPIs (3:09)
03.03. Joining Data Tables In Excel (7:28)
03.04.Cleaning Data Using Filters In Excel (5:19)
03.05.Determining Lead Conversion Time (7:18)
Source files
Sales Data Analysis and Visualization in Excel with ChatGPT
04.01. Project Preview (1:19)
04.02. Aggregating Data By Regions, Categories, And Time Dimension (6:25)
04.03.Evaluating Salesperson Performance (13:59)
05.01. Project Preview (1:18)
05.02.Creating Charts To Visualize Sales Data (8:08)
05.03.Charting Region-Wise Percentage Contribution (6:22)
05.04.Charting Category-Wise Average Order Value (5:47)
05.05.Analyzing Lead Generation Trends (7:54)
05.06.Analyzing Salesperson Performance (6:26)
05.07.Building A Sales Dashboard (6:22)
05.08. Additional Charts For Sales Modeling (8:33)
Source files
Sales Modeling in Excel with ChatGPT
06.01.Project Preview (1:33)
06.02.Building The Whale Model (6:47)
06.03.Lead Segmentation Using Decision Trees (6:53)
06.04.Excel Preparation For Analysis (6:52)
06.05.Case Study On Lead Segmentation (5:05)
06.06.Building A Model In Excel (9:38)
06.07.Interpreting Results From Tree Nodes (5:25)
06.08.Interpreting Results Based On Classification Criteria (5:23)
06.09.Drawing Inferences From Model Results (5:30)
06.10.Making Predictions Using The Trained Model (3:19)
06.11.Advanced Customization Options For Models (4:37)
07.01.Project Preview (1:05)
07.02.Market Basket Analysis For Cross-Selling Opportunities (6:27)
07.03.Predicting Values Using The Trained Model (11:01)
Source file
Sales Forecasting with Machine Learning
08.01.Project Preview (3:11)
08.02.Modeling Trends And Seasonality (10:03)
08.03.Additive And Multiplicative Time Series Models (9:30)
08.04.Linear Regression Model For Sales Forecasting (7:43)
08.05.Preprocessing Data For Regression (12:14)
08.06.Building A Linear Regression Model (8:27)
08.07.Predicting Values Using The Trained Model (8:26)
08.08.Using XLSTAT For Forecasting (7:56)
09.01.Project Preview (1:52)
09.02.Building A Logistic Regression Model For Churn Prediction (12:17)
09.03.Predicting Churn Probability Using The Trained Model (11:05)
09.04.Evaluating Model Accuracy Using A Confusion Matrix (12:28)
Source file
Automate Excel Data Manipulation with Python and ChatGPT
01 Algorithms To Handle Missing Data (5:13)
02 Generate Excel Data With Missing Data In Python And ChatGPT (3:22)
03 Fill In Missing Excel Data With Python Imputation And ChatGPT (3:51)
04 Delete Missing Excel Data With Python And ChatGPT (5:03)
05 Fill In Missing Data With Knn Imputation (5:24)
Source
02 Categorical data manipulation with Python and ChatGPT
01 What Is Data Encoding (5:36)
02 Perform Excel Data Encoding With Python And ChatGPT (7:18)
03 Choose Data Encoding Technique (3:01)
Source
03 Statistics for data science with Python and ChatGPT
01 What Is Statistics For Data Science (3:31)
02 Levels Of Data Measurement (3:58)
03 Generate Different Types Of Data With ChatGPT (10:02)
Source
04 How to measure data
01 Measures Of Central Tendency In Data (5:00)
02 Measures Of Variability In Data (4:09)
03 What Is Skewness In Data Science (3:38)
04 Generate Skewed Datasets With ChatGPT (7:44)
05 What Are Covariance And Correlation Data Measurements (2:37)
06 Measure Covariance And Correlation Of Dataset With ChatGPT (6:50)
Source
05 Probability distribution functions in data science
01 What Are Probability Distribution Functions In Data Science (4:39)
02 Calculate Probability Distribution Functions Of A Dataset With ChatGPT (5:22)
Source
06 Normal Probability Distribution with Python and ChatGPT
01 What Is Normal Probability Distribution (4:14)
02 Calculate PDF Of Normal Distribution Dataset (5:35)
03 What Is The Central Limit Theorem (2:45)
Source
07 Binomial Probability Distribution with Python and ChatGPT
01 What Is Binomial Probability Distribution (2:52)
02 Calculate PDF Of Binomial Distribution Dataset (10:50)
Source
08 Poisson Probability Distribution with Python and ChatGPT
01 What Is Poisson Probability Distribution (2:42)
02 Visualize Poisson Distribution With ChatGPT And Python (2:31)
Source Files
09 Uniform Probability Distribution with Python and ChatGPT
01 What Is Uniform Probability Distribution (2:36)
02 Visualize Uniform Distribution With ChatGPT And Python (3:55)
Source Files
10 Bernoulli Probability Distribution with Python and ChatGPT
01 What Is Bernoulli Probability Distribution (2:37)
02 Visualize Bernoulli Distribution With ChatGPT And Python (6:43)
Source Files
Automate Power BI DAX and M with ChatGPT
01 Generate Employee Dataset With ChatGPT (4:50)
02 Copy Data Into Power BI And Generate A Query (10:34)
03 Calculate Employee Tenure With Power Query (10:39)
04 Filter Out Terminated Employees With Power Query (11:31)
Source
02 Generate queries to analyze employee performance
01 Filter By Performance Rating With Power Query (7:12)
02 Categorize Performance With Power Query (5:49)
03 Compare Employee Performance With Location And Education (14:57)
04 Find Top Performing Employees With Power Query (10:26)
05 Calculate Performance For Age Groups (5:35)
Source
03 Generate DAX queries with ChatGPT for Power BI
01 Generate Simple Dax Queries With Chatgpt For Power BI (8:02)
02 Count Rows By Category With Dax (11:27)
Source
04 Build DAX queries to generate tables with ChatGPT
01 Build Dax Queries To Generate Tables With ChatGPT (4:49)
02 Group Employees With Dax Queries (3:30)
Source
05 Build visualizations in Power BI with ChatGPT
01 Build Visualizations In Power BI With ChatGPT (6:58)
Source files
06 Anomaly Detection in Credit Card Transactions with Python
00 Project Preview - Python Data Visualization In Power BI With ChatGPT (3:54)
01 Generate Credit Card Data With ChatGPT (7:07)
02 Detect Anomalies With Z-Score In Python (18:39)
Source
07 Visualize data with Python in Power BI
01 Visualize Transaction Amount For Each Merchant (6:55)
02 Visualize Trend Of Transaction Amounts Over Time (18:25)
03 Show Pie Distribution Of Transaction Amounts By Category (8:48)
04 Show Histogram Distribution Of Transaction Amounts (2:11)
Source
08 Visualize data across categories with ChatGPT
01 Compare Amounts Across Categories With Box Plot (4:23)
02 Show Amount For Each Period By Category (7:14)
03 Visualize Transaction Amounts For Each Merchant (14:00)
04 Build A Word Cloud For Product Names (5:07)
Source
09 Generate machine learning models with ChatGPT
01 What Kinds Of Machine Learning Can I Do On This Data (2:16)
00 Project Preview - Python Machine Learning With ChatGPT (2:03)
02 Build A Linear Regression Model For Credit Card Dataset (8:35)
02B Visualize Linear Regression Training With Gif (10:43)
03 Logistic Regression With Confusion Matrix And Scatter Plot (14:26)
Python Machine Learning Preview (36:01)
Source
10 Build tree machine learning models with ChatGPT
01 Build Decision Tree Model For Credit Card Dataset (8:03)
02 Build A Random Forest Model With Bar Plot (4:17)
Source
11 Build advanced models with ChatGPT and Python
01 Build SVM Scatter Plot With ChatGPT (21:28)
02 Build Gradient Boosting With A Bar Chart (14:22)
Source
Test Your Knowledge - Complete these Exams
Where to find the practice exam
02F How To Utilize Chatgpt Effectively While Being Aware Of Its Limitations
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock