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

Thinkful Bootcamp Success Stories | Zack | Data Analytics

Thinkful Bootcamp Success Stories | Zack | Data Analytics

Looking for advice on how to become a Data Scientist? Zach Berman was a research specialist who saw his work increasingly taken over by automation, and knew he had to get ahead of the curve. After trying to learn solo, he looked for a more structured path, and found that Thinkful was the top of every list for bootcamps. He took Data Science Flex, scored a job as a data analyst at Home Depot, and found the things he studied at Thinkful put him ahead of analysts who had been there for many years. Now, he’s working for a big name company in a field that’s only continuing to grow.

Data Science
Immersion —
Flex —

Data Analytics
Immersion —
Flex —

Source. First Published on YouTube

Growth Hacking Articles

How to Become A Data Analyst | Data Analyst Career Path | For Beginners

How to Become A Data Analyst | Data Analyst Career Path | For Beginners

Learn more about a Data Analyst with an example:

In this video, we will learn what are the skills required to choose Data Analyst as a Career option for one. Also, we will look at the scope of a person who looks forward to working as a Data Analyst.

We will also look at the tools required for while working as a Data Analyst. And what education and Degrees are required in order to be a Data Analyst. Also in this video, the importance of Data Analyst in the corporate world is Discussed.

All the doubts Related to Data Analyst and Data Science are Discussed in detail in this video.
We discussed:
1. Business Analyst
2. Management Reporting
3. Corporate Strategy Analyst
4. Budget Analyst
5. Social Media Data Analyst
6. Data Analyst

How to Become A Data Analyst | Data Analyst Career Path
#DataAnalyst #DataScience #Promo

Like us on
Tweet us on
Follow our boards at

Source. First Published on YouTube

Growth Hacking Articles

Data Analytics Vs Business Analytics|Mechanical courses are good or not?| No Jobs in England|Student

Data Analytics Vs Business Analytics|Mechanical courses are good or not?| No Jobs in England|Student

Hello Dosto,
I will be covering various questions asked on my video!
There are no Jobs in the UK…Please do careful before come to UK or any other country for next 4-6 months…

Learn Python via Webex classes- We are offering CPD UK certified Python courses
New classes starting from 13th March-

Free Audio Book-

Awesome Data Science Bundle-

All my assumptions are based on my research,knowledge,experience and analysis around various factors..I will continue making my informative videos for Students.

Youtube Channel__ Student Help UK-

Instagram ID-
Facebook Group Link-

For any queries or concerns- email us at [email protected]

The main things covered in this Channel are:
1) Student life in England
2) Study in the UK or Study Abroad
3) Indian students
4) Informative videos for Students
5) Student living expenses
6) UK student news
8) International Students in England
9) Student life
10) Study in London
11) Study in England

And some other main things about this channel are Indian Vlogger in England,
Indian Youtube in England which shows various activities around the UK,
Student life in England,
How Students in England should choose the Course,
Indian Students in England,
Indian Students Life in England,

The main things covered in this video are:
1. Indian Vlogger in England
2. Indian Youtube in England which shows various activities around the UK.
3. Student life in England
4. How Students in England should choose the Course
5. Indian Students in England
6. Indian Students Life in England

As you know I am not an immigration consultant therefore any content on my channel is based on my research, knowledge and experience. Please use any information at your own risk and I don’t take any responsibility if anything happens due to my information.
Also, any replies on your comments are also based on my personal research and experiences therefore please use it at your own risk. Anyways I always try to keep my information as accurate as possible.

P.S- I am not a Solicitor or Visa Consultant or Legal Advisor.. therefore please don’t ask me these information..
Also, I always try to share any information based on my research, knowledge and experience.

Please do subscribe this Channel!

Many thanks,
Student Help UK

Source. First Published on YouTube

Growth Hacking Articles

Data Analytics Jobs, Salary, Resume, Career, Skills, Roles & Responsibilities | Simplilearn

Data Analytics Jobs, Salary, Resume, Career, Skills, Roles & Responsibilities | Simplilearn

This Data Analytics video talks about the Data Analytics job growth and the top 6 Data Analytics job roles – Data Analyst, Business Analyst, Database Administrator, Data Engineer, Data Scientist, and Machine Learning Engineer. The growth of data has brought with it several job opportunities as organizations are always on the lookout for professionals who can draw meaningful insights from raw data and help businesses in crucial decision making. Hence, a career in this field is up-and-coming. This video will help you have an understanding of the various responsibilities, skills required, and the salary structure of each of the job role. You will also see the multiple companies hiring each of these professionals. Finally, we will show you a sample resume of a Data Analyst.

You will learn the below topics in this Data Analytics Jobs:
1. The Growth of Data – 0:30
2. Job role of a Data Analyst – 3:30
3. Job role of a Business Analyst – 6:43
4. Job role of a Database Administrator – 9:43
5. Job role of a Data Engineer – 12:21
6. Job role of a Data Scientist – 14:45
7. Job role of a Machine Learning Engineer – 17:56
8. Resume of a Data Analyst – 20:42

For more videos on Data Analytics, check our playlist:

To learn more about Data Analytics, subscribe to our YouTube channel:

To access slides, click here:

#DataAnalytics #DataAnalyst #DataAnalyticsJob #BusinessAnalyst #DataAnalyticsSalary #DataAnalyticsRolesAndResponsibilities #DataAnalystResume #Simplilearn

This Data Analyst Master’s Program in collaboration with IBM will make you an expert in data analytics. In this Data Analytics course, you’ll learn analytics tools and techniques, how to work with SQL databases, the languages of R and Python, how to create data visualizations, and how to apply statistics and predictive analytics in a business environment.

What are the learning objectives?
Simplilearn’s Data Analyst Master’s Program developed in collaboration with IBM will provide you with extensive expertise in the booming data analytics field. This data analytics certification training course will teach you how to master descriptive and inferential statistics, hypothesis testing, regression analysis, data blending, data extracts, and forecasting. Through this course, you will also gain expertise in data visualization techniques using Tableau and Power BI, learning how to organize data and design dashboards. In this data analyst certification online course, a special emphasis is placed on those currently employed in the non-technical workforce. Through this Data Analytics course, those with a basic understanding of mathematical concepts will be able to complete the course and become an expert in data analytics. This learning experience melds the knowledge of Data Analytics with hands-on demos and projects via CloudLab. Upon completing this course, you will have all the skills required to become a successful data analyst.

Why become Data Analyst?
By 2020, the World Economic Forum forecasts that data analysts will be in demand due to increasing data collection and usage. Organizations view data analysis as one of the most crucial future specialties due to the value that can be derived from data. Data is more abundant and accessible than ever in today’s business environment. In fact, 2.5 quintillion bytes of data are created each day.

The facts are that professionals who enter the Data Science field will have their pick of jobs and enjoy lucrative salaries. According to an IBM report, data and analytics jobs are predicted to increase by 15 percent to 2.72 million jobs by 2020, with the most significant demand for data analysts in finance, insurance, and information technology. Data analysts earn an average pay of $67,377 in 2019 according to Glassdoor.

Who should take up this course?
Aspiring professionals of any educational background with an analytical frame of mind are best suited to pursue the Data Analyst Master’s Program, including:
1. IT professionals
2. Banking and finance professionals
3. Marketing managers
4. Sales professionals
5. Supply chain network managers

Learn more at:

For more information about Simplilearn courses, visit:
– Facebook:
– Twitter:
– LinkedIn:
– Website:

Get the Android app:
Get the iOS app:

Source. First Published on YouTube

Growth Hacking Articles

What's New in the AWS Certified Data Analytics Exam

What's New in the AWS Certified Data Analytics Exam

Full course:

In this excerpt from our prep course on Udemy “AWS Certified Big Data Speciality 2020 – In Depth & Hands On”, we talk about the upcoming name change of the AWS Certified Big Data exam to AWS Certified Data Analytics coming in April 2020. I sat for the beta version of the new exam, and we’ve updated our course accordingly.

You’ll find there is no longer a focus on machine learning in the new exam, but in its place is more depth on Glue ETL, Redshift, Quicksight, and new features like S3 Select and Amazon MSK. We’ll talk about it here.

Source. First Published on YouTube

Growth Hacking Articles

Live_Data, Analytics and AI

Live_Data, Analytics and AI

Presenter: Santhosh Mahendiran
Managing Director
Standard Chartered Bank, Singapore

Santhosh has 20 years of experience across Citi and Standard chartered bank. His area of specialisation and interests are Data, Analytics and AI.

About the Topic: What makes data and analytics so hot today

Source. First Published on YouTube

Growth Hacking Articles

Data Analyst vs Business Analyst | Salaries | Roles | Comparison

Data Analyst vs Business Analyst | Salaries | Roles | Comparison

Data Analyst vs Business Analyst seeks to answer your questions such as:

1. Who is a Business Analyst? – 1:11
2. Who is a Data Analyst? – 1:37
3. What is the skill set required for the Business Analyst? – 2:22
4. What is an ideal skill set of a Data Analyst? – 2:48
5. What is the typical job role of a Business Analyst? – 3:14
6. What are the roles and responsibilities of a Data Analyst? – 3:26
7. What is the salary earned in both professions? 3:41
8. Which top companies are recruiting a Data Analyst and Business Analyst? – 4:04

If you want to pursue Masters in Analytics and want to evaluate your profile to know your chances of being accepted by the top B-schools, then you can take our FREE Profile Evaluation through the link provided below:

A Business Analyst is a person who uses data to help organizations make informed business decisions while a Data Analyst is someone who collects, analyzes and interprets numeric data to turn it into meaningful language easily understood by people. This is then used by the upper management to make practical and concrete business decisions.

Their job profile may look similar in the sense that they both help in decision making but the role of each is different. Our Data Analyst vs Business Analyst video will help you understand major differences in two. Business Analyst’s main job role includes understanding the requirements of the business and then solving and optimizing the problems through data analysis. On the other hand, Data Analysts’ main tasks include gathering and manipulating the data using statistical tools and deducing them in forms of graphs, charts, and histograms.

Also, there is a difference between the skills set of data analysts and business analysts. The skills required by data analysts are more technical. It includes Data warehousing, programming knowledge such as Python and R language, Adobe and Google Analytics, SQL knowledge and database/spreadsheet knowledge. While an ideal skill set for a business analyst includes, analytical thinking skills, communication, and leadership skills.
However, both business analysts and data analysts should be problem-solvers and should have a good hand at Data Analysis.

Still not clear about the basic differences in Data Analyst vs Business Analyst and have few questions about this? You need not worry. Drop your queries in the comment section and we will surely get back to you.

Don’t forget to subscribe to our YouTube channel and follow us on Facebook, Instagram, and LinkedIn for the latest updates and tips.


Source. First Published on YouTube

Growth Hacking Articles

HR Analytics and How to Get Started

HR Analytics and How to Get Started

HR analytics can help save you money, cut down on wasted time, and hire talent for the right skills.

►► To access the full list of tools, click here:

As a recruiter or HR manager, you know that HR departments collect vast amounts of HR data. Unfortunately, this data remains unused.

Keeping records is insufficient to add strategic value in both hiring and performance.

But how do you get started?

Growth Tribe’s Jayla Cosentino takes us through the 3 most important metrics to track through the hiring cycle. Ranging from tools teams can use to track these metrics to initiatives that support build a fantastic team!

First things first – HR analytics.

While there are hundreds of things you can track, we will focus on three important ones to get you started.

First is reducing the time to hire

Every vacancy has an average time to hire, but tracking this metric can help you identify the pain points in the recruitment funnel.

Second is sourcing statistics.

There are different analytics you can look into when it comes to sourcing.

However, there is no point in looking at the other analytics if you don’t know which channel brings you the highest quality of candidates.

Finally, there’s the recruitment funnel effectiveness.

We can cover every step of the funnel, but instead, let’s talk about the critical metrics of your website-to applicant conversion rate.

That’s the top of funnel!

HR analytics can be overwhelming, but it does not have to be!

Begin with what you believe is your most important metrics and then start collecting the data!


Amsterdam bound?

Want to make AI your secret weapon? Join our A.I. for Marketing and growth Course! A 2-day course in Amsterdam. No previous skills or coding required!


Check out our 2-day intensive, no-bullshit, skills and knowledge Growth Hacking Crash Course:


our 6-Week Growth Hacking Evening Course:


Our In-House Training Programs:


The world’s only Growth & A.I. Traineeship

Make sure to check out our website to learn more about us and for more goodies:

London Bound?

Join our 2-day intensive, no-bullshit, skills and knowledge Growth Marketing Course:


Connect with Growth Tribe on social media and stay tuned for nuggets of wisdom, updates and more:

Video URL:

#hranalytics #peopleanalytics #hrtools #howtohire #peoplemanagement

Source. First Published on YouTube

Growth Hacking Articles