What are your long-term goals?

Knowing what the company wants will help you emphasize your ability to solve their problems. Do not discuss your personal goals outside of work, such as having a family or traveling around the world, in response to this question. This information is not relevant.”

Instead, stick to something work-related like this:

“My long-term goals involve growing with a company where I can continue to learn, take on additional responsibilities, and contribute as much value as I can. I love that your company emphasizes professional development opportunities. I intend to take advantage of all of these.”

Which imputation method is more favorable?

Although single imputation is widely used, it does not reflect the uncertainty created by missing data at random. So, multiple imputation is more favorable then single imputation in case of data missing at random.

How many years of SQL programming experience do you have? In your latest job, how many of your analytical projects involved using SQL?

SQL is considered as one of the easiest scripting languages to learn. So, if you want to be competitive on the job market as a Data Analyst, you should be able to demonstrate excellent command of SQL. Even if you don’t have many years of experience, highlight how your skills have improved with each new project.

Example
“I’ve used SQL in at least 80% of my projects over a period of 5 years. Of course, I’ve also turned to other programming languages for the different phases of my projects. But, all in all, it’s SQL that I’ve utilized the most and consider the best for most of my data analyst tasks.”

Can you tell how to create stories in Tableau?

Stories are used to narrate a sequence of events or make a business use-case. The Tableau Dashboard provides various options to create a story. Each story point can be based on a different view or dashboard, or the entire story can be based on the same visualization, just seen at different stages, with different marks filtered and annotations added.

To create a story in Tableau you can follow the below steps:

Click the New Story tab.
In the lower-left corner of the screen, choose a size for your story. Choose from one of the predefined sizes, or set a custom size, in pixels.
By default, your story gets its title from its sheet name. To edit it, double-click the title. You can also change your title’s font, color, and alignment. Click Apply to view your changes.
To start building your story, drag a sheet from the Story tab on the left and drop it into the center of the view.
Click Add a caption to summarize the story point.
To highlight a key takeaway for your viewers, drag a text object over to the story worksheet and type your comment.
To further highlight the main idea of this story point, you can change a filter or sort on a field in the view, then save your changes by clicking Update above the navigator box.

Name the different data validation methods used by data analysts.

There are many ways to validate datasets. Some of the most commonly used data validation methods by Data Analysts include:

Field Level Validation – In this method, data validation is done in each field as and when a user enters the data. It helps to correct the errors as you go.
Form Level Validation – In this method, the data is validated after the user completes the form and submits it. It checks the entire data entry form at once, validates all the fields in it, and highlights the errors (if any) so that the user can correct it.
Data Saving Validation – This data validation technique is used during the process of saving an actual file or database record. Usually, it is done when multiple data entry forms must be validated.
Search Criteria Validation – This validation technique is used to offer the user accurate and related matches for their searched keywords or phrases. The main purpose of this validation method is to ensure that the user’s search queries can return the most relevant results.

What are the steps involved in a data analytics project?

The fundamental steps involved in a data analysis project are –

Understand the Business
Get the data
Explore and clean the data
Validate the data
Implement and track the data sets
Make predictions
Iterate

How can we select all blank cells in Excel?

If you wish to select all the blank cells in Excel, then you can use the Go To Special Dialog Box in Excel. Below are the steps that you can follow to select all the blank cells in Excel.

First, select the entire dataset and press F5. This will open a Go To Dialog Box.
Click the ‘Special‘ button which will open a Go To special Dialog box.
After that, select the Blanks and click on OK.
The final step will select all the blank cells in your dataset.

Explain what is logistic regression?

Logistic regression is a statistical method for examining a dataset in which there are one or more independent variables that defines an outcome.

How will you create a classification to identify key customer trends in unstructured data?

A model does not hold any value if it cannot produce actionable results, an experienced data analyst will have a varying strategy based on the type of data being analysed. For example, if a customer complain was retweeted then should that data be included or not. Also, any sensitive data of the customer needs to be protected, so it is also advisable to consult with the stakeholder to ensure that you are following all the compliance regulations of the organization and disclosure laws, if any.

You can answer this question by stating that you would first consult with the stakeholder of the business to understand the objective of classifying this data. Then, you would use an iterative process by pulling new data samples and modifying the model accordingly and evaluating it for accuracy. You can mention that you would follow a basic process of mapping the data, creating an algorithm, mining the data, visualizing it and so on. However, you would accomplish this in multiple segments by considering the feedback from stakeholders to ensure that you develop an enriching model that can produce actionable results.

What is data visualization?

In simpler terms, data visualization is a graphical representation of information and data. It enables the users to view and analyze data in a smarter way and use technology to draw them into diagrams and charts.