Google数据分析师教你怎么样拿下大厂面试
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/fcmOjAhra3rZW43niaSpdaibnxp5iaaIQaYMFEHx6QOEKpOqCMMpyBUKwQ8jUBekEFzXYZ6Pl5wP3CqYl6Cr2PKGw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"><strong style="color: blue;">2020</strong></span><span style="color: black;">年<span style="color: black;">针对</span>所有留学生<span style="color: black;">来讲</span>，可真的是太难了。受疫情的影响，大<span style="color: black;">都数</span>学校<span style="color: black;">已然</span>改为网上授课。而<span style="color: black;">针对</span>马上毕业，准备求职的<span style="color: black;">朋友</span>们<span style="color: black;">来讲</span>，想必<span style="color: black;">更加是</span>煎熬。<span style="color: black;">有些</span><span style="color: black;">本来</span>安排好的onsite面试要不改<span style="color: black;">成为了</span>在线上进行，要不<span style="color: black;">便是</span>往后推延；还有<span style="color: black;">非常多</span><span style="color: black;">机构</span><span style="color: black;">更加是</span>暂时中止了招聘。</span><span style="color: black;">但即便行情看上去不容<span style="color: black;">阳光</span>，</span><span style="color: black;">身处茫茫求职大军的<span style="color: black;">咱们</span><span style="color: black;">亦</span><span style="color: black;">不可</span>就此懈怠，更<span style="color: black;">不可</span>停下面试准备，仗都还没打就缴械投降了，那还谈何胜算？</span><span style="color: black;">说一句真理：机会永远是留给有准备的人的。<span style="color: black;">咱们</span>更加应该<span style="color: black;">调节</span>好<span style="color: black;">心理</span>，把握好节省下来的时间。</span><span style="color: black;">为了<span style="color: black;">帮忙</span><span style="color: black;">大众</span><span style="color: black;">安稳</span>的度过这段特殊时期，<span style="color: black;">咱们</span>为<span style="color: black;">大众</span>整理了<span style="color: black;">有些</span>数据<span style="color: black;">关联</span>的求职经验分享。本文作者Vincent Tatan，<span style="color: black;">经过</span>了重重面试，拿下了Google数据分析师的职位，他<span style="color: black;">亦</span>曾在VISA担任数据软件结构工程师，他将用亲身体验告诉你，<span style="color: black;">怎样</span>应对Google、Visa、Amazon等大厂的各轮面试，斩获自己心仪的职位。</span><span style="color: black;">在众<span style="color: black;">都数</span>据分析岗面试中，你会面临以下三类问题：技术类问题、<span style="color: black;">行径</span>类问题、假设类问题。下面让<span style="color: black;">咱们</span>一一进行解析。</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">技术类问题</span></strong></span><img src="https://mmbiz.qpic.cn/mmbiz_gif/fcmOjAhra3rZW43niaSpdaibnxp5iaaIQaY3Bw3YRkpFiaSkx7Loia4y2pLQgakfBZzQrK5y0dibKFrRoicLApI3JkItQ/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">Source：Giphy</span><span style="color: black;">技术面<span style="color: black;">一般</span>出<span style="color: black;">此刻</span><span style="color: black;">第1</span>轮或第二轮，以<span style="color: black;">保证</span>你在和HR与主管面试之前<span style="color: black;">已然</span>具备了这个岗位的技术<span style="color: black;">需求</span>。<span style="color: black;">通常</span>会考察：</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">SQL</span></strong></span><span style="color: black;">SQL题<span style="color: black;">一般</span>的考法是向你出示几张表，其中<span style="color: black;">包含</span>日期、字符串和数字列，<span style="color: black;">需求</span>你<span style="color: black;">运用</span>SQL语言聚合某些年或某些类别（例如年龄或地点等）的数据。</span><span style="color: black;">解答这类问题，我的<span style="color: black;">意见</span>是：</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">询问<span style="color: black;">有些</span>假设：</span></strong><span style="color: black;"><span style="color: black;">针对</span>相同的值，某个数据点<span style="color: black;">是不是</span><span style="color: black;">能够</span>用<span style="color: black;">区别</span>的方式<span style="color: black;">暗示</span>。例如，“ Street”和“ St”<span style="color: black;">拥有</span>区分<span style="color: black;">体积</span>写的差异。这<span style="color: black;">能够</span><span style="color: black;">帮忙</span>你在SQL中<span style="color: black;">运用</span>filter，例如<span style="color: black;">运用</span>“like”匹配还是“exact”匹配单词。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">思虑</span>一下极端<span style="color: black;">状况</span>：</span></strong><span style="color: black;">数字数据<span style="color: black;">是不是</span><span style="color: black;">已然</span>是纯数字格式，<span style="color: black;">无</span>任何歧义或缺失值，例如-1<span style="color: black;">表率</span>丢失的数字。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">把你的所想大声说出来：</span></strong><span style="color: black;">从绘制思维图，在白板上写下<span style="color: black;">处理</span><span style="color: black;">方法</span>，<span style="color: black;">而后</span>大声思考来<span style="color: black;">保证</span>你的思维过程清晰。在面试官确认后，用你<span style="color: black;">爱好</span>的语言编写<span style="color: black;">处理</span><span style="color: black;">方法</span>的代码。</span></p><span style="color: black;"><span style="color: black;">另外</span>，SQL考察还经常在考数据聚合和过滤（group by和having语法）的<span style="color: black;">同期</span>考连接表的题（inner join，outer join），请参考下图。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/fcmOjAhra3rZW43niaSpdaibnxp5iaaIQaYNtLZFO7sybo15HjWkxicsDsWeVSNGcFQdHGksKuSbldEQbYleStZ5RA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">Source：Stack Overflow</span><span style="color: black;">此时，<span style="color: black;">倘若</span>你忘记了某个语法，请老实告诉面试官。写下你所<span style="color: black;">晓得</span>的并继续。 你的面试官<span style="color: black;">晓得</span>只要你对SQL JOIN有透彻的<span style="color: black;">认识</span>，某个<span style="color: black;">详细</span>的语法<span style="color: black;">能够</span>简单<span style="color: black;">经过</span>上网搜索<span style="color: black;">处理</span>。就算出了错，<span style="color: black;">亦</span>不要太慌张，微笑，继续。</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">代码问题</span></strong></span><span style="color: black;">接下来面试官会问你<span style="color: black;">有些</span>代码问题。可能是<span style="color: black;">怎样</span>对某个二维数组排序，<span style="color: black;">怎样</span>在单词字符串中搜索某些p</span><span style="color: black;">attern，<span style="color: black;">或</span><span style="color: black;">怎样</span>聚合数据。在这种<span style="color: black;">状况</span>下，我鼓励<span style="color: black;">运用</span>python，<span style="color: black;">由于</span>它的语法<span style="color: black;">做为</span>脚本语言要短得多，并且<span style="color: black;">出现</span>bug的几率较小（用Java就可能<span style="color: black;">显现</span>缺少分号的问题）。</span><span style="color: black;"><span style="color: black;">一样</span>，要回答此问题，<span style="color: black;">咱们</span>需要从以下内容<span style="color: black;">起始</span>：</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">给出假设并找到你的测试用例：</span></strong><span style="color: black;">这是你<span style="color: black;">自动</span>决定用例的机会。<span style="color: black;">倘若</span>列表中有重复或未排序的数据，它将返回什么？<span style="color: black;">倘若</span>列表为空怎么办，它将返回什么？<span style="color: black;">倘若</span>用户传递空值该怎么办？</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">给出多个答案：</span></strong><span style="color: black;">大<span style="color: black;">都数</span>时候，你应该能够想到简单粗暴的<span style="color: black;">办法</span>，将<span style="color: black;">全部</span>列表逐一元素过一遍。<span style="color: black;">另外</span>，你<span style="color: black;">能够</span>设计一个更有效的排序算法（合并排序等）和迭代。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">写代码前先确认你的答案：</span></strong><span style="color: black;">向面试官确认你的答案，并且<span style="color: black;">仅有</span>在<span style="color: black;">准许</span>后才开始写代码。征求<span style="color: black;">她们</span>的反馈并修复你的算法。<span style="color: black;">另一</span>，请<span style="color: black;">重视</span>在做类似经典的“栅栏涂色问题”（<span style="color: black;">不可</span><span style="color: black;">显现</span>连续两根以上栅栏颜色<span style="color: black;">同样</span>）时，要格外小心犯<span style="color: black;">有些</span>致命的低级错误（<span style="color: black;">例如</span><span style="color: black;">由于</span>索引值超出范围而报错）。最后，用测试用例测试代码。</span></p><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">行径</span>类问题</span></strong></span><img src="https://mmbiz.qpic.cn/mmbiz_gif/fcmOjAhra3rZW43niaSpdaibnxp5iaaIQaYgCl6qB6fcYkaKYJ84MA7K47Uf76ibWt9eCAjSibH3A2TbGkaGTTu3nvw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">Source：Giphy</span><span style="color: black;">这类问题的目的是让你的面试官<span style="color: black;">认识</span>你过去的经历以及你<span style="color: black;">处理</span>问题的方式<span style="color: black;">办法</span>。</span><span style="color: black;"><span style="color: black;">平常</span>的问题有，你之前做过<span style="color: black;">那些</span>数据项目？</span><span style="color: black;">这是你表现自己的机会。<span style="color: black;">做为</span>有抱负的数据分析师或数据<span style="color: black;">专家</span>，你们中的大<span style="color: black;">都数</span>人应该<span style="color: black;">持有</span><span style="color: black;">有些</span>值得夸耀的项目。<span style="color: black;">倘若</span>你有Github项目，请准备好并展示你所构建的<span style="color: black;">有些</span>应用程序。<span style="color: black;">倘若</span>你像我<span style="color: black;">同样</span>在Medium上撰写博客，请展示你最受欢迎的项目并展示<span style="color: black;">拜访</span>量。无论你有什么项目，都应专注于<span style="color: black;">供给</span>能展示你的技能和<span style="color: black;">自信心</span>的指标。</span><span style="color: black;">优秀的答案长<span style="color: black;">这般</span> 论坛是一个舞台，让我们在这里尽情的释放自己。 认真阅读了楼主的帖子，非常有益。 论坛外链网http://www.fok120.com/ 你的话语如春风拂面，让我感到无比温暖。
页:
[1]