What kind of metrics do you want to monitor when you are taking charge of evaluating the business performance of an outbound warehouse?
Please sign-in to view the solution
What are ways to eliminate bottlenecks?
Please sign-in to view the solution
What is the difference between Extract and Live in Tableau?
Please sign-in to view the solution
What is a xyz
in Tableau and what does it do?
Please sign-in to view the solution
How would you identify and address potentially under-performing predictive models in a production environment?
Please sign-in to view the solution
What is the difference between 'WHERE' and 'HAVING' filters in SQL? Provide an example to illustrate your point.
Please sign-in to view the solution
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 |
Please sign-in to view the solution
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.
Please sign-in to view the solution
When is it appropriate to use mean versus median in data analysis? Provide specific examples where one measure may be preferred over the other.
Please sign-in to view the solution
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?
Please sign-in to view the solution
How many websites are on the internet? How would you find out the number?
Please sign-in to view the solution