van访谈_谷歌业务分析师访谈

van访谈

介绍 (Introduction)

Google, an American tech giant with internet-related products and services ranging from operating systems (Android, Chrome OS) to mobile and desktop applications (Google Chrome, Google Adwords, etc.) and from hardware (Google Nexus line) to services like Google Cloud, Youtube TV, etc.

Google，美国科技巨头，提供与互联网相关的产品和服务，从操作系统(Android，Chrome OS)到移动和桌面应用程序(Google Chrome，Google Adwords等)，从硬件(Google Nexus系列)到Google之类的服务云端，YouTube电视等

Founded in 1998, the company is headquartered in Mountain View, California. Google’s corporate mission is to “organize the world’s information and make it universally accessible and useful” and this is only possible through data.

该公司成立于1998年，总部位于加利福尼亚州山景城。 Google的企业使命是“整理世界各地的信息，使其普遍可访问和有用”，而这只有通过数据才能实现。

Data is important to Google, which is why they own and operate over 20 data centers around the world. With over 3.55 billion search queries processed daily and 5 billion Youtube videos watched per day, Google is one of the most “data-rich companies in the world” and the best spot for data analysts, data scientists, and business analysts to build their careers.

数据对Google很重要，这就是为什么它们拥有并运营全球20多个数据中心的原因。 Google每天处理超过35.5亿次搜索查询，每天观看50亿次Youtube视频，是全球“数据最丰富的公司”之一，也是数据分析师，数据科学家和业务分析师发展事业的最佳场所。

Google的业务分析师角色 (The Business Analyst Role at Google)

Pixabay Pixabay

Business analysts at Google analyze data to develop different insights to drive business decisions for products, answering questions such as “How do we make the product better?” and “What do users like about the product?”.

Google的业务分析师会分析数据以开发不同的见解，以推动产品的业务决策 ，并回答诸如“我们如何使产品变得更好？”之类的问题。 和“用户喜欢该产品什么？”。

Google has a strong data culture and business analysts use this data to inform and drive business decisions. Roles may differ slightly based on which team an analyst is assigned to, but the general role at Google ranges from identifying solutions and new business insights through extensive data analysis and predictive modelling to requirements management and communication of insights to relevant stakeholders.

Google具有强大的数据文化，业务分析师使用这些数据来指导和推动业务决策。 根据分配给分析师的团队的不同，角色可能会略有不同，但是Google的一般角色范围从确定解决方案和新业务见解到广泛的数据分析和预测模型，再到需求管理以及将见解传达给相关利益相关者。

Interested in the business analyst role at a similar company like Amazon? Check out “The Amazon Business Analyst Interview” on Interview Query!

对类似亚马逊这样的公司的业务分析师职位感兴趣吗？ 在面试查询中查看“ Amazon Business Analyst面试”！

必备技能 (Required Skills)

The role of a business analyst at Google requires field specialization and extensive industry experience. As such, Google only employs the most qualified applicants with a minimum of 4 years (7+ for senior roles) of industry experience in quantitative analysis, consulting, or any relevant data-driven business roles.

Google的业务分析师的角色需要专业领域和丰富的行业经验。 因此，Google仅聘用在定量分析，咨询或任何相关的数据驱动型业务角色方面具有至少4年(至少7年以上的高级职位)行业经验的最合格的申请人。

Other basic qualifications include:

其他基本资格包括：

• Bachelor’s (MBA, Master’s degree or PhD preferred) in Mathematics, Statistics, Computer Science, Physics, Engineering, Operations Research, Economics, Engineering, or equivalent practical experience.
  数学，统计学，计算机科学，物理学，工程学，运筹学，经济学，工程学学士学位(MBA，硕士学位或博士学位优先)或同等的实践经验。
• Experience with relational databases including SQL, MySQL, MapReduce queries, database definition, and schema design, and business intelligence tools.
  具有关系数据库方面的经验，包括SQL，MySQL，MapReduce查询，数据库定义和架构设计以及商业智能工具。
• Basic experience with scripting languages (e.g., PHP, Python, R, Perl, Java, etc.) and statistical software such as R, SAS, Matlab, Numpy/Pandas, etc.
  具有脚本语言(例如PHP，Python，R，Perl，Java等)和统计软件(例如R，SAS，Matlab，Numpy / Pandas等)的基本经验。
• Experience extracting, sampling, and visualizing large data sets, along with writing and maintaining Extract, Transform, Load (ETLs) from a variety of structured and unstructured sources.
  体验提取，采样和可视化大数据集，以及编写和维护从各种结构化和非结构化源中的提取，转换，加载(ETL)。
• Experience working cross-functionally with engineering and business teams.
  与工程和业务团队进行跨职能合作的经验。

Google业务分析师团队 (Business Analyst Teams at Google)

“Google is and will always be an engineering company” and as such, data drives business decision-making at Google. Data science is at the very core of Google’s culture, employed in all facets of the company.

“ Google一直并将永远是工程公司”，因此， 数据驱动着Google的业务决策 。 数据科学是Google文化的核心，在公司的各个方面都得到采用。

To emphasize just how important data science is to Google, they created a “People Analytics Department” to assist the company’s HR decision-making process, including deciding if managers or team members make a difference in their teams’ performance based on analysis of performance review data. The gap between data and sound business decision-making is bridged by business analysts, who dig deep into Google’s data to provide sound insights.

为了强调数据科学对Google的重要性，他们创建了“人员分析部”以协助公司的人力资源决策过程，包括根据绩效评估分析确定经理或团队成员是否对团队绩效产生影响数据。 数据与合理的业务决策之间的鸿沟由业务分析师弥合，他们深入研究Google的数据以提供合理的见解。

Based on the assigned team, the roles of a business analyst at Google may include:

根据分配的团队，Google的业务分析师的角色可能包括：

• Google Cloud: This team helps Google customers, such as schools, government agencies, companies, etc., transform and evolve their businesses through the use of Google’s global data centre and software assets to make them more productive, mobile, and collaborative. Business analysts in this team partner with senior sales leadership to provide actionable insights, sharpen decision making, and drive a deep understanding of Google’s fast-growing business with a data-driven approach.

  Google Cloud：该团队通过使用Google的全球数据中心和软件资产来帮助Google客户(例如学校，政府机构，公司等)转变和发展其业务，以提高他们的生产力，移动性和协作性。 该团队中的业务分析人员与高级销售领导者合作，以数据驱动的方式提供切实可行的见解，完善决策并推动对Google快速增长的业务的深入了解。

• YouTube Trust & Safety: This team is dedicated to making YouTube a safe place for users, viewers, and content creators around the world to create and express themselves. Business analysts in this role leverage advanced data analytics and predictive models to identify key influencers for empowering operational efficiency and collaborate cross-functionally with various interest teams to implement scalable solutions that further optimize operational metrics.

  YouTube的信任与安全：该团队致力于使YouTube成为世界各地的用户，观看者和内容创建者进行创作和表达自我的安全场所。 担任此职务的业务分析师利用高级数据分析和预测模型来确定关键的影响因素，以提高运营效率，并与各种利益团队进行跨职能协作，以实施可扩展的解决方案，从而进一步优化运营指标。

• YouTube Insights, Impact & Tools: This team supports the YouTube business and operations team, as well as other internal partners, with data infrastructure, tools, and analytical support for rigorous data insights, building solutions and services that transform how YouTube business teams work. Analysts also partner with business stakeholders to understand their business areas and build business requirements, connecting with data infrastructure to build pipelines, datasets, and workflows required to satisfy these requirements.

  YouTube见解，影响和工具：该团队为YouTube业务和运营团队以及其他内部合作伙伴提供数据基础架构，工具和分析支持，以提供严格的数据见解，构建解决方案和服务，从而改变YouTube业务团队的工作方式。 分析师还与业务涉众合作，以了解他们的业务领域并建立业务需求，并与数据基础架构连接以构建满足这些需求所需的管道，数据集和工作流。

• Business Systems Integration: This team identifies time-consuming internal processes within Google’s internal partners and then builds reliable solutions that are scalable enough to work with the size and scope of the company. They also design and develop innovative recommendation systems from the ground up to increase business growth, apply science to Sales, and enable productivity for the Sales team.

  业务系统集成：该团队确定Google内部合作伙伴中耗时的内部流程，然后构建可靠的解决方案，这些解决方案具有足够的可伸缩性以适应公司的规模和范围。 他们还从头开始设计和开发创新的推荐系统，以提高业务增长，将科学应用于销售并为销售团队提高生产力。

• gTech’s Users and Products (gUP): The gUP team builds innovative solutions that take Google’s user experience and engagement to a whole new level, supporting users across products, countries, cultures, incomes, and identities. guP helps users get the most out of Google through data modelling, metric development, data prototyping, and insight generation using statistical techniques on Google’s users complex data.

  gTech的用户和产品(gUP)： gUP团队构建了创新的解决方案，将Google的用户体验和参与度提升到一个全新的水平，为产品，国家，文化，收入和身份的用户提供支持。 guP可使用Google用户的复杂数据上的统计技术，通过数据建模，指标开发，数据原型设计和见解生成，帮助用户充分利用Google。

• Sales and Sales Operations: This team leverages advanced data analytics and consistently manages reviews of key data metrics to guide decision making and enhance scalability and efficiencies. Analysts collaborate cross-functionally with Sales, Marketing, Finance, Legal and Operations teams to actively deliver standard processes, facilitating and supporting models for sales and streamline services.

  销售和销售运营：该团队利用先进的数据分析功能，并持续管理关键数据指标的审查，以指导决策制定并增强可扩展性和效率。 分析师与销售，市场，财务，法律和运营团队进行跨职能协作，以积极交付标准流程，促进和支持销售模型并简化服务。

• Google Pay: This team develops and implements safe and easy payment systems for Google users by working and interfacing with various facets of the banking/payment ecosystem, including networks, issuers, gateways, and FinTechs. Other duties include driving growth across all of Google’s monetizing products through initiating projects to gather and analyse end-to-end process flows for developing comprehensive, data-backed assessments of strategic questions.

  Google Pay：该团队通过与银行/支付生态系统的各个方面(包括网络，发行人，网关和FinTechs)合作并与之交互，为Google用户开发和实施安全便捷的支付系统。 其他职责包括通过启动项目来收集和分析端到端流程以开发全面的，以数据为依据的战略问题评估，从而推动Google所有货币化产品的增长。

面试过程 (The Interview Process)

Pixabay Pixabay

The Google business analyst interview is just like every other Google interview process. It starts with an online phone interview with a recruiter, and then you proceed to the technical screen interview with a manager. After the technical, the recruiter will then schedule an onsite interview, which comprises three to four one-on-one interview rounds with a lunch break in between.

Google业务分析师采访与其他所有Google采访过程一样。 首先是与招聘人员进行在线电话面试，然后是与经理进行技术面试。 技术培训结束后，招聘人员将安排一次现场面试，包括三到四次一对一的面试，中间有午餐休息时间。

To become more familiar with the interview process at Google, read “The Google Data Scientist Interview” on Interview Query!

要更熟悉Google的面试过程，请 阅读“面试查询”中的“ Google数据科学家面试”！

初始画面 (Initial Screen)

This is the first interview step with a recruiter or HR, and it is mainly exploratory. In this 45 minute long interview, the recruiter will ask questions about your relevant past experiences and projects, especially those that involve SQL. The recruiter will also provide insights into the company, job roles, and the company’s work culture.

这是与招聘人员或HR面试的第一步，主要是探索性的。 在这次长达45分钟的面试中，招聘人员将询问有关您过去的相关经验和项目的问题 ，尤其是涉及SQL的经验和项目 。 招聘人员还将提供有关公司，工作角色和公司工作文化的见解。

Note: In this interview, you should answer every question with a story or an experience that demonstrates your fit for the role using real-life examples and data.

注意：在这次采访中，您应该使用真实的例子和数据，用一个故事或一种经验来回答每个问题，以证明自己适合担任这个角色。

Sample Questions:

样题：

• Describe a data project you’ve done.
  描述您完成的数据项目。
• Tell me about yourself.
  说说你自己。
• Describe one project that you’re proud of that involved the practice of statistics.
  描述一个您引以为傲的涉及统计实践的项目。

技术画面 (Technical Screen)

Google’s business analyst technical screen follows almost the same protocol as most Google technical interviews. Standard case-based SQL questions are asked, and candidates are required to write SQL queries on a shared Google Doc.

Google的业务分析师技术屏幕遵循与大多数Google技术采访几乎相同的协议。 系统会询问基于案例的标准SQL问题，要求候选人在共享的Google文档上编写SQL查询。

Questions are standardized, so solving SQL questions from Interview Query can better prepare you for this interview.

问题是标准化的，因此从“ 面试查询”中解决SQL问题可以更好地为您准备这次面试。

To learn more about the types of SQL questions asked in a similar role, check out the “Product Analyst Interview Questions and Answers” article on Interview Query!

要了解有关以类似角色询问SQL问题的类型的更多信息， 请查看“面试查询”中的“产品分析师面试问题和解答”一文！

现场采访 (Onsite Interview)

The business analyst onsite interview is comprised of three interview rounds with a manager, a product specialist, and a business analyst all lasting between 30 and 45 minutes.

业务分析师现场访谈包括与经理，产品专家和业务分析师进行的三轮访谈，这些访谈持续30至45分钟。

Google interview candidates are assessed on four general attributes: “ general cognitive ability, leadership, role-related knowledge, and Googleyness “. Every interview question is wrapped around those four basic attributes and candidates are expected to shape their answers accordingly.

对Google面试候选人的评估具有以下四个一般属性：“ 一般认知能力，领导才能，与角色相关的知识和Googleyness ”。 每个面试问题都围绕这四个基本属性，应聘者应相应地制定答案。

The schedule for a Google business analyst onsite interview looks like this:

Google业务分析师现场采访的时间表如下：

1. Technical interview

1. 技术面试

This is an interview with a manager and questions are standard case-based SQL questions.

这是对经理的采访，问题是基于案例的标准SQL问题。

2. Product Sense Interview

2. 产品感官访谈

3. Leadership/Behavioral Interview

3. 领导/行为面试

4. Googleyness Interview

4. Googleyness面试

注意事项 (Notes and Tips)

Google’s business analyst interview assesses candidates’ ability to leverage data analytics to identify key business insights, provide solutions, and help make sound, strategic business decisions. Interview questions cover mainly conceptual level data science knowledge, predictive modelling, metrics and strategy definition, and the ability to communicate insights to stakeholders. Brush up on your knowledge of descriptive analytics, statistics and probability, time-series, regression, and predictive modelling.

Google的业务分析师面试评估了候选人利用数据分析来识别关键业务见解，提供解决方案并帮助做出合理的战略性业务决策的能力。 面试问题主要包括概念层面的数据科学知识，预测建模，指标和策略定义以及与利益相关者交流见解的能力。 掌握有关描述性分析，统计和概率，时间序列，回归和预测建模的知识。

Google Business Analyst面试问题： (Google Business Analyst Interview Questions:)

• How would you advise management in terms of improving current product offerings? On what basis?
  在改善当前产品方面，您将如何建议管理层？ 在什么基础上？
• How do you measure the value of a user?
  您如何衡量用户价值？
• If you are the owner of a flower shop, how would you target your customers online? (Who? When? Where? How?)
  如果您是一家花店的所有者，您将如何在线定位客户？ (谁？何时？哪里？如何？)
• What type of SQL joins are you familiar with?
  您熟悉哪种类型SQL连接？
• What’s your ETL and OLAP experience?
  您的ETL和OLAP经验是什么？
• What DB and visualization tools have you used?
  您使用了哪些数据库和可视化工具？
• List a few SQL Analytical functions.
  列出一些SQL Analytical函数。
• Give me an example of a project you’ve led. What was the result? Which difficulties did you meet?
  给我一个您领导的项目的例子。 结果如何？ 您遇到了哪些困难？
• If you’re setting up a new e-commerce business, what are the things you would look at?
  如果您要建立一个新的电子商务业务，您会看到什么？
• How would you build a patent system?
  您将如何建立专利制度？
• Name a google product you use and what would you change about it? How would you improve it?
  为您使用的Google产品命名，您将对其进行哪些更改？ 您将如何改善？
• Describe AdWords in three sentences to a child.
  用三个句子向一个孩子描述AdWords。

Originally published at https://www.interviewquery.com on August 1, 2020.

最初于 2020年8月1日 发布在 https://www.interviewquery.com 上。

翻译自: https://towardsdatascience.com/the-google-business-analyst-interview-b52e5108e0be

van访谈