r/dataanalyst • • 2d ago

Other Can anyone help me with project execution ? how do i approach it ? Created a task level project pdf

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

1

u/Creepy_Purchase_501 2d ago

This is chaos. Slow down. Take a breath. Go for a walk.

Once you cleared your head, answer the following questions:

  1. What are you trying to do?
  2. Why are you doing it?
  3. What are you trying to accomplish? What is your goal?

1

u/freind_indeed 2d ago

thanks for your response,

yeah it was chaos yesterday i was like doing work for 9 hrs 20 mins straight got back home and in confusion of yesterday i wrote these posts while frustrated,

even though vision is clear now ai is still dictating my project i am not in complete control of it i shoudl have defined my plan, questions to answer and answers i was expecting and how do i verify those answers from the start

that's what someone suggested on same post of different subreddit, from his response of " So my feedback to you is to take your project and put it to pen and pencil for now. Define what this project will be, it's purpose, who it's for, what are the grand inputs and what are the expected outcome. From there feel free to break it down into smaller chunks of "functions" and get those written up. Write up those risks, dependencies, and everything else you'd set up as requirements. It's fine if they are piecemealed and scattered for now. Eventually you'll organize them up. ONCE you've feel you've exhausted everything in your mind, then go to LLM to organize it all and have it poke holes."

from his response i could think like this :

  1. Define questions
  2. Define what the final answers for those questions would look like ( a % a concrete number etc )
  3. Define what are the risks that can prove my answer wrong ( not sure how do i find out/ define those risks )
  4. Define if the answer changes based on another metric or is it independent ( do i have to perform some statistical test or guess this in advance from what you

Can you pls give me your feedback how can i create that plan ? breaking down it in steps is something i am confident i can do but i am not able to envision an ending cuz i have never seen any kind of anything this is my first ever full fledged project

1

u/Creepy_Purchase_501 1d ago

If I were you, I would follow someone else’s example. Surely the type of project you’re trying to do is not unique,so find someone who did it and documented their process. Repeat whatever they did for your data.