The Complete ChatGPT

Course
Module 1: Introduction

Lesson 1: What is ChatGPT really?

 What is a Model?

Model = Neural Network Architecture

Essentially a set of mathematical algorithms

Learns to recognize patterns

DATA MASTERY ACADEMY

 Training a Model?

Process of teaching a computer

program, like ChatGPT, to recognize
patterns in data

The model is given vast amounts of

data

The goal: minimize error

DATA MASTERY ACADEMY

 What is Generative AI?

Ability of Capable of
machines to generating
generate new content such as
data text.

DATA MASTERY ACADEMY

 What is a Prompt?

A prompt is a piece of text that is used as input to the model in order to generate a
response.

DATA MASTERY ACADEMY

 Why use ChatGPT?

Perform tedious tasks Combine AI's automated

capabilities with human input

DATA MASTERY ACADEMY

The Complete ChatGPT
Course
Module 1: Introduction

Lesson 2: ChatGPT Limitations

 ChatGPT Limitations

Knowledge Cutoff Hallucination

May not have the latest information Incorrect responses

Bias Legal and Ethical Concerns

Based on the data it was trained on Inappropriate and harmful responses

Context Tracking
If the conversation changes frequently,
chatgpt may be confused and may not be able
to keep track of the different topics of the
conversation

DATA MASTERY ACADEMY

The Complete ChatGPT
Course
Module 2: Using ChatGPT

Lesson 1: Prompt Engineering

 Prompt Engineering

Prompt Engineering: The process of crafting

effective prompts

The way you phrase your prompts can have a

significant impact on the quality and relevance
of the responses you receive.

DATA MASTERY ACADEMY

 Prompt Conditioning

Context: background information

Task: a specific question

Context: "In a world where superpowers are

commonplace, there are few heroes who can
truly make a difference."

Task: "Write a short story about a superhero

who discovers a new power and uses it to save
the world from a catastrophic threat."
DATA MASTERY ACADEMY
How to craft effective prompts?

Be specific

Use clear language

Provide relevant context

Test and iterate

DATA MASTERY ACADEMY

The Complete ChatGPT
Course
Module 2: Using ChatGPT

Lesson 2: Prompting for Various Use Cases

 Writing Emails

"Write an email to John Smith about the

upcoming project deadline and ask for an
update on the progress."

"Write a follow-up email to customers who have

abandoned their shopping carts on our website.
Encourage them to complete their purchase,
and include a personalized offer or discount to
sweeten the deal."

DATA MASTERY ACADEMY

2
 Writing Social Media Posts

"Write a 1-minute script for a social media video

promoting our new online course, SQL for Data
Analysis - Guided Project Course, launch, with
an upbeat and informative tone."

"Write a Linkedin post about the new online

course you finished. The course name is SQL
Guided Project Course."

DATA MASTERY ACADEMY

3
 Writing Blog Posts

"Write an SEO-friendly blog post about the

benefits of meditation for stress relief, with a
conversational tone and a minimum of 500
words."

DATA MASTERY ACADEMY

4
 Translation

"Translate this product description from English

to Turkish, maintaining a formal and
professional tone: If you're looking to gain
practical experience with SQL and learn how to
analyze real-world datasets, then this course is
for you!"

"Write synonyms for the word articulate"

DATA MASTERY ACADEMY

5
 Resume Writing and Improving

"Write a short, one paragraph, professional summary for a

data analyst with 2 years of experience working at a startup
company, doing various data analytics tasks. Include key
skills and qualifications."

"Write a resume for this person, including the short summary

you wrote"

"Put the skills section after the summary section and update
the resume. These skills are SQL, Tableau, Power BI,
advanced statistics, python, excel, and communication
skills."

DATA MASTERY ACADEMY

 Cover Letter Writing

"Write a cover letter for an entry level data

scientist position at a tech startup. Highlight
the candidate's portfolio with python and sql
data analytics and machine learning projects,
such as sales analysis and fraud detection."

DATA MASTERY ACADEMY

7
 Linkedin Profile Update

"Write a summary section for a newly graduated

aspiring data scientist’s LinkedIn profile. Focus
on the candidate's course work and portfolio
related to data science, data analysis, and
machine learning."

DATA MASTERY ACADEMY

 Interview Preparation

"Provide a list of common interview questions

for a senior data analyst position. Include tips
on how to answer each question effectively."

"Provide sql technical coding question

examples. Include the answers."

DATA MASTERY ACADEMY

9
 Career Advice

"Provide advice for a recent college graduate

looking to enter the finance industry as a
financial analyst. Include tips on networking
and gaining relevant experience."

DATA MASTERY ACADEMY

10
 Text to Table / Table to Text

"Convert the following text into a table: John,

Doe, 35, Software Engineer. Include column
headings for first name, last name, Age, and
Occupation."

"Fill this table with 10 more random employees."

"Explain this table in plain English"

DATA MASTERY ACADEMY

11
 Dataset Generation

"Generate a sample dummy dataset of 1000

records with the following fields: Name, Age,
Occupation, Salary. Include only records with
salaries above $50,000."

DATA MASTERY ACADEMY

12
 Code Generation

"Write a Python function to calculate the area of a

triangle. The function should take the base and
height as arguments and return the area."

"You have the customers table with a unique

customer_ID column and a purchases table with a
customer_ID column and a purchase_date column.
Write a SQL query to find the customers who have
made at least one purchase in every quarter of the
year 2022."

DATA MASTERY ACADEMY

13
 Code Explanation

"Explain this code

def my_func(n) :
sm = 0
for i in range(1, n+1) :
sm = sm + (i * i)
return sm
n=4
print(my_func(n))"

DATA MASTERY ACADEMY

14
 Language Conversion
"Convert this code to python
num = [Link](readline(prompt="Enter a number: "))
flag = 0

if(num > 1) {
flag = 1
for(i in 2:(num-1)) {
if ((num %% i) == 0) {
flag = 0
break
}
}
}
if(num == 2) flag = 1
if(flag == 1) {
print(paste(num,"is a prime number"))
} else {print(paste(num,"is not a prime number"))}"

DATA MASTERY ACADEMY

15
 Excel Help
Formula help: If you're struggling with a particular formula or function in Excel,
you can ask ChatGPT for help. For example, you can ask, "How do I use the
VLOOKUP function in Excel?"

Troubleshooting: If you're encountering an error or issue with Excel, you can

describe the problem to ChatGPT and ask for suggestions on how to fix it. For
example, you can say "I'm getting a #REF error in Excel, how do I fix it?"

Data analysis: If you need help analyzing data in Excel, ChatGPT can provide
suggestions on which functions or tools to use. For example, you can ask "How
do I create a pivot table in Excel?" or "What is the best way to visualize data in
Excel?"

Tips and tricks: ChatGPT can also provide tips and tricks to help you work more
efficiently in Excel. For example, you can ask "What are some keyboard shortcuts
in Excel?" or "How do I format cells in Excel?"

DATA MASTERY ACADEMY

1
The Complete ChatGPT
Course
Advanced Prompting
 ACT AS ...

"Act As..." prompts are prompts that ask you to

imagine or pretend to be a particular person, character,
or entity and then respond to a situation or question
from that perspective.

DATA MASTERY ACADEMY

2
 Social Media Influencer

“Act as a social media influencer. You will create

content for Linkedin, Facebook, Youtube, and TikTok to
increase brand awareness and product promotions. My
first request is: Write a Linkedin post about the
upcoming Introduction to Python course to tease and
create excitement.”

DATA MASTERY ACADEMY

3
 Career Coach

“Act as a career coach, and imagine you are meeting

with a recent college graduate who is struggling to find
a job in their field of study. In this scenario, the
graduate has a degree in business administration and
has been applying for entry-level data analyst positions
at various companies for several months but has not
had any luck. They are feeling frustrated and uncertain
about their career path. Your first task is: Provide
actionable steps to take moving forward.”

DATA MASTERY ACADEMY

4
 Programming Assistant

“I want you to act as a programming assistant for a

beginner who is learning Python. They are trying to
write a program that asks the user for their name and
age and then prints a message with that information.
Please provide guidance and suggestions as they work
through the problem. Remember to keep your
responses simple and clear, and avoid using technical
jargon as much as possible.”

DATA MASTERY ACADEMY

5
 Translator

“I want you to act as an English translator. You will first

detect the language and then translate it to English with
elegant English words and sentences. I want you to
reply with the name of the detected language first and
then the English translation. Do not write explanations.
My first sentence is “Bilgisayar muhendisliginden yeni
mezun oldum. Programlama dillerinden hangisine
agirlik vermeliyim?”

DATA MASTERY ACADEMY

 Interviewer

“I want you to act as an interviewer for data analyst and

data scientist positions at a tech company. You will
conduct virtual interviews with candidates who have
submitted their resumes and cover letters, and evaluate
their technical skills, problem-solving abilities, and
communication skills. Prepare a list of interview
questions that are tailored to each position.”

DATA MASTERY ACADEMY

7
 Marketing Expert

“I want you to act as a marketing expert for [YOUR

NICHE], who is trying to promote products. They have
provided you with information about their product,
target audience, and budget and have asked for your
guidance on how to create effective marketing
campaigns. Please provide a comprehensive marketing
plan that includes strategies for social media, email
marketing, paid advertising, content marketing, and
other relevant channels. Your first task is: Develop an
email marketing campaign for [YOUR NICHE]”

DATA MASTERY ACADEMY

 Math Teacher

“I want you to act as a math teacher. It is your job to

explain the given questions in easy-to-understand
terms. Include step-by-step explanations of the concept
and examples whenever possible; also, suggest online
resources for further study. Your first task is "Explain p-
value."

DATA MASTERY ACADEMY

9
 SQL Terminal for Practicing

“I want you to act as a SQL terminal with a database.

The tables in this database are “employees,” “salaries,”
and “departments.” First, you will ask me a question.
Then, I will answer your question by queries in mysql,
and you will show me the result. If the query is wrong,
you will explain why it is wrong and ask me to provide
the corrected query. If the query is wrong again, you will
explain why it is wrong and provide the correct answer.
Your first task is: Start asking a data analysis question
based on the tables provided”

DATA MASTERY ACADEMY

10