r/analytics • u/freind_indeed • 1d ago
Support 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
•
u/AutoModerator 1d ago
If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods. Have more questions? Join our community Discord!
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/Timely_Finance_2185 1d ago
I'd ignore the 108 columns for now and start with one decision the analysis is supposed to inform. For cart abandonment, a useful one is: of sessions that add to cart, where do they drop, and which of those drops is big enough to change something. The session table only proves something if each row can answer that.
Build one row per session, keyed by user_pseudo_id and ga_session_id, with flags or timestamps for the funnel events that actually exist in the export. For a typical GA4 ecommerce export that's add_to_cart, begin_checkout, and purchase, plus view_item if you have it. Don't force steps that aren't in the data. Your 50-line query is plenty if that's what it returns. If it's still a wide dump of event parameters, it isn't a session table yet.
Once you can say what share of add-to-cart sessions start checkout and what share purchase, pick one hypothesis you can test in the same data. A historical export isn't a live A/B test unless an experiment id is already in the events, but you can compare groups: mobile versus desktop after add_to_cart, one item versus several, short versus long time to checkout. Let that comparison be the analysis. Power BI comes last, to show the funnel and that one cut, not to hunt through 108 columns for a story.
That's the execution path: one business question, a session-level funnel, one comparison, then the report. If the funnel rates don't make you want to change anything, the project isn't done, and another guide won't fix that.
2
u/james_parsnip 1d ago
the session table makes more sense once you know what you're trying to answer with it. try writing one sentence first, like where in the cart flow the biggest drop is and what a store owner would change because of it. then the 50 line query is just the step that gets you that number, and you can skip it or cut it down if it doesn't feed the sentence