b类产品访谈提纲_谷歌产品分析师访谈

最新推荐文章于 2024-07-23 13:09:39 发布

weixin_26729763

最新推荐文章于 2024-07-23 13:09:39 发布

阅读量783

点赞数

文章标签： java python

原文链接：https://towardsdatascience.com/the-google-product-analyst-interview-bfce2c94d1f6

版权

b类产品访谈提纲

介绍(Introduction)

In 2008, Google launched its cloud solution “Google Cloud Platform” (GCP), a suite of cloud computing services that offers excellent Infrastructure-as-a-Service (IaaS) solutions to help businesses scale up.

Google在2008年推出了其云解决方案“ Google Cloud Platform”(GCP)，这是一套云计算服务，可提供出色的基础设施即服务(IaaS)解决方案来帮助企业扩大规模。

Today, GCP is used in almost every industry, including manufacturing, retail, finance, healthcare and life sciences, gaming, education, telecommunication, and government. Google Cloud Platform also offers Big Data (Big Query large-scale data warehouse, Dataflow, Cloud Datalab, Cloud Datalab, Data Studio, etc) and AI/machine learning solutions for “ML model development, search, natural language, speech, translation, vision and video intelligence”.

如今，GCP几乎用于每个行业，包括制造，零售，金融，医疗保健和生命科学，游戏，教育，电信和政府。 Google Cloud Platform还提供了大数据(Big Query大型数据仓库，Dataflow，Cloud Datalab，Cloud Datalab，Data Studio等)和AI /机器学习解决方案，用于“ ML模型开发，搜索，自然语言，语音，翻译，视觉和视频智能”。

Over the years, Google has spent a fortune developing analytics and cloud-based architecture tools to help businesses grow. Data and data analytics is integral to the company’s core vision, and as such, Google offers work on a scale like no other to incoming data scientists, data analysts, data engineers, and business analysts.

多年来，Google投入了大量资金来开发分析和基于云的架构工具，以帮助企业发展。数据和数据分析是公司核心愿景不可或缺的组成部分，因此，Google为新生数据科学家，数据分析师，数据工程师和业务分析师提供了规模无与伦比的工作。

Google的产品分析师角色 (The Product Analyst Role at Google)

Generally, a product analyst is one who utilizes market research, data analytics, and business intelligence skills to successfully launch a new product to market. The role is specialized at Google. Product analysts at Google leverage data analytics to find different insights to drive business impacts. They provide “quantitative analysis, market expertise and a strategic perspective to both Google’s internal clients and partners throughout the organization”.

通常，产品分析师是利用市场研究，数据分析和商业智能技能成功将新产品推向市场的分析师。该角色专门针对Google。 Google的产品分析师利用数据分析来发现不同的见解，以推动业务影响。他们为Google的内部客户和整个组织的合作伙伴提供“定量分析，市场专业知识和战略前景”。

Product analysts at Google generally oversee the complete journey of a product, including its design stage, before launch, and after launch. There are so many questions surrounding a product journey (from design to market), and product analysts help answer real questions like “What are we trying to make happen?”, “How can we prove it quantitatively?”, and “Are we confident in that?”.

Google的产品分析师通常会监督产品的整个开发过程，包括设计阶段，发布之前和发布之后。产品旅程(从设计到市场)的问题太多了，产品分析师可以帮助回答诸如“我们要实现什么？”，“我们如何定量证明它”和“我们有信心”之类的实际问题。在那里面？”。

Product analysts also work cross-functionally with internal teams, guiding them on product direction, experimentation, and analysis, and with developers, helping them achieve success in their projects.

产品分析师还与内部团队进行跨职能合作，指导他们进行产品方向，实验和分析，并与开发人员一起帮助他们在项目中取得成功。

Want to learn more about the product analyst role? Check out “The Product Analyst Interview” on Interview Query!

想更多地了解产品分析师的角色？在面试查询中查看“产品分析师面试” ！

必备技能 (Required Skills)

Like every Google position, the product analyst role requires enterprise-level analytics skills and at least three years of industry experience in quantitative analysis.

像每个Google职位一样，产品分析师角色需要具备企业级分析技能以及至少三年的定量分析行业经验。

Other relevant skills include:

其他相关技能包括：

Bachelor’s/Master’s in Statistics, Computer Science, Mathematics, Engineering, Data Science, or other quantitative fields.
统计，计算机科学，数学，工程，数据科学或其他定量领域的学士/硕士学位。
Extensive experience with statistical packages including R, SAS, Stata, MATLAB, etc.
具有统计软件包的丰富经验，包括R，SAS，Stata，MATLAB等。
Deep experience writing SQL queries, extracting large data, and designing ETL flows.
具有编写SQL查询，提取大数据和设计ETL流的丰富经验。
Experience in developing models, methods/approaches (including Time series forecasting, econometrics, causal Inference, and classification methods), and the ability to translate analysis results into business recommendations.
具有开发模型，方法/方法(包括时间序列预测，计量经济学，因果推断和分类方法)的经验，以及将分析结果转换为业务建议的能力。
Three years experience working with engineers and product managers, especially around providing product-centric insights.
与工程师和产品经理合作的三年经验，尤其是在提供以产品为中心的见解方面。

Google产品分析师团队 (Product Analyst Teams at Google)

While product analyst roles sometimes overlap with those of business analysts, product analysts rely heavily on quantitative analysis, rather than focusing on the business impact of product design. They work within teams and cross-functionally with others to achieve business goals.

尽管产品分析师的角色有时与业务分析师的角色重叠，但是产品分析师在很大程度上依赖于定量分析，而不是专注于产品设计的业务影响。他们在团队内部工作，并与其他人进行跨职能合作以实现业务目标。

As a large company with many teams working on product development and design around a lot of different products and features, Google offers a unique scale that is very global, making even your tiniest efforts significantly impactful. Depending on the assigned team, specific roles may differ. Below are some of the product analyst teams at Google and their specific roles:

作为一家大型公司，拥有许多团队致力于许多不同产品和功能的产品开发和设计，因此Google提供了独一无二的规模，这种规模非常全球化，即使您的最小努力也能产生重大影响。根据分配的团队，特定角色可能有所不同。以下是Google的一些产品分析师团队及其具体角色：

Data Science Team: Product analysts on this team conduct analysis for business recommendations, develop and automate reports, and iteratively build and prototype dashboards to provide insights at scale. They also present findings to multi-level stakeholders and collaborate cross-functionally with stakeholders to formulate and complete full cycle analyses.
数据科学团队：该团队的产品分析师对业务建议进行分析，开发和自动化报告，并迭代构建和原型化仪表板以提供大规模的见解。他们还向多层次的利益相关者展示调查结果，并与利益相关者进行跨职能协作，以制定和完成完整的周期分析。
Developer Console: Roles include partnering with Engineering and Product Management teams in Developer Console to understand their business needs through end-to-end analysis, including gathering and analyzing data and ongoing scaled deliverables, and delivering effective presentations and recommendations to multiple levels of leadership. The position also involves developing and automating reports, and prototyping dashboards to provide actionable insights at scale.
开发者控制台：这些角色包括与开发者控制台中的工程和产品管理团队合作，以通过端到端分析来了解他们的业务需求，包括收集和分析数据以及不断扩展的可交付成果，以及向多层领导层提供有效的演示和建议。该职位还涉及开发和自动化报告，以及对仪表板进行原型设计以大规模提供可行的见解。
Youtube Data Science Team: Roles include guiding the team on product direction through rigorous experimentation and analysis, and working closely with the engineering team to achieve a successful product development journey.
Youtube数据科学团队：职责包括通过严格的实验和分析指导团队确定产品方向，并与工程团队紧密合作以实现成功的产品开发旅程。

Interested in product but looking for something more technical? Then we reccomend going through “The Product Data Science Interview Guide”!

对产品感兴趣，但正在寻找更技术性的东西？ 然后，我们建议您阅读“产品数据科学面试指南” ！

面试过程 (The Interview Process)

The product analyst interview process follows Google’s standard hiring process. The interview process starts with a recruiter reaching out to you via email to gauge your interest. The next step is completing a ten-question survey about your past projects and role-related skills. After this, an initial interview with a product analyst will be scheduled via phone call or Google Hangouts. The final stage is the onsite interview, consisting of four interview rounds with product analysts from the same team.

产品分析师的采访过程遵循Google的标准招聘过程。面试过程始于招聘人员通过电子邮件与您联系以评估您的兴趣。下一步是完成有关您过去的项目和与角色相关的技能的十个问题的调查。之后，将通过电话或Google Hangouts安排对产品分析师的初步采访。最后阶段是现场采访，包括来自同一团队的产品分析师的四轮采访。

初始画面 (Initial Screen)

The Google product analyst initial screen is exploratory. It is a 45 minute phone or Google Hangouts interview with a Product Analyst (PA); questions can range from past project experience type questions to light technical type questions.

Google产品分析师初始屏幕处于探索性。这是45分钟的电话或Google Hangouts对产品分析师(PA)的采访；问题范围从过去的项目经验类型问题到轻型技术类型问题。

Sample Question: How would you explain a 95% confidence interval to a non-technical person?

样本问题：您如何向非技术人员解释95％的置信区间？

现场采访 (Onsite Interview)

This is the last stage of the Google product analyst interview step. This interview consists of four back-to-back interview rounds with product analysts (within the same team or outside the teams) and a lunch break in between.

这是Google产品分析师采访步骤的最后阶段。这次面试包括与产品分析师(在同一团队内或在团队外)进行的四次背对背访谈，中间是午餐时间。

Standard Google product analyst onsite interview questions can comprise modeling, metric definition, SQL, and standard statistics problems. Questions can also range from hypothetical to case-based and real-life scenarios. There are also behavioral, product sense, and culture-fit questions on these interviews. You can expect questions with a format like, “How would you..”, and “Tell me about a time you..”

Google产品分析师的标准现场采访问题可能包括建模，指标定义，SQL和标准统计问题。问题也可能从假设性到基于案例的情况以及现实生活中不等。这些访谈中还涉及行为，产品感和文化适应性问题。您可以使用“您会怎样..”和“告诉我您的时间..”这样的格式来提问。

Note: It is important that you talk through your solution in the interview, and it also helps to use past projects you’ve worked on to explain your answers and choices.

注意：在面试中讨论解决方案很重要，这也有助于使用您以前从事过的项目来解释您的答案和选择。

Read this article about “Product Analyst Interview Questions and Answers” on Interview Query to prepare for your interview!

阅读有关“面试查询”的“产品分析师面试问答”的文章，为面试做准备！

注意事项 (Notes and Tips)

Google is a product-based tech company, and product analysts at Google are expected to leverage data and advanced analytics methods to drive product growth. The Google product analyst interview aims to assess candidates’ ability to perform job duties to drive the success of Google’s products.

Google是一家基于产品的科技公司，预计Google的产品分析师将利用数据和高级分析方法来推动产品增长。 Google产品分析师访谈旨在评估应聘者履行工作职责以推动Google产品成功的能力。

Google uses standardized questions that are tailored specifically to roles in all its interview processes. Solving Google product analyst SQL and Python questions on Interview Query will go a long way to help you succeed in your interview.

Google使用专门针对其所有面试过程中的角色量身定制的标准化问题。 解决Google产品分析师关于Interview QuerySQL和Python问题将大大帮助您成功完成面试。

Remember, the Google product analyst interview will also test a combination of statistical and data analytics concepts, as well as product-sense and business analytics concepts. Brush up your knowledge of basic statistics and probability, predictive modelling, metrics definitions, and SQL (including ranks, joins, etc,).

请记住，Google产品分析师访谈还将测试统计和数据分析概念以及产品感知和业务分析概念的组合。掌握基础统计和概率，预测建模，指标定义和SQL(包括等级，联接等)的知识。

It is also worthy of note that Google is looking at four main standards for all its interview processes, regardless of the roles and department you are applying for. The first is “ general cognitive ability”, the second is “ role-related knowledge”, the third is “ leadership skills”, and the last is your “ Googlyness “.

还要注意的是，无论您申请的职位和部门是什么，Google都在为其所有面试流程寻找四个主要标准。第一个是“一般的认知能力”，第二个是“与角色相关的知识”，第三个是“领导能力”，最后一个是您的“ Googlyness ”。

Google employs rigorous post-interview hiring processes that include team matching and putting together offers. This is done by a team of highly-qualified and non-biased Googlers, “the Hiring Committee”, who are experts in the roles/jobs and have never met any of the applicants before. After the verdict of the hiring committee, they send out a recommendation to senior management for final review before an offer is extended.

Google采用了严格的面试后招聘流程，其中包括团队匹配和报价整合。这是由一支高素质且无偏见的Google员工团队(“招聘委员会”)完成的，他们是职位/职位的专家，以前从未见过任何申请人。在聘用委员会作出决定之后，他们向高级管理人员发送了建议，以期对他们进行最终审核，然后再延长报价。

Google产品分析师面试问题 (Google Product Analyst Interview Questions)

Given a hypothetical situation, how would you create a model to predict this metric?
在假设的情况下，您将如何创建模型来预测该指标？
How would you handle class imbalance, etc.? How would you use this model in a business context?
您将如何处理班级失衡等问题？您将如何在业务环境中使用此模型？
How do you use rank() to get id(s) with the highest value?
您如何使用rank()获得具有最高价值的ID？
Is sorting one column or sorting concurrently pieces of that column faster?
是对一列进行排序还是对该列的同时进行排序更快？
How would you test a new product?
您将如何测试新产品？
How would you explain AdSense to a grandmother?
您如何向祖母解释AdSense？

Visit Interview Query for more Google Product Analyst questions!

谢谢阅读 (Thanks for Reading)

If you’re interested in sharpening your data science skills, check out Interview Query!
如果您有兴趣提高自己的数据科学技能，请查看Interview Query ！
Check out my Youtube channel for more interviewing guides, and tips & tricks for solving problems.
查看我的YouTube频道，以获取更多面试指南以及解决问题的提示和技巧。
Find more Google interview guides like the Google Data Analyst Interview and the Google Business Analyst Interview on the Interview Query blog.
查找更多Google采访指南，例如Google Data Analyst采访 以及Interview Query博客上的Google Business Analyst Interview 。