Analytics: Data Studio & Big Queries
Marketing
Hard Skills
This set of questions is suitable for those who will have responsibilities for analyzing and manipulating data within a business organization. The multiple choice questions explore technical skills and practical knowledge of data analysis tools and methodologies. They are suitable for people with short or no prior experience, as long as they have an educational background in growth, as well as people with higher seniority in the area of data analysis and the use of Google products.
Covered topics
- Data Studio: Creating filters; Blending; "CASE" function; "CONTAINS" function; Test strings
- Google Analytics and BigQuery
- External connectors
- BigQuery: Advantages; Native method for linking BigQuery to Google Spreadsheet; Integrated data sources; Querying data from multiple partition tables
- Nested field in SQL Function Keywords in CASE formula
Author bio
Giuseppe Macchia: Over the past 6 years, he has supported and directed numerous startups in the transition from early-stage to exponential growth stage as Head of Growth. Over the years, he has coordinated several growth teams to achieve partner goals in B2B, B2C and E-commerce, in companies such as Miray Bay, Sicily Addict and Notomia. He has also adopted and managed several prioritization frameworks to hypothesize, test and analyze new experiments that would lead to improvement in the considered KPIs. Currently, he is Founder and Head of Growth at Parentube, an innovative startup focused on parenting support.