iTECH PODCAST

10. Which technical tools have used for analysis and presentation purposes?

.....

Being a data analyst, you are expected to have knowledge of the below tools for data analysis and presentation purposes

The sample answer is…

1. Tableau

2. MS-Excel

3. MySql

4. Microsoft SQL server

5. SPSS - IBM platform

6. Python

7. Microsoft Powerpoint

---

This episode is sponsored by

· Anchor: The easiest way to make a podcast. https://anchor.fm/app

09. What are the various steps involved in any analytics projects?.... Data analytics projects involved in 5 important steps 1. Understand the problem, 2. Data collection, 3. Data cleaning, 4. Data exploration and analysis and 5. Interpret the result.

---

This episode is sponsored by

· Anchor: The easiest way to make a podcast. https://anchor.fm/app

08. What are the common problems that data analysts encounter during analysis?

There are four problems...

1. Handling duplicate and missing values

2. Collecting the meaningful right data and the Right time.

3. Making data secure and dealing with compliance issues.

4. Handling data purging and storage problems

---

This episode is sponsored by

· Anchor: The easiest way to make a podcast. https://anchor.fm/app

What is data wrangling in data analytics..?

Data wrangling is the very important topics in the data analytics field.

The answer is…

Data wrangling is the process of cleaning, structuring, enriching, validating and analyzing the raw data into a desired usable format for better decision making.

---

This episode is sponsored by

· Anchor: The easiest way to make a podcast. https://anchor.fm/app

06. What is the difference between data mining and data profiling?

.....

Both concepts are very important in data analytics . Don’t forget it. Interviewer asking this question in data analyst , business analyst and also data scientist interviews.

.....The answer is…

a.

Data mining – data mining is the process of finding relevant information which has not been found before

....a. Data profiling – data profiling is usually done to assess a dataset for its uniqueness, consistency and logic.

...b.

Data mining – it is the way in which raw data is turned into valuable information

....b.

Data profiling – it cannot indentify incorrect or inaccurate data values

---

This episode is sponsored by

· Anchor: The easiest way to make a podcast. https://anchor.fm/app

5. What are your communication strengths?

....

Communication is key in any position. Specifically, with a data analyst role, you will be expected to successfully present your findings and collaborate with the team. Assure them of your ability to communicate with an answer like this:

....That question answers is..... quest“My greatest communication strength would have to be my ability to relay information. I’m good at speaking in a simple, yet effective manner so that even people who aren’t familiar with the terms can grasp the overall concepts. I think communication is extremely valuable in a role like this, specifically when presenting my findings so that everyone understands the overall message.”

---

This episode is sponsored by

· Anchor: The easiest way to make a podcast. https://anchor.fm/app

4. Take a few minutes to explain how you would estimate how many tourists visit India every May?……

Many interviewers ask you this type of behavioral questions to see an analyst’s thought process without the help of computers and data sets. After all, technology is only as good and reliable as the people behind it. In your answer include: how you identified the variables, how you communicated them, and ideas you had to find the answer.

This example answer touches on all these points:

.......That questions answer is......

“First, I would gather data on how many people live in Paris, how many tourists visit in May, and their average length of stay. I’d break down the numbers by age, gender, and income, and find the numbers on how many vacation days and bank holidays there are in France. I’d also figure out if the tourist office had any data I could look at.”

---

This episode is sponsored by

· Anchor: The easiest way to make a podcast. https://anchor.fm/app

3. What was your most difficult data analysis project?.......

With a question like this, the interviewer is gaining insight into how you approach and solve problems. It also provides an idea of the type of work you have already done. Be sure to explain the event, action, and result (EAR), avoid blaming others, and explain why this project was difficult:

..............That question answer is.....

“My most difficult project was on endangered animals. I had to predict how many animals would survive to 2020, 2050, and 2100. Before this, I’d dealt with data that was already there, with events that had already happened. So, I researched the various habitats, the animal’s predators and other factors, and did my predictions. I have high confidence in the results.”

---

This episode is sponsored by

· Anchor: The easiest way to make a podcast. https://anchor.fm/app

There are many different types of data analyst, including operations analysts, marketing analysts, financial analysts, and more.

The answer is.....

I would prefer to work as a marketing analyst because it’s in line with my skills and interests. In addition, I have seen that the companies who hire for this role work in industries that are booming and can therefore provide good career growth.

---

This episode is sponsored by

· Anchor: The easiest way to make a podcast. https://anchor.fm/app

1. Why do you want to be a data analyst?

There are many roles out there for data analysts within various industries. This question will tell the interviewer about your thought process in choosing this role.

Answer is

“A data analyst’s job is to take data and use it to help companies make better business decisions. I’m good with numbers, collecting data, and market research. I chose this role because it encompasses the skills I’m good at, and I find data and marketing research interesting.”

---

This episode is sponsored by

· Anchor: The easiest way to make a podcast. https://anchor.fm/app