profile pic Analytics
Upvote 0 Downvote
Metrics for Evaluating Outbound Warehouse Performance Data Analyst @ Amazon Difficulty medium

What kind of metrics do you want to monitor when you are taking charge of evaluating the business performance of an outbound warehouse?

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Ways to Eliminate Bottlenecks Data Analyst @ Amazon Difficulty medium

What are ways to eliminate bottlenecks?

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Handling Under-performing Predictive Models Data Analyst @ Apple Difficulty medium

How would you identify and address potentially under-performing predictive models in a production environment?

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Maximum IF Statements in Nested IF Conditions in Excel Data Analyst @ Microsoft Difficulty easy

What is the maximum number of IF statements you can nest within a single formula in Excel? Provide an example of a nested IF statement.

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
When to Use Mean vs. Median Data Analyst @ Google Difficulty easy

When is it appropriate to use mean versus median in data analysis? Provide specific examples where one measure may be preferred over the other.

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
SQL, Data Forecasting, Past Experiences Business Analyst @ Google Difficulty medium

You mentioned your proficiency with SQL and data forecasting. Can you describe a past experience where you used SQL to analyze data and generate a forecast? What challenges did you face, and how did you address them?

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Excel Background and Technical Proof Data Analyst @ Microsoft Difficulty easy

Using the dataset above, write an Excel formula to calculate the total sales made by each salesperson. Provide the calculated total sales for "John."

Input Data:

Consider a dataset in Excel with the following columns: `Salesperson`, `Product`, `Quantity`, and `Price`. 

**Data**
| A          | B      | C        | D      |
|------------|--------|----------|--------|
| Salesperson| Product| Quantity | Price  |
| John       | Widget | 10       | 15     |
| Jane       | Gadget | 5        | 20     |
| John       | Gizmo  | 7        | 30     |
| Alice      | Widget | 3        | 15     |
| Jane       | Gadget | 10       | 20     |
Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Estimating the Number of Websites on the Internet Data Analyst @ Google Difficulty medium

How many websites are on the internet? How would you find out the number?

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Understanding XYZ in Tableau @ Apple Difficulty easy

What is a xyz in Tableau and what does it do?

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Difference Between Extract and Live in Tableau Data Analyst @ Apple Difficulty easy

What is the difference between Extract and Live in Tableau?

Solution:

Please sign-in to view the solution

Upvote 0 Downvote
Difference Between WHERE and HAVING Filters in SQL Data Analyst @ Apple Difficulty easy

What is the difference between 'WHERE' and 'HAVING' filters in SQL? Provide an example to illustrate your point.

Solution:

Please sign-in to view the solution