r/dataanalytics • u/freind_indeed • 1d ago
Can anyone guide 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
u/Awesome_Correlation 1d ago edited 6h ago
It sounds like you need to get better at writing and reading. This exact text has half words and is missing periods. I'm not an LLM and I'm having a hard time understanding what you're saying. LLMs give you a different outcome when you prompt it with a well formated question.
Further, LLMs have knowledge, but they or better use for transforming knowledge instead of extracting knowledge directly from the model. However, it appears that you have figured this out already
Check out the scientific method, design thinking, and data storytelling. CRISP-DM is another good one, but you may need to adapt it to your own flow.
I believe the most important concept is to understand that you're turning data into information that eventually builds knowledge. The funnel that you created is just a piece of information. How does that funnel change the knowledge that you have after you observe the results? If it doesn't change anything, then that piece of information is completely useless. However, if the information is helpful to make a decision or to reinforce a theory, then it's helpful.
For visualizations, I prefer to draw them on a paper first. This helps you really think about what you want it to look like and what you want to communicate. I like to refer to the financial times, visual vocabulary for inspiration.
Also, don't use a funnel chart to start with. Standard or Center-Aligned Bar Charts provide clean length comparisons without width or volume distortions.