<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Bao Nguyen on Medium]]></title>
        <description><![CDATA[Stories by Bao Nguyen on Medium]]></description>
        <link>https://medium.com/@baovnguyenhn?source=rss-31c9d9315c48------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*-Wzq-5QYiTRsXTXT7CRwLg.jpeg</url>
            <title>Stories by Bao Nguyen on Medium</title>
            <link>https://medium.com/@baovnguyenhn?source=rss-31c9d9315c48------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 05:56:34 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@baovnguyenhn/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Ace any data visualization project by asking yourself these 3 questions]]></title>
            <link>https://medium.com/data-science/3-questions-you-must-ask-yourself-before-visualizing-any-data-set-85df509c81fc?source=rss-31c9d9315c48------2</link>
            <guid isPermaLink="false">https://medium.com/p/85df509c81fc</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-analyst]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[visualization]]></category>
            <category><![CDATA[design-thinking]]></category>
            <dc:creator><![CDATA[Bao Nguyen]]></dc:creator>
            <pubDate>Fri, 16 Oct 2020 16:42:23 GMT</pubDate>
            <atom:updated>2020-10-19T14:15:48.509Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*tN_2CyoanuWyoy8M" /><figcaption>Photo by <a href="https://unsplash.com/@metisdesigner?utm_source=medium&amp;utm_medium=referral">Metis Designer</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>As a data analyst, a significant chunk of my time is used to visualize data sets for different stakeholders. Data visualizations can take many forms. They can be a simple Google Sheets charts, some visualizations on a Python notebook, or a complex Tableau dashboard. Here are three questions that I always ask myself before visualizing any data set.</p><h3>Who is your target audience?</h3><p>This is undoubtedly the most important question to ask yourself. Are the stakeholders technical or non-technical audiences? What is their familiarity level with the data that you are about to visualize? Are they your peers or Executive-level managers? Are you visualizing data for a diverse group of audience or a specific team? Knowing your target audience well before thinking of visualizing data helps you achieve half of the success.</p><p>I often note down my audience profile by answering all of the questions above. I have different visualization approaches tailored to each audience type. For example, if my audience is a non-technical one who asked me to do some exploratory analyses, I’ll think of some Google Sheets charts instead of a Tableau dashboard. Doing that way, I can easily share with them the data set too. They can adjust the graphs or charts based on their needs. For example, they may realize later that they are only interested in last month’s data instead of the initial ask of 6-month data.</p><p>If I know that I am about to present some visualizations to a big and diverse group, I will pay more attention to adding more explanation into the visualization. For example, “daily active users” or “retention rate” may sound trivial at first. However, those metrics can have very different definitions across businesses or industries. I would add a short caption under my graphs or charts to explain how I calculated those metrics.</p><h3>What is the objective of this visualization?</h3><p>After knowing about my audience, I often initiate a quick discussion with them to learn more about their expectations. Simply asking “what is your objective?” may work, but it is not always as easy as it seems. However, I still recommend being very straightforward by asking about their needs and expectations. Then, I ask probing questions to boil down into the most important requirement that I need to meet.</p><p>For example, the Customer Success team wants to know more about customer complaints and their team performance. During the initial conversation, I would verify if they need an ad-hoc analysis or a deep-dive dashboard. In the first case, a few Excel charts should be enough to tackle their burning questions. In the second case, I need to build a dashboard showing various metrics to help them have a comprehensive understanding of historical data, current performance, and future trends.</p><p>Suppose that they want to have a dashboard. Then, we together brainstorm a list of metrics that they want to see. During the brainstorming step, I share with my stakeholder that they shouldn’t worry about feasibility or priority. Let’s just think of as many metrics as possible. After that, we rank the metrics based on priorities. If we know exactly what should be at the top of the priority list, this task is easy. Otherwise, we assign the relative scores for each metric, then choose the top three or five ones. Once the priorities are figured out, we talk about feasibility. Some metrics are easily built, some aren’t, mostly because relevant data used to build those metrics are not available yet.</p><p>The process that I mentioned might take one or two 30-min meetings. The list of ranked metrics is kept in a shared Google Docs file, which is sharable and allows others to comment. Having a clear structure about how you understand their expectations and requirements helps you navigate the data visualizing process much easier.</p><h3>What is the story behind the data?</h3><p>If the data doesn’t stand out to you, maybe you need to spend some time to think a bit deeper. For example, you might be very proud of a stacked bar graph showing the number of customer complaints broken down by categories. The graph looks clear with all the necessary headers and titles. The color palette looks great. However, what insights do you find by looking at this graph? You may realize that one category might dominate others. In this case, sorting the fields in descending order is the most helpful action. The audience can easily spot that dominating category in a first-place when looking at your graph.</p><p>Some types of data visualization look like the best candidate in the beginning, but not until you think about the story behind the data. When you are working with time-series data, it is very tempting to think that a line graph is a no-brainer answer. However, do you think sometimes a bar graph is a better candidate? A bar graph not only helps you see the trend, but it helps you spot outliers much faster, thanks to the outstanding strength of those bars compared to others.</p><p>Let’s go back to the Customer Success dashboard example. Suppose you are visualizing the number of customer service tickets through time with the x-axis being periods and the y-axis being the number of tickets. A line graph emphasizes your focus on the overall trend. However, a bar graph may switch your attention to a few weeks in August when there was a spike in the number of tickets. After doing some research, you may find out that the root cause was a new product launch during those weeks. Since customers were not familiar with the new product, they asked a lot of questions, which increased the number of tickets. As a result, the team realized that they should add more instructions about the new product to reduce the number of tickets for it.</p><h3>Conclusion</h3><p>These three questions are my self-made checklist before I do any data visualization project. That helps me navigate the process very effectively, saves time for everyone, and makes my workflow much more structured. My suggestion to you is to create your checklist. Please feel free to add more steps to the process if you find they are helpful. I hope you feel more confident when delivering any data visualization.</p><p><em>Originally published at </em><a href="https://baovinhnguyen.com/2020/10/16/3-questions-you-must-ask-yourself-before-visualizing-any-data-set/"><em>http://baovinhnguyen.com</em></a><em> on October 16, 2020.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=85df509c81fc" width="1" height="1" alt=""><hr><p><a href="https://medium.com/data-science/3-questions-you-must-ask-yourself-before-visualizing-any-data-set-85df509c81fc">Ace any data visualization project by asking yourself these 3 questions</a> was originally published in <a href="https://medium.com/data-science">TDS Archive</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to ace data visualization interviews at FAANG companies]]></title>
            <link>https://medium.com/data-science/how-to-ace-data-visualization-interviews-at-faang-companies-2c29145378d?source=rss-31c9d9315c48------2</link>
            <guid isPermaLink="false">https://medium.com/p/2c29145378d</guid>
            <category><![CDATA[interview-tips]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-analyst]]></category>
            <dc:creator><![CDATA[Bao Nguyen]]></dc:creator>
            <pubDate>Sun, 11 Oct 2020 01:20:29 GMT</pubDate>
            <atom:updated>2020-10-11T03:37:43.317Z</atom:updated>
            <content:encoded><![CDATA[<h3>How to ace data visualization interviews at FAANG companies?</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*OrKQggup8oAIdPqr.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@punttim?utm_source=medium&amp;utm_medium=referral">Tim Gouw</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>When it comes to technical interviews, we all think about SQL, coding, or statistics interviews. However, there is one area that is also important, which is data visualization. This article is about how to ace data visualization interviews.</p><p>A few months ago I was selected to the final round for a Business Analyst role at a FAANG company. There were four interviews, including two behavioral, one data visualization, and one data analytics. Although I didn’t get the job eventually, my recruiter said that their feedback on my data visualization interview was very positive. Therefore, I guess I earned a “pass” at least in that interview. I want to share with you how I aced the data visualization interview in this article.</p><p>The data visualization interview lasted in 45 minutes. The team wanted to evaluate the candidate’s ability to design effective visualizations and learn about their experiences designing various types of visualizations. Here are the questions that I received and my approach to those questions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*KO6m8JVCh97UaN0p" /><figcaption>Photo by <a href="https://unsplash.com/@firmbee?utm_source=medium&amp;utm_medium=referral">William Iven</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h3>What is your data visualization philosophy?</h3><p>I bet all of you will agree with me that this is a very broad question. Everyone can come up with a different answer. My data visualization philosophy is that my visualizations need to tailor to the target audience’s needs as much as possible. A dashboard is useless when no one looks at it.</p><p>I made sure that I defined clearly the target audience. I worked with them closely to understand their needs regarding metrics and types of visualization. I closely followed up with them to promptly any change in their need.</p><h3>Tell me about a data visualization project that you were very proud of?</h3><p>This question is the most expected question before the interview, so I already prepared two to three stories and practiced very carefully. For each story, the STAR method (Situation — Task — Action — Result) always works. I talked about a very specific situation when I had to build a dashboard. I described the purpose of the dashboard, the key stakeholders a.k.a. target audience, how I worked with the stakeholders to come up with the metrics, and what types of visualizations I made.</p><p>I also shared about a time when the initial plan didn’t work out as expected, when there was a change in stakeholders’ needs, and how I followed up with the stakeholders to ensure the dashboard works in the way that they expected. I summarized my story by sharing the key learning points that I got after that experience.</p><h3>What data visualization tools that you use?</h3><p>I use Tableau as the main tool of data visualization during my past roles, so Tableau is a no-brainer answer for me. I described what advanced Tableau functions or features that I used. The main point is to talk about a data visualization tool that you are good at, not to list a lot of tools that you learn or know about.</p><p>However, Tableau (or other similar data visualization software) is not the only way to visualize data. Drawing a chart using Google Sheets works too! It depends on the target audience and the purpose of visualizing data. For example, I use a simple Google Sheets chart when I need a quick way to visualize the data set, when my data set needs to be shared across a group of users or when my stakeholder is a non-technical data user.</p><h3>A data visualization case study</h3><p>The question is: “Suppose our company has a few offices around the US. We want to know the performances of those offices to optimize the space for our employees. Your job is to build a dashboard to show office utilization performance”.</p><p>I received a preview of the data sets. I had to build an imaginary dashboard using Google Drawings. You can draw charts in Google Drawings using a similar approach when drawing charts in Google Sheets.</p><p>Before jumping in the visualizing steps, I asked the interviewer who are this dashboard for. The dashboard is for executive-level managers. To me, that means I need to show the highest-level metrics so that the managers know what is going on by looking at this snapshot. Then, I brainstormed the metrics to show. I came up with three to four metrics.</p><p>I didn’t only build the charts and graphs. For each metric, I explained the rationale behind using this type of visualization and not the other. Talking out loud the process not only helps show the thought process but also makes me realize that some other types of charts express my metric better compared with the chart that I came up within the first place. Also, charts and graphs aren’t only pie charts, bar graphs, or line graphs. You can use typography, which means showing the pure key numbers in this case. The dashboard users can get the important figures immediately without having to find from the charts or graphs.</p><p>A dashboard is not enough without the filters. I spent time thinking about appropriate filters, drawing those, and explaining to the interviewer. Some important filters include date range, locations/ markets, and time-frequency (where users can select a daily, weekly, or monthly view).</p><p>After all, I summarized the key points about my dashboard, including the target audience, important metrics, types of visualizations, and filters. I also mentioned a potential way to further develop the dashboard in the future if have more variables in the data set or more stakeholders involved.</p><h3>Conclusion</h3><p>My interview experience is unique and by no means would be the same for everyone. It serves as a single data point and should not be generalized to all data visualization interviews. I hope you gained some insights and perspectives from my experience to help you tailor your interview preparation and to ace data visualization interviews.</p><p><em>Originally published at </em><a href="https://baovinhnguyen.com/2020/10/10/how-to-ace-data-visualization-interviews-at-faang-companies/"><em>http://baovinhnguyen.com</em></a><em> on October 11, 2020.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2c29145378d" width="1" height="1" alt=""><hr><p><a href="https://medium.com/data-science/how-to-ace-data-visualization-interviews-at-faang-companies-2c29145378d">How to ace data visualization interviews at FAANG companies</a> was originally published in <a href="https://medium.com/data-science">TDS Archive</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to get more insights using SQL IN operator?]]></title>
            <link>https://medium.com/data-science/how-to-get-more-insights-using-sql-in-operator-9bbe73f9b4ba?source=rss-31c9d9315c48------2</link>
            <guid isPermaLink="false">https://medium.com/p/9bbe73f9b4ba</guid>
            <category><![CDATA[sql-tutorial]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data-analyst]]></category>
            <category><![CDATA[tricks]]></category>
            <category><![CDATA[tips-and-tools]]></category>
            <dc:creator><![CDATA[Bao Nguyen]]></dc:creator>
            <pubDate>Mon, 05 Oct 2020 01:16:22 GMT</pubDate>
            <atom:updated>2020-10-05T03:05:51.329Z</atom:updated>
            <content:encoded><![CDATA[<h4><em>Use IN operator to merge data across tables</em></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*P-Q2EpghS_s27EoK" /><figcaption>Photo by <a href="https://unsplash.com/@a_wandering_yogi?utm_source=medium&amp;utm_medium=referral">Kristina Wagner</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>We all know that SQL IN is a helpful operator, which allows you to choose multiple conditions within the WHERE clause. However, the IN operator is even more helpful than you think. You can merge data across tables with IN.</p><h3>An example using a Google BigQuery public data set</h3><p>To illustrate, I will go through a quick tutorial. I use a Google BigQuery’s public data set called <strong>austin_bikeshare</strong>. Therefore, you can easily follow my codes to practice.</p><p>There are two tables in this data set. <strong>bikeshare_stations </strong>table includes information about stations’ names, statuses, and locations. <strong>bikeshare_trips</strong> table includes information about trips’ start time, end time, start station, end station, duration, and type of the subscriber.</p><p>As a data analyst, I might want to know the performance of each start station through the number of trips taken. However, I am only interested in stations that are still active. Therefore, I can frame my question as follows:</p><blockquote>How many trips were taken per each active start station?</blockquote><p>You can easily find the start stations and the associated trips from the <strong>bikeshare_trips</strong> table. However, the status of each station lies in the <strong>bikeshare_stations</strong> table. A solution might be using JOIN:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/221b21e4571f6f5be5278f5869bc24fe/href">https://medium.com/media/221b21e4571f6f5be5278f5869bc24fe/href</a></iframe><p>There is another solution using IN, in which you don’t have to use JOIN. First, you select the name of all start stations and the number of trips by counting trip IDs from the <strong>bikeshare_trips</strong> table. Then, in the WHERE clause, you write a subquery selecting all stations that are active from the <strong>bikeshare_stations</strong> table and use the IN operator. As a result, the selected stations are limited within a subset of active ones instead of all stations. The codes are as follows:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/af37c2c9472371fdb879c2b333cb1fff/href">https://medium.com/media/af37c2c9472371fdb879c2b333cb1fff/href</a></iframe><h3>Another example from a Leetcode question</h3><p>I use question number 607 (Sales Person) to further illustrate. The question is to select all the names in the table <strong>salesperson</strong>, who didn’t have sales to the company &#39;RED&#39;.</p><p>Table: salesperson</p><pre>+----------+------+--------+-----------------+-----------+<br>| sales_id | name | salary | commission_rate | hire_date |<br>+----------+------+--------+-----------------+-----------+<br>|   1      | John | 100000 |     6           | 4/1/2006  |<br>|   2      | Amy  | 120000 |     5           | 5/1/2010  |<br>|   3      | Mark | 65000  |     12          | 12/25/2008|<br>|   4      | Pam  | 25000  |     25          | 1/1/2005  |<br>|   5      | Alex | 50000  |     10          | 2/3/2007  |<br>+----------+------+--------+-----------------+-----------+</pre><p>Table: company</p><pre>+---------+--------+------------+<br>| com_id  |  name  |    city    |<br>+---------+--------+------------+<br>|   1     |  RED   |   Boston   |<br>|   2     | ORANGE |   New York |<br>|   3     | YELLOW |   Boston   |<br>|   4     | GREEN  |   Austin   |<br>+---------+--------+------------+</pre><p>Table: orders</p><pre>+----------+------------+---------+----------+--------+<br>| order_id | order_date | com_id  | sales_id | amount |<br>+----------+------------+---------+----------+--------+<br>| 1        |   1/1/2014 |    3    |    4     | 100000 |<br>| 2        |   2/1/2014 |    4    |    5     | 5000   |<br>| 3        |   3/1/2014 |    1    |    1     | 50000  |<br>| 4        |   4/1/2014 |    1    |    4     | 25000  |<br>+----------+----------+---------+----------+--------+</pre><p>Since the question only asks for names of the salespeople, so it makes sense to select <strong>name</strong> from the <strong>salesperson</strong> table. However, how about the ones that didn’t have sales to the company ‘RED’?</p><p>The IN operator comes into play in this scenario. Instead of using only IN, we use NOT IN. First, we choose a subset of employees who had sales with the company ‘RED’ by joining <strong>orders</strong> table with <strong>company</strong> table, selecting sales IDs, and using the condition that company name is ‘RED’. Then, we simply select the sales IDs that don’t belong to that subset. Here are the codes to follow:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/e743218768c4974b8c3ac886515506cd/href">https://medium.com/media/e743218768c4974b8c3ac886515506cd/href</a></iframe><p>By following these two examples, I hope you have a better understanding of how to use IN operator to merge data across tables without using JOIN.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9bbe73f9b4ba" width="1" height="1" alt=""><hr><p><a href="https://medium.com/data-science/how-to-get-more-insights-using-sql-in-operator-9bbe73f9b4ba">How to get more insights using SQL IN operator?</a> was originally published in <a href="https://medium.com/data-science">TDS Archive</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How did I get a data analyst job during the pandemic?]]></title>
            <link>https://medium.com/data-science/how-did-i-get-a-data-analyst-job-during-the-pandemic-c37a35d7c656?source=rss-31c9d9315c48------2</link>
            <guid isPermaLink="false">https://medium.com/p/c37a35d7c656</guid>
            <category><![CDATA[interview-preparation]]></category>
            <category><![CDATA[office-hours]]></category>
            <category><![CDATA[data-analyst]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Bao Nguyen]]></dc:creator>
            <pubDate>Sun, 27 Sep 2020 01:52:45 GMT</pubDate>
            <atom:updated>2020-09-28T14:07:04.263Z</atom:updated>
            <content:encoded><![CDATA[<h4><a href="https://towardsdatascience.com/tagged/office-hours">Office Hours</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RVPRxqz2VUuY7NGXSXzmtw.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@kmuza">Carlos Muza</a> on <a href="https://unsplash.com/s/photos/data-analytics?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>Two years ago, I came to the US to start my Master’s degree in Economics. After the first year, I was fortunate to earn a summer internship in a big tech firm as a Data Analytics intern. With good education and background, I was completely confident in earning a full-time role as a Data Analyst after graduation. I started applying intensively from February: creating a hit list of roles and companies that I want, networking with alumni and people from those firms, and preparing for interviews.</p><p>Then, the pandemic came. In March, all of the roles that I applied were canceled. The job market was more crowded than ever with a decrease in demands and an increase in supplies. Companies downsized and laid off their employees. A lot of talents became available in the job market. My job search journey suddenly became much longer than I expected. Experiencing the endless job search process, receiving rejections, and being burned out from multiple interviews every week made me feel hopeless.</p><p>After months of persistently applying, finally I earned a full-time Data Analyst role at a start-up in Boston, where I have an opportunity to do exactly what I love. In retrospect, there were three main lessons that I wanted to share to help you go through this trying time.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*L7DPLnnCFGvdUKpBFvoqzQ.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@austindistel">Austin Distel</a> on <a href="https://unsplash.com/s/photos/data-analytics?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><h3>Networking, networking, and networking</h3><p>Let’s think about the applying experience that you had. You opened LinkedIn, saw a Data Analyst job post from the firm that you like, and decided to apply. You spent half an hour to tailor your resume, half an hour to write a compelling cover letter, and another half an hour to fill in the application. And what happens next? Nothing. You just simply didn’t hear back from the firm. Two months later, you received an email with the subject “Thank you for applying to [company name]” and with the familiar message: “We are very impressed with your qualifications; however, we have decided not to move forward with your candidacy for this role”.</p><p>This story seems to be so familiar with all of us. So, how could we do differently? Networking. Instead of spending an hour and a half to apply, let’s spend that amount of time to do networking. Networking is a great way to get through the door. Chances are you will be connected to the recruiter or the hiring manager of the role. If not, staying in the referral pipeline tremendously helps too. So, how would you go about it?</p><p>There were two sources of contact that you can find: alumni from your school and LinkedIn contacts. Each source has its pros and cons. Talking to alumni is great because your similar background (coming from the same school) means a lot. Generally, alumni want to help the next generation. There are potentially a lot of things you can talk about regarding your common learning experiences. However, you might not find any alum currently working at the firm you want to apply to. The alum you know might work at a completely different department that has little contact with the team you are applying. If that is the case, you may want to try messaging relevant LinkedIn contacts. Although they have little incentive to help you as you and they are strangers, they might have direct access to the team that you are interested in. So, what strategy you should use? The answer is both.</p><p>A low-hanging fruit step to find alumni contacts is reaching out to the Career Center of your university. They may have a list of alumni who are willing to help students. My university has an alumni database where their emails are visible. Once I have a list of alumni that I want to reach out with their contacts, I emailed them. Sending emails is a good way to get their attention. Your email may pop up right away in front of them, your message can be longer, and you can attach your resume to your email. Alternatively, you can connect them on LinkedIn and send an introduction message.</p><p>If the first strategy is not possible or not helpful, here is how I search for strangers on LinkedIn. On the People search, I filtered by Current companies (the company that you are applying) and Locations (the US, in case those companies have offices outside the US). On the search box, I typed the team or the title that might be relevant to the role. Among the results, I checked their profiles to create a list of who is relevant the most. Then, I sent connection requests with short and concise messages. It is always recommended to send a message besides the connection request and mention the exact role or team that you are applying to. However, do not mention about referrals from the very first email.</p><p>After the person accepted my connection request, I shared more with them about my background and interest in the company. If they are comfortable, I was opened about asking them to refer, introduce myself to the hiring manager, or pass my resume to the aligned recruiter. The same process applies to alumni. Being personally introduced to the hiring manager or having a referral increases your likelihood to kick-off the hiring process.</p><h3>Prepare for technical interviews</h3><p>As a Data Analyst candidate, I am sure that all of you know what to expect during the interview process. The skills vary across firms and exact roles; however, the following skills are normally expected: Excel, SQL, data visualization (E.g.: Tableau), and data analysis. Some firms might be interested in Python and machine learning too. Behavioral questions are definitely and sometimes equally important; however, I will leave this topic for another post because I want to focus more on data analyst interviewing aspects.</p><p>The first step is to prepare at least three stories about how you used Excel, SQL, or Tableau in the past. It is not strictly based on past work experiences; however, you should be able to tell the formulas or functions that you used, the complexity of the projects, and the impacts. Then, it is about practicing. For Excel, googling exercises and applying the formulas you want to practice should work. For SQL, I practiced on Leetcode. I set a schedule to practice daily with at least three to five questions a day. I spent a lot of time to think about the solutions, compare with peers’ answers, and write down what I can improve or what I can learn from the exercise. For data visualization, since all of my previous dashboards and visualizations belong to the companies that I worked for, I found public data sets and created two to three dashboards to showcase my skills.</p><p>Practicing data analysis problems is more tricky. Data analysis problems could be asked in two ways, either a general business question that requires you to break down the steps and bring a data-driven solution or a data case that asks you to crunch the data and share insights from that specific data set. The first type of data analysis problem depends a lot on the company that you are preparing for. For example, when I was applying to an e-commerce company, I did some research to learn more about the common business problems that they are facing and relevant metrics. I asked myself questions, such as how to improve the number of customers, how to increase the number of purchases, or how to reduce churn. I wrote down concise bullet points to organize my answers and practiced talking as if I were presenting the solution in front of the interviewer. For the second type of data analysis problem, I found public data sets (E.g.: Kaggle) and practiced crunching data: doing exploratory analysis, visualizing data distributions, finding correlations, and applying statistical methods to find insights from the data set.</p><h3>Build your brand</h3><p>You should expect to compete with hundreds or thousands of applicants for one role. Therefore, building your professional brand helps you stand out from the crowd. I made sure that recruiters and hiring managers could recognize my data analytics experiences by looking at my profile. All of my past experiences highlighted data analytics related aspects and achievements. My LinkedIn profile has all relevant keywords and skills that recruiters may search for or look for. I built a GitHub portfolio that shows past projects, both school, and personal ones. Besides, a personal website works as well.</p><p>Since tailoring your profile is important, I only applied for the roles that I was interested in. I carefully read the job description and noted down the skills and experiences that the team is looking for. Then, I compared the relevance between my resume and the job description. I tailored my experiences to closely match the requirements. For example, for a Marketing Data Analyst role, I emphasized my marketing related experiences, such as optimizing funnel conversion process, improving email performances, or conducting customer segmentation analysis.</p><p>Taking online courses and showing online certificates are also good ways to signal your skills and passion. I frequently learned online courses from Coursera and LinkedIn Learning about various data analytics related areas then showed the certificates on my LinkedIn profile. However, I do not recommend listing too many certificates on your resume. Your resume has limited space which should be optimized for important highlights of your skills and experiences.</p><h3>A quick note</h3><p>The job search process is stressful and frustrating. Therefore, I want to emphasize the importance of relaxing and balancing your life. There were times that I constantly found myself sending networking messages, practicing interviews, and feeling worried all the time. That does not work in the long term. Spending more time to prepare right before an important interview is acceptable; however, you will soon feel burn out if you cannot draw a clear line between a job application and other areas in your life.</p><p>During my job search period, I planned a clear schedule and determined how many hours I would spend on job search activities every day. I was also very serious about the hours spent on exercises, running, talking to family and friends, and hobbies.</p><p>I hope you have some concise takeaways from this article to help you achieve your goal soon. Wish you success in your job search.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c37a35d7c656" width="1" height="1" alt=""><hr><p><a href="https://medium.com/data-science/how-did-i-get-a-data-analyst-job-during-the-pandemic-c37a35d7c656">How did I get a data analyst job during the pandemic?</a> was originally published in <a href="https://medium.com/data-science">TDS Archive</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>