Chat GPT is dominating the new cycle and raising all sorts of questions around AI ethics and the
future of work we're not going to focus too much on the overall aspects of Chat GPT but
I do want to talk about how it overlaps with the analytics space and specifically I use chat GPT
to get data analyst project recommendations I asked for them a few different ways and you'll
see throughout this video I got quite a few different responses depending on the question
that I ask today I'm rating chat GPT data analyst project recommendations I'll also dive deeper
into one of the recommendations and see if it can give us a really well-rounded project that
we can work on I have chat jpt open here on my window so you can see what I'm working on one
thing that you've probably experienced if you've checked it out at all is you'll need a logon and
also the system can get really busy sometimes so I actually had to wait about a half an hour
to get in here but regardless we're in here so let's test out chat GPT for data analyst
projects and see how we might rate them I've some different ideas of questions I want to ask
and I'm also curious if we get different answers let's start out with uh best data analyst project
so you can see I just typed it in takes a moment and let's see what results we get
so they're saying it depends on the specific industry company and goals thumbs up for that
I think that is a good way to look at it there's not any one single project that fits everyone they
highlight predictive modeling some dashboards a b testing customer segmentation fraud detection one
that addresses a specific need business being and provides valuable insight to the company
I fully agree with this advice um this probably isn't going to feel very helpful to you if you're
looking for specific project recommendations but it is good advice um I think they could
get a little bit more specific here on what they mean these are pretty generic advice
advice points but it's a fine starting point um so here we have the option I can prompt it with
something else and it's going to remember what I've already asked it I want to clear this so we
have a new chat up here let's ask it a different variation so we asked best data analyst project
um let's talk about let's say a number one portfolio project we're a data analyst so this
is sort of the same question we just asked and I'm curious if we get the same answer um if we get a
different answer I notice it's thinking a little longer on this let's see if we get anything back
on it okay so we get a slightly different answer it gives us a common project creating a dashboard
a report that visualizes metrics and insights for a business this could be creating charts
and graphs and while collecting and cleaning data showcases the data analyst ability to work with
large data sets uncover insights that communicate them effectively decent answer um definitely not
as specific as the last one um and notice it's not it's also not giving us a number one or a best
it's just giving us a common project certainly nothing wrong with this I think this is more of
just a general description of what any sort of dashboard project is um but yeah it's it's okay
let's clear that out and let's start a new chat best project for a data analyst career change
see what kind of results we get this one
I'm not expecting ideally anything much different um okay so here we have for career change it
specifies analyzing a data set relevant to the industry you're looking to transition into and
use the insights to create a compelling story or solution it gives us an example for healthcare
analyzing a data set of patient medical records to identify patterns presented as a report or
data visualization it could be used as a portfolio piece to demonstrate your skills so this is again
good advice if you have a specific industry you're looking to transition into then yes definitely
pick some data that's related to that industry if you can get it some of these are going to be
a little more challenging patient medical records probably not going to be so readily available that
you'll probably be able to find some form of that uh I think where this also becomes maybe less than
ideal advice is if you're not looking at a very specific industry um you're not going to want to
go in and do a project for every possible industry that you're going to look at you might also look
at it more as a role-based thing than a um than something that's industry specific so if you're
looking at supply chain or marketing or sales or audit you might pick a project that's specific
more to the role versus the industry they're going to be a little bit more generic so someone that's
working an audit as a data analyst is going to have more in common with other people working in
audit as a data analyst across multiple different Industries versus somebody specifically working in
um in the same role like a healthcare data analyst that is not working in the audit field yes they're
going to be working with some similar data but there's going to be more similarity on those
common roles versus industry we're going to do the same thing we're going to clear this out
and I could leave this history in here I'm just uh clearing it out I don't need to start
a new chat because One automatically starts let's look at top data analyst project again
we're asking very similar questions and for some people they would see them as the same question
um we're getting a variety of answers so they're they're similarities but there are
some differences so here we're getting more of a list of projects um lots of good recommendations
analyzing fraud recommender systems AP testing NLP some of these are going to be a little bit more
advanced than the typical data analysts might work on so NLP for instance is it going to be quite
as common for a data analyst versus maybe a data scientist to work on not to say that there aren't
roles that would involve the there's certainly jobs where that would be involved time series
analysis that's a good one let's see customer segmentation predictive modeling these are all
good they're not very specific I'd say this is um maybe the most generic point that we've gotten to
um in terms of what kind of recommendation that we got
it's important to note the best project depends on the goals and the resources so yep good advice one
thing that I think is interesting to note here is how chat GPT interpreted this so I asked for
top data analyst project it interpreted that as data analyst project ideas pretty similar
it's not really ranking them but that's okay as we talked about there's not one single best
answer here but I think it is something that's interesting I know to see how it translates it
clear that out again let's start a new chat um let's see let's ask number one project for
aspiring data analysts here we have a um a popular project for aspiring data analysts is analysis
using the crisp DM methodology involving business understanding data understanding
data prep modeling evaluation deployment implementing the model in a production environment
and the project can be completed using any data set such as a publicly available data set from a
reputable Source like Kegel it's a great way to learn and apply the skills needed to be a data
analyst so yeah Kegel is a great resource I like that they toss that in here um this is something
that a lot of these are helpful points to include this doesn't really give you an actual project
um it's really explaining the data analysis crisp DM project across industry standard process for
data mining um and this might be something that is a little more involved than you might do so
yes building predictive models is good assessing performance is good deploying in production is
good these are some of these like especially the deployment and production that's not something
you're realistically going to do as an aspiring analyst you're not going to be working in an
environment where you have access to production um so I think this is a good description of what it
interpreted as but what it interpreted as is not the question that I ask um and that's a key thing
to keep keep in mind and where there's plenty of room to grow in all of these different models and
when we talk about the unique place of people in the process that if if we get a good response it's
because it's understood and interpreted in our question correctly sometimes that means asking
different questions if I got this answer back um it might not actually help me if I'm brand new to
the world of data analytics and I'm looking for a project this is this is okay general information
but it's not actually something that I can fully follow through to the end um let's see if I want
to take any more so that's the number one project for aspiring data analysts um maybe let's take
a another example and change our wording a little and let's see best Analytics portfolio project
okay we're back to depends on the industry and the skills some ideas predictive modeling gives
us some specific predictive modeling examples I like that so we have building a model to
predict customer churn data visualization a b testing text binding fraud detection
um it's well documented includes cleared includes a clear problem statement methodology and results
it should demonstrate your individual ability to work with data use tools that
communicate insights effectively so I asked best analytics portfolio project it gave me
analytics portfolio project ideas let's take this a step further and ask it um ask it some
more so we've tested out some different questions on how that changes our results
um so now let's try to get deeper on one of these so give me an example of a b testing
see what it has to say can it elaborate more on that for me so if you want to improve your
website conversion rate you decide to test a new design this is a super common example of
a b testing it's a good one um if you're outside of maybe the marketing space or web design this
maybe isn't going to be um something that you can practically work on as a project example
um so it's still uh still generating some ideas um let's ask it to give me a different example
okay still we're in the marketing space this is really where you would tend to see most a
b testing um taking place it's going to be more common in marketing than in some other areas
um but again this is going to be a bit limited um so we're going to let it generate I'm not going to
cut it off um but then let's see if it can give us a way that we can create this project on our own
um so I'm going to ask it for data set um data set to practice a b testing project okay there's many
available online and it's giving some examples we have an A B testing course by optimizely and UC
Berkeley an online retail data set by UCI machine learning repository cable has an A B testing data
set an experiment data set from Google analytics and you might want to consider creating your own
a B test and collecting data yeah that's a great way to learn I I'm not going to give it very high
marks for this that maybe to me this just seems like the obvious example if you can run the test
yourself yeah of course that's better how many people that are aspiring to be data analysts
are going to have access to an environment where they can set up their own a b testing on a website
um with any measurable volume that they can get that that trust to do so I think that's
uh that's gonna be a little bit harder to find so let's look at these tell me more about number two
see what it gives me transactions from for about a year a little over a year and a half
for a UK based and registered non-store online retail the variables okay this is pretty nice
it's giving me some interesting information here invoice numbers stock codes descriptions
quantities invoice date you know prices customer ID country so they're saying it has about a little
over half a million transactions it can be used to practice a b testing on different strategies
for example you can use the information on invoice date and customer ID to segment
customers and send targeted email campaigns and then use the information on quantity and
unit price to measure the effectiveness of the campaigns Additionally you can use the
information on country to analyze performance of a campaign by region so let me just flip back here
so I'm I'm gonna take issue with this um if we look back at how it's described um it's a
retail data set and we see that described here conceptually yes if this was a real world data
set that we were working with and we were in a real environment we could use that information to
segment customers send them targeted campaigns and then measure the effectiveness of the campaigns
but if I look at what's contained in here there's nothing that actually gives me anything that would
suggest there's a b testing available because there's nothing about different campaigns that
were done that we can evaluate and a b testing is different than customer segmentation so yes
we can segment our customers in different ways we can look at how different customers in different
countries spend money differently we can look at how customers at different periods of time spend
money differently and so these are great examples of customer segmentation on maybe Trend analysis
looking at different information but this is not something that would be good for a b testing so
I'm going to rate this pretty low it sounds like it's probably a good data set um I it's
something I might want to access but in terms of realistically using it for a b testing not so much
I'd rate this pretty low um now chat GPT is very clear that everything is very much in a learning
stage not everything's going to be accurate um but I think this is also an example of just where
we are limitation wise that it's it's difficult some of these nuances are difficult to learn and
will take time not that they can't be learned but it also would be kind of misleading for
someone that that's new to this and checking it out um so lastly let me just ask how can I access
this data okay it's gonna tell me I can download it directly simply go to the page of the data set
and look for the data folder it's available on Kegel so apis through bigquery and data.world
and then once you have the data set you can load it wherever you want for cleaning and Analysis
um can still be used for educational purposes but it's a little outdated
I'm a little disappointed it didn't just give me a link of some sort for any of these but it's easy
enough to go and look at these we've looked at some different things that we can and we can't
do here overall it's a good starting place but it highlights the importance of understanding
what you're talking about when you're looking at it some of this advice is more helpful than others
um and and because of that you just have to be careful of
um of how you take it and use it like I said some of those earlier things I think were helpful
but other things not so much some of the nuances missing when we talk about a b testing this was
not a good example um that's not to say that other ones wouldn't it sounds like maybe number one and
number three could be good examples um but we can't really practice a b testing on different
strategies on just this old data that's not very practical whereas the other data sets it sounds
like they actually have simulated data or actual data on an A B test run to test the effectiveness
of a feature so that you could actually practice it so those could be good options
um just have to take a little bit with a grain of salt what you do with it it's been an interesting
experiment I will definitely come back and try this out on more things there's a lot
of potential with chat GPT and I think there are areas where it can really supplement the
work that a data analyst is doing it may help you troubleshoot your code or write your code but at
the end of the day if you're not asking a good question and understanding the context of the
answer you're getting you might get something that's completely irrelevant I don't see that
ever going away I think that that's something that models will continue to get better at but
ultimately you have to understand why something is happening to understand if the result that
you're getting is relevant and that's where the real value added The Human Experience piece of
analytics comes in if you can understand what the question that you need to ask is
and understand if the answer you're getting is actually in response to that question and not
just a reframed version of it then you'll be really effective at what you're doing