23. Scenario 2, continued
Next, your interviewer explains that one of their clients is an online retailer that has a vast inventory. She has a list of items by name, color, and size. Then, she has another list of the price of each item by size, as a larger item sometimes costs more. The client needs one list of all items by name, color, size, and price.
She then asks: If you were to use the CONCAT function to complete this task, what would it enable you to do?
24. Scenario 2, continued
For your final question, your interviewer explains that her team often uses the TRIM function when writing SQL queries.
She asks: What is the TRIM function used for in SQL?
25. Scenario 1, questions 1-5
You are a data analyst at a small analytics company. Your company is hosting a project kick-off meeting with a new client, Meer-Kitty Interior Design. The agenda includes reviewing their goals for the year, answering any questions, and discussing their available data.
Before the meeting you review the About Us tab on their website and their business plan, linked below:
Meer-Kitty Interior Design has two goals. They want to expand their online audience, which means getting their company and brand known by as many people as possible. They also want to launch a line of high-quality indoor paint to be sold in-store and online. You decide to consider the data about indoor paint first.
To use the template for the survey feedback, click the link below and select “Use Template.”
Link to template: Kitty Survey Feedback
If you don’t have a Google account, download the file directly from the attachment below.
When you refer to the Meer-Kitty survey feedback tab, you are pleased to find that the available data is aligned to the business objective. However, you do some research about confidence level for this type of survey and learn that you need at least 120 unique responses for the survey results to be useful. Therefore, the dataset has two limitations: First, there are only 40 responses; second, a Meer-Kitty superfan, User 588, completed the survey 11 times.
As the survey has too few responses and numerous duplicates that are skewing results, you decide to repeat the survey in order to create a new, improved dataset. What is your first step?
- Delete all of the data from the current, skewed survey.
- Write new, improved survey questions.
- Find a survey tool that only allows someone to complete the survey once.
- Talk with stakeholders, explain the new timeline, and ask for approval.