Google Data Analyst Interview Questions

Review this list of 8 Google data analyst interview questions and answers verified by hiring managers and candidates.
  • Google logoAsked at Google 
    Video answer for 'Tell me about a time you made a mistake.'
    +87

    "Let me tell you about a time where a website I managed suddenly showed slow performance and the mistake on our side was it was unnoticed until a user reported the issue to management. As a PM for that project, I took full responsibility of the situation and worked with the engineering team to quickly resolve it. This mistake taught me the importance of focusing and monitoring non functional requirements as well in addition to new feature development /adoption where I was mostly spending my time"

    Sreenisha S. - "Let me tell you about a time where a website I managed suddenly showed slow performance and the mistake on our side was it was unnoticed until a user reported the issue to management. As a PM for that project, I took full responsibility of the situation and worked with the engineering team to quickly resolve it. This mistake taught me the importance of focusing and monitoring non functional requirements as well in addition to new feature development /adoption where I was mostly spending my time"See full answer

    Data Analyst
    Behavioral
    +6 more
  • Google logoAsked at Google 
    +53

    "I follow a variation of the RICE framework when prioritizing how I ship product features. I start by looking at: Reach: Because the customer segmentation across our product portfolio is so similar, I tend to hold a lot of weight on product features that will maximize our customer reach with a minimal LOE. Impact: After establishing which customer segments will benefit from the product feature, I determine the urgency and estimated impact on each customer segment based on customer i"

    Ashley C. - "I follow a variation of the RICE framework when prioritizing how I ship product features. I start by looking at: Reach: Because the customer segmentation across our product portfolio is so similar, I tend to hold a lot of weight on product features that will maximize our customer reach with a minimal LOE. Impact: After establishing which customer segments will benefit from the product feature, I determine the urgency and estimated impact on each customer segment based on customer i"See full answer

    Data Analyst
    Behavioral
    +8 more
  • Google logoAsked at Google 

    "Let's take Google Fitbit as the product and analyze how to identify its competitors. 1. Identify Direct Competitors (Similar Wearables & Smartwatches) Fitbit is a fitness tracker and smartwatch brand, so direct competitors include: Apple Watch Series (Apple) Samsung Galaxy Watch (Samsung) Garmin Wearables (Garmin) Amazfit & Zepp (Huami) Xiaomi Mi Band (Xiaomi) These brands offer smartwatches or fitness bands with similar health-tracking features. 2. Use Launch Events for Insi"

    Rajdeep J. - "Let's take Google Fitbit as the product and analyze how to identify its competitors. 1. Identify Direct Competitors (Similar Wearables & Smartwatches) Fitbit is a fitness tracker and smartwatch brand, so direct competitors include: Apple Watch Series (Apple) Samsung Galaxy Watch (Samsung) Garmin Wearables (Garmin) Amazfit & Zepp (Huami) Xiaomi Mi Band (Xiaomi) These brands offer smartwatches or fitness bands with similar health-tracking features. 2. Use Launch Events for Insi"See full answer

    Data Analyst
    Data Analysis
    +2 more
  • Google logoAsked at Google 
    +6

    "Interesting question. Let's take a step back and focus on the WHAT and WHY of Google Flights. The narrative for Google Flights as a product or platform imo is: As a platform, I wish to make flight information available, so that users can make knowledgable decisions based on their travel needs. So essentially, it helps users by providing information, so that they can make optimized decisions. In order to determine if Google should introduce ads, we should consider the impact on both val"

    Niranjan M. - "Interesting question. Let's take a step back and focus on the WHAT and WHY of Google Flights. The narrative for Google Flights as a product or platform imo is: As a platform, I wish to make flight information available, so that users can make knowledgable decisions based on their travel needs. So essentially, it helps users by providing information, so that they can make optimized decisions. In order to determine if Google should introduce ads, we should consider the impact on both val"See full answer

    Data Analyst
    Analytical
  • Google logoAsked at Google 
    Video answer for 'Merge Intervals'
    +34

    "const mergeIntervals = (intervals) => { const compare = (a, b) => { if(a[0] b[0]) return 1 else if(a[0] === b[0]) { return a[1] - b[1] } } let current = [] const result = [] const sorted = intervals.sort(compare) for(let i = 0; i = b[0]) current[1] = b[1] els"

    Kofi N. - "const mergeIntervals = (intervals) => { const compare = (a, b) => { if(a[0] b[0]) return 1 else if(a[0] === b[0]) { return a[1] - b[1] } } let current = [] const result = [] const sorted = intervals.sort(compare) for(let i = 0; i = b[0]) current[1] = b[1] els"See full answer

    Data Analyst
    Data Structures & Algorithms
    +6 more
  • 🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.

  • Google logoAsked at Google 
    +4

    "Clarifying questions Do we mean the Google Play store or Apple App store or some other app store? : Google Play Store Do we mean to calculate the number of apps as in 2024? : yes Are we looking at any particular data slices like in a particular country/ for a particular geography etc.? : No, I want the overall global number And we mean to calculate total number of apps that are registered on Play Store and can be searched and accessed by a user, am i right? : Yes Okay, here's how"

    Kartikeya N. - "Clarifying questions Do we mean the Google Play store or Apple App store or some other app store? : Google Play Store Do we mean to calculate the number of apps as in 2024? : yes Are we looking at any particular data slices like in a particular country/ for a particular geography etc.? : No, I want the overall global number And we mean to calculate total number of apps that are registered on Play Store and can be searched and accessed by a user, am i right? : Yes Okay, here's how"See full answer

    Data Analyst
    Estimation
    +3 more
  • Google logoAsked at Google 
    +2

    "WITH RECURSIVE fibonacci_series AS ( SELECT 1 AS n, 0 AS fib1, 1 AS fib2 UNION ALL SELECT n + 1 AS n, fib2 AS fib1, fib1 + fib2 AS fib2 FROM fibonacci_series WHERE n < 20 -- Limit the series to 20 numbers ) SELECT n, fib1 AS fib FROM fibonacci_series ORDER BY n; `"

    Yashasvi V. - "WITH RECURSIVE fibonacci_series AS ( SELECT 1 AS n, 0 AS fib1, 1 AS fib2 UNION ALL SELECT n + 1 AS n, fib2 AS fib1, fib1 + fib2 AS fib2 FROM fibonacci_series WHERE n < 20 -- Limit the series to 20 numbers ) SELECT n, fib1 AS fib FROM fibonacci_series ORDER BY n; `"See full answer

    Data Analyst
    Coding
    +2 more
  • Google logoAsked at Google 

    "I'm a bit confused - The $40B hrs is the total time spent commuting to work, correct? Whereas the question asks "hours lost ... in traffic". Is the answer not correct then?"

    Lucy Y. - "I'm a bit confused - The $40B hrs is the total time spent commuting to work, correct? Whereas the question asks "hours lost ... in traffic". Is the answer not correct then?"See full answer

    Data Analyst
    Estimation
    +3 more
Showing 1-8 of 8