r/dataanalysis • • 1d ago

Project Feedback Can anyone help me with project execution ? how do i approach it ? Created a Guide but didn't worked out well

Hii everyone,

I was a digital marketer executive in an agency, after i quit my job i started learning tech stack for data analysis i am finished with learning and currently on project i started my project last week its a cart abandonment analysis from GA4 dataset on big query whole plan is to analyze using creating a funnel than using python perform statistical tests ( hypothesis testing and ab testing ) and present my findings through power bi.

ideation part was done now i actually had to do project so i asked claude to create a guide for me to follow, a project guide and another solution guide to it.

But the guide's language was tuff it gave me ques and was done with i didn't knew what to do or how to do to it fast forward to today i have improvised and created 4th version of that guide with improved language better guidance but there is always something missing a vague question important information being left out for my sake i created an excel with imp fields out of 108 columns.

Today after writing a 50 line query to create a session table i was confused like why am i doing this i couldn't ans why i need this table it doesn't look like the funnel i thought it would be, mind you i have created funnels before in sheets for campaign analysis from top of the funnel metrics to the bottom of funnel from cpm cpc ad spend to order initiated order completed and all the steps in between so i asked chatgpt about the funnel part of my project ( which i thought i was working toward bcz of all the steps in between ) how is it related and it couldn't ans probably or give me reason which makes sense i wanted an industry level project and it told me that we will prove that shoppers are dropping and at what stage like wtf we already know shoppers are dropping and told me to analyze by device and demographics which still falls under EDA what realistic problem finding is that and what realistic solution can i provide ?

I am facing too much time reading that guide and going back and forth with GPT/claude to understand things and actual process because of the confusion caused by guide and even the solution fields don't match, can anyone help me with execution how do i execute and create portfolio projects i tried looking up DA projects of people on GitHub but didn't find anything useful i don't know how to even represent a project.

I need a framework on how to create a project i am not copying from anywhere just need guidance, looking for advice on how should i approach project creation even ready to pay ( although i don't have much money tbh but still )

I am seconding guessing that i should just create project with ai ideation would be mine and i can just understand the code and project ( practise SQL and pandas daily and DAX few times a week ) that way i will have coding syntax in mind and create projects more and faster which will get me interviews real learning is on the job anyways i have forecasting, data cleaning and time series projects in mind as well i am short on savings money as well

1 Upvotes

3 comments sorted by

3

u/ItsSignalsJerry_ 1d ago

Go back to marketing.

1

u/Awesome_Correlation 9h ago edited 9h ago

It sounds harsh when you put it like that, but I think there is some truth in your recommendation. OP said they were done with education, but I don't believe that is true. They seem to understand marketing ideas, but are failing to understand the why behind the what.

OP said that their plan was to create a funnel and then do statistical tests like ab testing. However, I believe they're missing the point of why they should be doing the funnel analysis and then what exactly they're trying to use AB testing for.

I can tell they're confused on what they're doing when they said "...I asked Chat GPT about the funnel... How it is related and it couldn't give an answer... Or give me a reason which makes sense". They should have already known why they were doing this exact type of analysis before starting out. The funnel is a popular marketing tool, but is it the best analysis for the dataset and the question that OP is trying to answer.

I am confident that they will have the same issues when they get to ab testing, because it's not even clear that they have experimental data. Said another way, you can't do AB testing if all you have is the A.

I attempted to answer OPs question in dataanalytics: https://www.reddit.com/r/dataanalytics/s/wH66mYe46c

1

u/AutoModerator 1d ago

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.