GPT-4o Changed Data Analysis Forever... (Full Guide)

Summary

The video script introduces the new data analysis features of GPT 40, highlighting its user-friendly interface and live editing capabilities. It suggests GPT 40 could rival Google Sheets and Excel, and offers a comprehensive guide on utilizing the tool for data analysis. The script also promotes an AI foundations community for enthusiasts, providing courses on AI tools, image generation, and automation. The speaker demonstrates creating datasets, cleaning data, and generating various charts to visualize trends and relationships within the data.

Takeaways

• 🚀 The release of GPT 40 introduces a new interface for data analysis in Chat GPT, allowing users to edit charts live and interact with data for a cleaner aesthetic.
• 📊 The video provides a comprehensive guide on using the new data analysis features in Chat GPT, suggesting it could potentially replace Google Sheets and Excel in the future.
• 🌐 The presenter highlights the AI Foundations community, which offers courses on artificial intelligence, including data analysis, image generation, and automation.
• 🆓 With GPT 40, data analysis features are accessible to all users, including those on a free account, although there are limitations compared to the plus plan.
• 🔍 For those without existing data sets, the video suggests using kaggle.com for datasets or generating datasets within Chat GPT for practice.
• 🧼 The importance of cleaning and formatting data before analysis is emphasized to reduce errors and improve the quality of analysis in Chat GPT.
• 📈 Viewing data through charts and visualizations is showcased, with examples of bar graphs, line graphs, and pie charts to compare different data factors.
• 📉 The video demonstrates how to create a pie chart to show parts of a whole, such as the top five countries with the most assets from companies based in those countries.
• 📊 The presenter introduces the concept of viewing trends in data with dual-axis line graphs to understand the relationship between two variables, such as revenue and social media posts.
• 🌌 The final method of data visualization discussed is viewing data spread using scatter plots to identify trends and relationships, such as the connection between physical activity and sleep quality.
• 🔑 The script concludes by encouraging viewers to document personal or professional data for analysis, while cautioning about privacy and the importance of authorization when handling sensitive information.

Q & A

What new feature does the release of GPT 40 bring to data analysis in chat GPT?

The release of GPT 40 introduces an amazing new interface for data analysis in chat GPT, allowing users to edit charts live, interact with their data, and enjoy a cleaner aesthetic for viewing and interpreting data.

Why might chat GPT's new data analysis feature have the potential to replace Google Sheets and Excel?

Chat GPT's new data analysis feature could replace Google Sheets and Excel in the future due to its powerful integration with the GPT 40 model and the pleasant experience it offers for data analysis, despite not being quite there yet.

What is the AI Foundations Community and how does it relate to the video's content?

The AI Foundations Community is a recently released private community for over a hundred members who are passionate about artificial intelligence. It is mentioned in the video as a place for learning and discussing AI tools, including in-depth data analysis techniques beyond what is covered in the video.

How can someone practice data analysis with chat GPT if they don't have their own datasets?

Individuals can practice data analysis with chat GPT by using datasets available on platforms like kaggle.com or by requesting chat GPT to create mock datasets on various topics for practice.

What is the first step recommended for ensuring a smooth data analysis process in chat GPT?

The first recommended step is to clean and format the data, which helps mitigate errors when generating charts and ensures the data is organized for effective analysis.

How can users generate a bar graph to compare companies based on revenue using chat GPT?

Users can generate a bar graph by providing a simple prompt to chat GPT, such as 'create me a bar graph for the top five companies based on revenue,' which will then process the request and display the chart.

What is the benefit of expanding the table in the new data analysis interface of chat GPT?

Expanding the table allows for a more interactive view of the data, making it easier to see details and download the table in a CSV file format for later use.

How does the video script describe the changes in the data analysis feature with the GPT 40 update?

The script describes the changes as providing a cleaner table view of data, the ability to expand tables for better interaction, and an overall more aesthetically pleasing and user-friendly experience for data analysis.

What is the significance of the dual-axis line graph in analyzing trends in the data?

The dual-axis line graph is significant as it allows for the comparison of two factors, potentially revealing correlations or insights into why trends are occurring, such as the relationship between social media posts and revenue.

How can a scatter plot be used to understand the relationship between two variables in the data?

A scatter plot can be used to visualize the relationship between two variables, such as physical activity level and quality of sleep, to identify trends, clusters, or potential 'sweet spots' that indicate optimal conditions.

What precautions should be taken when uploading personal or sensitive data to chat GPT for analysis?

Users should be cautious about uploading sensitive information to the internet, ensuring they have proper authorization if necessary, and being aware of the privacy implications of sharing personal data.

Outlines

00:00

🚀 Introduction to GPT 40's Data Analysis Features

The script introduces the new data analysis capabilities in GPT 40, emphasizing the live editing of charts, interactive data handling, and enhanced aesthetics for viewing and interpreting data. The speaker presents a comprehensive guide to utilizing these features and suggests that GPT 40 could potentially replace traditional tools like Google Sheets and Excel. They also promote a private AI foundations community, highlighting its benefits, including courses on AI tools and a supportive environment for discussing artificial intelligence.

05:01

📊 Accessing and Preparing Data for Analysis

This paragraph explains how to access data for analysis in GPT 40, noting that free account users now have data analysis feature access with some limitations. The speaker suggests using kaggle.com for data sets or creating custom data sets with chat GPT. They demonstrate how to upload and clean/format data, emphasizing the importance of data preparation to reduce errors and improve analysis quality.

10:03

📈 Analyzing Data with Charts and Visualizations

The speaker discusses various ways to visualize data in GPT 40, starting with comparing data through bar graphs, line graphs, and pie charts. They provide examples of how to create these charts, such as generating a bar graph for the top five companies based on revenue. The paragraph also covers the new interface's interactivity, customization options, and the ability to download charts for further use.

15:05

🌐 Viewing Data by Identifying Trends and Correlations

This section focuses on identifying trends within data using line graphs and introducing the concept of dual-axis line graphs to show correlations between two variables, such as social media posts and revenue. The speaker illustrates the process of creating a dual-axis line graph to understand the relationship between posting activity and financial performance, although they mention a current limitation with interactive chart support.

20:05

📊 Viewing Data Spread with Scatter Plots

The final paragraph explores the use of scatter plots to view the spread of data and understand relationships between variables, such as physical activity level and sleep quality. The speaker shows how to create a scatter plot using a sample data set and discusses the potential insights that can be gained from such visualizations, including identifying trends and optimal clusters for desired outcomes.

Keywords

💡Data Analysis

Data analysis is the process of inspecting, cleaning, transforming, and modeling data with the goal of discovering useful information, drawing conclusions, and supporting decision-making. In the context of the video, data analysis is the core theme, demonstrating how to use the new interface in chat GPT to interact with data, create visualizations, and interpret results. The script mentions various ways to view data, such as through charts and graphs, to gain insights.

💡GPT 40

GPT 40 refers to a hypothetical advanced model or version of a language processing AI, presumably succeeding GPT-3, which is known for its capabilities in understanding and generating human-like text. The video discusses the new features and capabilities of this model, particularly focusing on its data analysis tools and how they enhance user interaction with data.

💡Chat GPT

Chat GPT is portrayed as an interface or platform in the video that allows users to perform data analysis tasks. It is implied to have a conversational user interface where users can request data analysis, generate charts, and interact with data in a more natural and intuitive way. The script highlights the user experience improvements and new functionalities in the latest update.

💡CSV File

A CSV file, short for Comma-Separated Values, is a common file format used to store tabular data, such as a spreadsheet or database. In the video, CSV files are mentioned as a method to download and utilize data sets within chat GPT, emphasizing the ease of data manipulation and analysis.

💡Kaggle

Kaggle is an online community for data scientists and machine learning practitioners that offers various resources, including datasets for practice and competitions. The script suggests visiting kaggle.com to find and download data sets for practicing data analysis with chat GPT.

💡Data Visualization

Data visualization involves the creation and study of visual representations of data to understand it more easily. The video covers different types of charts and graphs, such as bar graphs, pie charts, and line graphs, as tools for data visualization within chat GPT, showing how they can reveal trends and patterns in the data.

💡AI Foundations Community

The AI Foundations Community is mentioned as a resource for individuals interested in artificial intelligence. It is described as a community with over a hundred members, offering courses on AI, including data analysis, image generation, and automation, and fostering discussions about AI tools. The video presenter highly recommends joining this community for those interested in delving deeper into AI.

💡Large Language Model (LLM)

A large language model, or LLM, refers to AI models that are trained on vast amounts of data and can generate human-like text based on the input they receive. In the video, the presenter uses chat GPT, which incorporates an LLM, to demonstrate how it can be utilized for data analysis, including creating data sets and generating insights.

💡Data Cleaning

Data cleaning, also referred to as data formatting in the script, is the process of detecting and correcting or removing errors and inconsistencies in a data set to improve its quality. The video emphasizes the importance of this step before generating charts and performing analysis in chat GPT to ensure accuracy and meaningful results.

💡Scatter Plot

A scatter plot is a type of mathematical diagram using Cartesian coordinates to display values for two variables for a set of data. In the video, the presenter uses a scatter plot to analyze the relationship between physical activity levels and sleep quality, illustrating how chat GPT can help identify trends and correlations within data.

Highlights

Introduction of a new data analysis interface in chat GPT with GPT 40, allowing live editing of charts and enhanced data interaction.

The potential of GPT 40 to replace traditional data analysis tools like Google Sheets and Excel in the future.

The release of a private AI foundations community with over a 100 members, offering courses on artificial intelligence and live discussions.

Access to data analysis features in GPT 40 is now available to all users, including those on free accounts.

The ability to create and practice with data sets directly within chat GPT, without needing external sources like Google Sheets or Excel.

Kaggle.com is recommended as a resource for obtaining various data sets for practice.

Importance of cleaning and formatting data before analysis to reduce errors and improve chart quality.

New table view feature in GPT 40 provides a cleaner and more interactive way to view and analyze data.

Demonstration of creating bar graphs and line graphs to compare data factors and reveal insights.

The introduction of pie charts in chat GPT for showing parts of a whole, with the ability to customize colors and download charts.

The use of dual axis line graphs to show trends and correlations between two different data factors.

The upcoming feature of interactive charts in GPT 40, currently in beta, which will enhance data visualization.

Scatter plots as a method to view data spread and understand relationships between variables.

The practical application of data analysis in personal life tracking, such as sleep and physical activity.

The video concludes with an encouragement to document personal and professional data for better insights and decision-making.

Invitation to join the AI foundations community for further learning and engagement with AI tools and techniques.

Transcripts

with the release of GPT 40 came an

amazing new interface for data analysis

in chat GPT you can now edit charts live

interact with your data and you overall

get a much cleaner aesthetic when it

comes to viewing data and interpreting

it within chat GPT in this video I'm

going to give you a full data analysis

guide in chat GPT so that you know how

to use it best with this new GPT 40

model and honestly guys this could

replace Google Sheets into Excel in the

future I don't think it's quite there

yet but that's where it's moving the

power of GPT 40 in this new model mixed

with these new data analysis

Integrations in the new interface is

just such a pleasant experience that's

why I'm going to show you how to use it

in this video how to work around some of

those new updates and just show you the

power of it now if you love this video

then I know that you're going to love

our private AI foundations community

that is just released we have over a 100

members people are loving this we just

had a live call that lasted 2 hours

today we couldn't stop talking about art

icial intelligence we get this beautiful

Community okay people are in here typing

all the time we're talking about our

favorite go-to AI tools it's just the

best community around hands down you

will love it when you get here everyone

is so friendly and on top of that what

you get is a bunch of courses on

artificial intelligence you have a full

large language model Mastery where I go

over data analysis in depth and I show

you ways to view many different charts

more than I'm going to show you in this

video and you also get an AI image

generation course an AI automation

course where we're going over different

automations and make.com overall this

community is the best place and it will

be your final stop for artificial

intelligence if that interests you I

will leave that in the link in the

description or the topend comment below

I highly recommend it everyone who has

joined has not regretted it so far I

guarantee this will be the greatest

investment you've ever made cuz you're

investing in the Future tools of your

life all right now let's get into the

data analysis update with GPT 40 now for

starters in this update everyone

actually has access to the data analysis

feature now now there are more limits

when you're on a free account but you

don't need the plus plan in order to get

all of the benefits and to try this out

and to have fun with it you can now do

it on the free plan which is amazing

with this GPT 40 update now you might be

wondering first off okay why do I need

to use the data analysis update how do I

use it I don't even know where to get

data sets in order to practice this well

if you're not a Google Sheets person or

you're not an Excel person you don't

have rows and rows of data you need

analyzed but you do want to practice

then there's a couple of things that you

can do one thing is you can go to

kaggle.com on kaggle.com they have a ton

of different data sets that you can get

if you go to the data sets tab you can

download and practice on a bunch of

different topics we have education

topics in here we have computer science

topics in here and these are just data

sets that you can download and practice

on or what you can also do is create

data sets with chat GPT you can just say

create me a data set that is 100 rows or

however many any rows you want about

social media posting and engagement this

can be really any topic but I'm just

showing you how you can actually

generate data sets that you can use in

order to practice then you can just put

so I can practice my data analysis you

can send that off and it might ask you a

few questions you might have to work it

out but what you can really do is get a

CSV file from chat GPT a mock fake data

set that you can utilize in order to

practice your data analysis in chat GPT

Now by no means am I a data expert but

I'm just some a normal person who has

figured out how to use this in order to

generate some amazing things so as you

can see in a couple of seconds it gave

me a bunch of post IDs it gave me post

dates that are arbitrary post type post

content length likees shares comments

Impressions engagement rate and this is

all just data that I can now hit this

little download button right here or I

can expand the table this is one of the

parts of the update that is just amazing

you now have the abil to expand the

table which I'm going to get into all

the updates in a second but what you can

do is you can download this table I'm

going to hit download table and just

like that what it's done is it's

downloaded as a CSV file that I can then

upload and use later or what I can do is

I can not expand that and I can just ask

to analyze this data as it posted up in

here but that's a way to get data sets

if you're struggling to find them you

can create them in seconds using GPT 40

next I want to give you some

foundational tips for data analysis in a

large language model such as chat GPT

that have helped me along the way so

that I don't get as many errors now

first upload a data set you can do that

as I just showed you or you can use

existing data that you have from Google

Sheets Excel I even exported my YouTube

data and got some very interesting

Trends and found some very interesting

things about my data with chat GPT but

anyway you can upload any data set I'm

going to hit this little link icon in

the bottom left hand corner of my prompt

bar I'm going to hit upload from

computer yes you have the ability to

connect this to Google Drive now as well

and now I just have a data sets folder

with a bunch of different data sets and

what you want to do first is you just

want to upload a data set so I'm going

to upload top 50 companies going to hit

open and before you start trying to

generate cool charts doing cool analysis

or whatever what you need to do first is

make sure your data is cleaned and

formatted somebody corrected me on this

in the comments they said um I shouldn't

use the word clean but rather use the

word format if I'm talking about data

analysis but I still like to use the

word clean it's what I found the llm

picks up on the easiest in order to do

what I want so I'm going to say clean

and format this data if needed okay

that's all I have to say before I

generate any charts just have chat gbt

clean and format your data I'm going to

send off that prompt and as you can see

now this is one of those new features we

have this beautiful table view of our

data rather than having it be uploaded

and it says this data has been cleaned

and formatted here are the key changes

removed leading SLT triling whites space

from the column names converted the

revenue new profits assets and market

value columns to numeric values for

better analysis so those two things are

going to help mitigate the errors when

we're generating charts and it's going

to help the charts be much cleaner than

they were before so step number one is

always clean and format your data to

ensure that there are no empty columns

errors numeric things that need to be

changed columns that need to be

reorganized in order to have it be

analyzed chat gbt is the thing analyzing

your data so have it formatt it in the

way that's best for its analysis now

that we have all that boring stuff out

of the way we figured out how to make

data sets we figured out how to clean

and format them let's get into the fun

stuff let's look at the ways that we can

view our data with charts and

visualizations and chat GPT now again in

my AI foundations community that I've

built with productive dude I go over

this a lot more in depth on the five

ways to view data and each one of those

with different charts you can generate

as I said a lot more in depth but in

this video we're going to be taking a

general look a broad overv view how you

can view your data and by the end of it

you're going to have so many ideas

flowing through your head you're not

going to know what to do with it so way

number one that you can view your data

is by comparing it and these charts are

simple think of two factors for example

revenue and Country or social media

posts and likes these are going to be

your bar charts your horizontal bar

charts your line graphs you're very

basic things but things that are so

powerful and the visualizations just

look beautiful so I can say create me a

bar graph for the top five companies

based on Revenue so I'm really just

comparing two factors here companies and

revenue so there's nothing too special

but what you're going to see is a

beautiful representation now that the

data has been cleaned of what this might

look like comparing the top five

companies based on revenue and this

should be able to give us some

interesting insights as you can see this

new interface is so so amazing for data

analysis we have different columns that

we can shoes and they're labeled

beautifully we can expand this chart now

so we can see a very interactive view of

this data we now have a nice download

button that I can hit download and if I

Collapse this chart and see this I can

open up this download and I now have a

beautiful picture that I can use and

it's pretty much ready to go now another

thing that you can do with these charts

is once you expand it hitting this

little arrows icons right in the middle

or right in the top right hand corner of

that chart once you expand that

what you can do is you have the ability

to hit this little settings icon and

then you have different colors within

the data set okay so you can start

changing the colors of each of these

lines for some reason it's not showing

uh each company as its own individual

thing within the legend but a lot of the

time it does and you'll have the ability

to change the individual line now for a

bar graph I do believe it's common

practice to keep all the colors of These

Bars the same but for things like pie

charts you can have the ability to

actually change each color of the P

which I will get into a little later but

this is the first way to view your data

is by comparing it and you can do things

like line graphs as well you can come to

some very cool conclusions now let me

just show you what the old chart looks

like this is what the old charts used to

look like okay ugly I am talking ugly

but this is what it looks like now just

very very Sleek very smooth it's

interactive and I absolutely love it

let's look at the next way that we can

view our data on chat gbt and that is

going to be showing parts of a ho and

the one chart that I have for this that

I think represents it best is the pie

chart now I go over this a lot more in

depth in the course in the community

below but I want to just showcase how to

create a pie chart within shat GPT so

we're going to hop in we're going to

head over to my data sets Google sheet

where I have a ton of different data

sets and we're going to keep using this

top 200 companies that I have been using

throughout this entire video what I want

to compare is countries to assets and I

want to see which are the top five

countries that have the most assets

under management based on the companies

so which companies have the most assets

and those companies are going to be

added up to their respective country

making a top five country list I hope

that makes sense pretty confusing but

chat gbt is going to dumb it down for us

and explain it to us step by step so

once again I'm going to start from the

top this time I want to upload that data

set for my computer I can just upload

the top 50 I don't have to upload all

200 I can head open and once again I'm

going to clean and format this data

since I did not download my other data

set that was cleaned previously I'm just

going to clean and format this one once

again just so you can get that ingrained

in your head that that's what you need

to do as you can see we get this

beautiful chart it's going to clean and

format this data to make the revenue

exactly how it needs to be and then we

are going to generate that pie chart in

order to show parts of a hole as you can

see it said it clean the data but when I

look at the data it has a lot of numbers

in here but how do I know that this is

representing billion I know all of them

do represent billion since this is the

top 50 companies in the world but how do

we make sure that we understand that

well that's what we can ask chat GPT

real quick you can ask it questions

about your data very natural process it

will make some mistakes there's going to

be some tweaks but you can just ask it

questions along the way which is what

makes it so powerful How will I know the

numbers represent

billions okay and I can send that off

and now it's added to the column A B

which represents billions so now that I

know that each of these is representing

billions in that value now I can go

ahead with my data analysis and what I

can do is generate a pie chart using a

very simple prompt so I'm just talking

like a human I say create a pie chart

showcasing the top five countries with

the most combined assets from their

companies in that country I'm just going

to send that off and take a look at this

this is what I was talking about with

this beautiful interactive pie chart

what you can do is you can hit this

expand chart button so that you don't

have to squint and go close to your

computer screen and you can just see it

now you have the ability to hover over

it and check out the top five countries

from this data set based on assets under

management so it looks like China is in

the lead based on this list us is second

Japan is third United Kingdom is fourth

and France is Fifth and notice how it's

giving the percentages as well this is

beautiful I could have put an other

category in here with all of the other

countries as well but this is amazing it

breaks it down in percentages and as I

was showing you earlier we now have the

ability to hit this little settings icon

next to the download button and we can

actually change the colors of these pie

charts and not only does it give us a

pallet to select from but it gives us a

custom hex code selector that we can

throw in the hex code of any color that

we want and get it changed so I could

make it

0000000000 Z have it be black I could

make it FF ffff have it be white um it's

just amazing what we can do with this

now and again you can hit this little

download button in order to download the

chart let's move on to the next way that

we can view our data and that is viewing

our data by seeing Trends throughout our

data that we may have missed now this

may seem simple by just looking at

Trends but I want to show you a chart

that I'm absolutely in love with because

it shows you why the trend is happening

this is going to be a dual AIS line

graph and I have a very simple data set

that I want to show you and just to show

you the power of the Dual AIS line graph

and how this is going to work so what we

have here is another data set we have 12

months January through December and we

have a company that maybe just tracks

revenue and social media post so we

could make a basic line graph of this

company and the revenue that it's

generating just to see how it's trending

over time I'm going to go back here hit

create a new chat in the upper leftand

corner

then I'm going to hit the link icon in

the bottom left hand corner of the

prompt bar and I'm going to upload that

sub based platform data set and first

I'm going to ask to clean and format

this data even though there's not much

to clean and format um I'm just going to

ask it to clean and format the data just

so I can maintain good practices and now

as you can see it's in here okay so this

is looking beautiful we can expand this

just like that quite amazing it says the

data set has been cleaned in format what

it looks like it did was changed the

revenue to an actual Revenue currency

property rather than just having it be a

number and it's ensured consistent

capitalization for column names verified

and corrected any potential

inconsistencies so beautiful data is

cleaned and ready to go we can generate

a basic Trend like a trend line so I can

say create a line graph

showcasing revenue for this specific

year and and we can get a general idea

of where the trend is going but maybe

this is not enough data in order to see

why it's happening we have a bunch of es

and flows we can see a general uptrend

in the data which is very nice for any

company right we can see that it's

making higher highs and lower lows so we

have a general uptrend going on here but

why the dip right why do we go from

14,000 one month to sub 9,000 another

month what we can do here in order to

view a trend and why it's trending the

way it is is by adding another Factor to

the Chart so let's make this a dual

access line graph and if you remember

right within our data right here we have

another column for social media posts

this could be for a company maybe

they're posting on social media and that

and they're just tracking how many times

they post across all their socials let's

add that to this chart and see if it has

an effect on the revenue so I could say

make this a dual AIS line graph and add

in social media post

post on the second y AIS so nothing

crazy here I'm talking like a third

grader I know my axes I have the x axis

and the y axis y to the sky x to the

left or the right and now I can just add

this in right we have the data up here

it's clean and formatted we have this

chart let's just add in another

denominator so now I'm adding in the

social media post to overlay on top of

this and that's why I called it a dual

AIS line graph because we're going to be

overlaying the two of them seeing if

they have any correlation to one another

so as you can see it says interactive

charts of this type is not yet supported

so it is still working through this it

is beta but now you can kind of see

what's happening in this data and this

is much better than it was before

actually I like how it does it dotted so

you kind of can differentiate between

the two but now as you can see the green

line is representing the social media

posts and it seems like these two are

moving in harmony which may indicate

that when you post more on social media

for this company in specific you

actually make more money but this would

be another way to view your data is that

dual AIS line graph can't wait for the

interactive charts to be supported for

this one sometimes they are supported

sometimes they're not so I think it is a

little buggy but you still get to expand

it nicely and download it much easier

than you could before now let's take a

look at the final way that you can view

your data that I'm going to be showing

in this video and that would be by

viewing a data spread within chat GPT

this is amazing I love doing this one

I'm going to be utilizing a scatter plot

for this but you can also use violin

plots box plots whatever you want I go

in-depth on box plots which are actually

kind of complex to understand within

this course uh the small section here

within the large language model Mastery

and I also in here have another section

called understanding relationships

between things where I use bubble charts

and go in-depth on the third dimension

of data analysis but with that being

said let's get into actually creating a

scatter plot and understanding what that

might be good for for analyzing data in

chat GPT super excited to get into this

one so let's do it first I'm going to

open up Google Sheets and then what I'm

going to do is I'm going to go to my

sleep data lifestyle and professions so

what we have here are some categories we

have person ID gender age occupation

sleep duration quality of sleep physical

activity level and it keeps on going on

with the stress blood pressure heart

rate but what we have here is physical

activity level and quality of sleep what

I want to do is I want to put these two

up against one another in a scatter plot

and see if we can see any Trends between

physical activity level and quality of

sleep when you exercise more do you get

better sleep these are things that you

can start tracking with your personal

life I have this ring right here I'm not

sure if you can see it but this ring

tracks my sleep it tracks my activity

level it tracks my stress my Readiness

and these are things that I can start

like importing into a Google sheet and

actually tracking for my personal life

you can also do this with a Fitbit I'm

pretty sure it's quite amazing you can

connect it to my fitness pal whatever

you want to do

but Chad GPT is going to help you see

what the trends in your life are you

sleeping good are you having enough

physical activity level on Saturdays for

instance if you have enough data uh when

do you work the best when do you get the

most most Focus time in that those are

the things that I'm kind of focusing on

when I'm doing my data analysis and chat

gbt but also things like YouTube stats

and just general information that's fun

messing around with but let's get into

it I'm going to upload this data set

sleep data and lifestyle professions by

hitting that link icon and then finding

it within my data sets folder so I'm

going to upload that hit open and like I

said always clean and format this data

if needed okay always send up that

prompt in order for chat gbt to just to

get a feel for it so it knows what it's

working with and also can help you clean

it since it seems easy to clean to

ensure proper formatting let's perform

the following tasks and it's kind of

just running you through its checklist

which I've always loved when it uses its

data analysis feature it always is

keeping you up to date with what it's

doing and as I said before you can get a

downloadable copy you can download the

clean table so that you can just upload

it to your Google Sheets again maybe

that's all you want to do is just clean

your data we hit that little download

button at the top of the table and

upload it to Google Sheets or Excel

whatever you use it's pretty easy but

the data has been cleaned and formatted

now we can start generating a scatter

plot based on our two factors right here

quality of sleep and physical activity

level so I can say create a scatter plot

showcasing quality of sleep with

physical activity levels and so after I

hit send I mean there's over 374 rows of

data within this data set in specific

yeah okay so this is beautiful right it

has quality of sleep physical activity

level it even plots it out for you it

kind of looks like a Star Wars game or

Galaga or something but this is very

interesting to see and you can kind of

start seeing is there any relationship

between it it doesn't really look like

there's any big clusters but what we can

see is a small uptrend in the data so

the more physical activity level you

have generally the higher quality of

sleep you have from what I can see right

now I'm going to download this I'm going

to open it up and as you can see well as

you might not be able to see because it

is kind of hard to view but what you can

notice from this data is to me it looks

like the people that are down here at

this section aren't getting as much

sleep but as their physical activity

level goes up it seems like there's a

general uptrend in this data that's what

chat gbt is helping you see you can also

find small clusters within the scatter

plot in order to see okay maybe there's

a sweet spot between getting this

physical activity level and this quality

of sleep right if there was a cluster

like right here then this might be a

good spot to aim for because these are

pretty Peak Achievers right they're

super active but they're also sleeping

like kings and queens so this is your

goal to get here I'm pretty sure but

yeah anyway this looks like a children's

drawing now so I'm going to hop off my

screen and back to my face just

congratulating you on finishing this

video because this is going to put you

ahead of 90% of the people using chat

GPT you start documenting your life your

work hours your physical activity level

your sleep hours you start taking in

your stats your personal stats or your

stats from work be careful uploading

information that's private though you

know you're going to have to get

authorization from a higher up or if

you're the higher up maybe you can make

that decision yourself but you are

uploading information to the Internet so

always be careful when you're doing that

especially if it's sensitive but with

that being said congratulations on

finishing this this was a good video for

you to see kind of the changes that GPT

40 had to make with the data analysis

feature and I am loving it it's just so

much more of an experience when using it

now again if you want to learn AI you

want to loving Comm Community then I

highly recommend joining the AI

foundations Community okay this is a

group that is going to be something

special and I realized that even more

after we just got off our live call now

we have calls scheduled once a week that

we just check in with the group and

we're also adding specialized calls for

AI image generation prompting with llms

and so much more this community is going

to be the foundation in your final stop

for artificial intelligence so I highly

recommend you join it's a very good

learning environment all right with that

being said that's all I have for this

video please subscribe and like and

comment below if you did enjoy this

video hit the Bell icon so you never

miss an upcoming upload and I will see

you in the next video much love