I wish you health :)
There are several projects for which it is necessary to build reports/dashboards on GA4 BigQuery raw data.
Let's start with one project. The queries are already prepared, it is necessary to understand how to edit them and validate the results.
Required knowledge and proficiency in the following tools: SQL, BigQuery, GA4, Looker Studio.
Reports/visualizations that need to be built:
1. Open funnel by events (page_view, view_item, add_to_cart, begin_checkout, purchase) broken down by channel;
2. Closed funnel by events or pages (click_sign_up, registration, purchase) broken down by channel;
3. User path by events and pages (like page path GA4 report) - last event purchase;
4. ROAS broken down by geo (GA4 and Google Ads data are already in BigQuery).