How to prepare for a Data Analyst Interview [2020]

How to prepare for a Data Analyst Interview [2020]

5 Things to prepare before a Data Analyst interview:
In this video, we will go through the 5 things you need to prepare before a data analyst interview. Data analyst interview questions and answers & more.

1 – Research the Company & the Role
The first thing you should do, is simply go to the company’s website and read about the company. You should make notes about:
• What does the companies do?
• When it was founded and by whom?
• Who runs the company now; CEO name?
• What is the company’s mission & vision?
• What are the company’s core values?
• What industry is the company operating in? (tech? retail? Finance, etc)
• Who is the company trading with? Who are their clients / customers?
• Learn about what the analytics team you are about to join does

2 – Prepare for the most universal & frequently asked questions
There are some “universal” interview questions which apply to all roles (not just Data Analysts) and are almost always asked in interviews. Make sure you prepare for the following questions:
• Tell me about yourself?
o Talk about your academic background and focus on the data related modules / projects. Talk about your work experience with a focus on the analytical tasks you were performing. Close with a reason “why you are there”; which is obviously going to be that you love analytics and you love that company 😊.
• Why you want to join this company?
o Pick the “thing / project” that the company completed from their website and talk about how that “thing / project” excites you and makes you want to work for that firm
• Why you want to become a Data Analyst or pursue a career in data analytics?
o Pick a data related project or a data related task you were doing that you love doing it and talk about that
• What do you know about this company?
o Talk about what I mentioned in Step 1 (beginning of the article)
• Why should I hire you?
o Talk about all the data related skills you have and make sure you link them with what the Job Description asks the candidate to have. This “link” is crucial
• What are your strengths?
o Pick 2 / 3 data related strengths and talk about times you applied them
• What are your weaknesses?
o Pick a weakness which is not a major in data analytics like “I get nervous speaking in large groups” and make sure you talk about the steps you are taking / took to overcome this.

3 – Brush your technical skills
The majority of the data analyst interviews require you to take some sort of test; which is usually an Excel test. If you are applying to an experienced data analyst job then you will probably need to brush your SQL skills too. For the Excel test, make sure you practice the following:
• Creating / sorting / filtering tables
• Aggregating data
• Summarizing data
• Creating graphs / charts
• VLookups
• Pivot Tables

4 – Prepare to speak about a “Data” project you completed
Even if you are not asked, try to find a way to talk about a data project you have completed either at University, on-line or during work experience. This is an opportunity to show the interviewer that you have experience working on data projects. Talk about the “problem formulation” phase, the data gathering phase, the cleaning phase, the transformation phase, the tools used for the analysis, the techniques you used for the analysis and the outcome of the project.

5 Bonus tip – Link all your answers with data related skills / tasks
Since you cannot possibly prepare for all possible questions, especially the ones about your previous work experience, you will need to make sure that you link all your answers to data related skills. For example, if the interviewer asks you to tell him about your work experience, make sure you flash out skills like communication skills, management skills, speak about the analytical tasks you were performing daily and the related tools like Excel. Don’ just say “I used to work as a “barman” and my job was to serve drinks. Expand on data related skills. I have made a video where I speak about the data related skills (link in the description).

Data Analytics Course Link:
Promo: “First100” for $50 off

Excel Tutorial Links:

SQL Tutorial Links:

Yiannis Pitsillides on Social Media:

Source. First Published on YouTube

Growth Hacking Articles

UX Design portfolio tips and how to prepare for internship interviews (Interview with Grace Dai)

UX Design portfolio tips and how to prepare for internship interviews (Interview with Grace Dai)

Grace Dai was a Product Design Intern on my team at Zendesk last summer and worked our Sunshine product team. Her internship portfolio presentation was one of the most memorable I’ve listened to, so I sat down with her to learn more about how she prepared for the interviews.

Grace was so generous and actually walks us through in detail the presentation version of one of her portfolio projects.

Huge thanks to Grace for this interview!



1. Instagram:
2. Twitter:
3. Patreon:
4. Website:

Make sure to check out the resources page on my website for my favorite free and low-cost resources on getting started in Product Design:

And if you’d like to chat with me about Product Design, your career, and anything in between book some time with me on Superpeer 🤙


Let me know if you have any questions about the programs below:

Springboard: Become a UX Designer. Job Guaranteed. Springboard’s programs are 6-9 month of online training in UX Design which includes personalized 1:1 mentorship with design experts from some of the top tech companies across the country. They guarantee you’ll get a job within 6 months of graduating or your money back.

$500 off Springboard’s UI/UX Design Career Track
Use my code at checkout: UIUXALEXA500
Quick link to the course:

$500 off Springboard’s UX Design Career Track
Use my code at checkout: UXALEXA500
Quick link to the course:

Designlab: Build your new career in UX design
Designlab’s UX Academy students receive world-class 1-on-1 online training in UX design, access to a vibrant community, and help landing that first product design job. No design experience? Join one of their rigorous 4-week Design 101 online courses! Students are paired with Designlab mentors to learn the fundamentals of design.

Quick link to the course:


I’m a digital Product Designer, Community Manager, YouTuber, amateur photographer, and basketballer. I’ve been living in the San Francisco Bay Area since 2012 and have dedicated my life to designing technology and experiences in order to help maximize human potential. I believe that meaning comes from making, emotion is the force of life, and as long as you’re creative enough, playful enough and determined enough — that you can get through to anybody.

I draw inspiration from a lot of people. Here’s a short list of some of my favorites:

My motto: Practice happy, practice often



If you’d like to sponsor a video or get in touch email: [email protected]

Disclaimer: Links included in this description might be affiliate links. If you purchase a product or service with one of these links, I may receive a small commission. This is at no additional charge to you. Thank you for supporting my work and Hello, I’m Alexa! so I can continue to provide you with great content.

Source. First Published on YouTube

Growth Hacking Articles

Data analyst interview tips | How to prepare for data analyst interview

Data analyst interview tips | How to prepare for data analyst interview

In this video, I will cover some important tips that can help you crack data analyst interview. We will go over commonly asked questions, specific questions related to data analyst position, resume preparation tips, body language, behavioral questions and even how to get interview call in a first place.

How to prepare resume for data analyst:
Learn data analyst skills:
Data structures tutorials:

Specific questions for data analyst position:
Search through glassdoor questions: “Data analyst interview questions amazon” and prepare for specific questions asked in that company.,6_KO7,19_IP2.htm



Home Page

SEO In 2020: How To Prepare For Major Disruption (And Scale)

SEO In 2020: How To Prepare For Major Disruption (And Scale)

SEO is making a major shift going into 2020. With, Google Actions and increased competition, you need to have a cutting edge SEO strategy. In this video, John Lincoln covers the most important things you need to focus on to get results. Some of the most important items for SEO are.

Google Actions. This is making a major change in SEO. Now all companies need to have a Google Action strategy.

Schema. This is now making a bigger impact than ever. Every website needs to have an SEO schema strategy.

Building a Brand. If you don’t have a great brand, then you can’t expect to rank well for SEO.

Voice Search. Voice search is going to be very important going into 2020.

Security. All websites needs to be secure for SEO, otherwise they will not show in chrome.

Page Speed. Page speed is very important as well, and Google will rank you higher if you have a faster website.

SEO on Other Websites. If you do SEO on other websites, you can get double the rankings.

International SEO. Now is the best time to do international SEO.

Now is a very exciting time for SEO. However, it is time to update your strategy. If you like this video, make sure to like, comment or leave a question below.

Learn more on our blog:
Ignite Visibility is a premier Internet marketing company based in San Diego, CA.

#digitalmarketing #internetmarketing


Home Page