A data analyst is analyzing fruit and vegetable sales at a grocery store. They’re able to find data on everything except red onions. What’s the best course of action? 1 pointAsk a teammate for help finding data on red onions.Use the data on white onions instead, as they’re both onion varieties.Exclude red onions from the analysis. Exclude all onion varieties from the analysis.

Question 7A data analyst is analyzing fruit and vegetable sales at a grocery store. They’re able to find data on everything except red onions. If they exclude red onions from the analysis, this would be an example of creating or reinforcing bias.1 pointTrueFalse

Scenario 1, question 1-5You’ve just started a new job as a data analyst. You’re working for a midsized pharmacy chain with 38 stores in the American Southwest. Your supervisor shares a new data analysis project with you.She explains that the pharmacy is considering discontinuing a bubble bath product called Splashtastic. Your supervisor wants you to analyze sales data and determine what percentage of each store’s total daily sales come from that product. Then, you’ll present your findings to leadership.You know that it's important to follow each step of the data analysis process: ask, prepare, process, analyze, share, and act. So, you begin by defining the problem and making sure you fully understand stakeholder expectations.One of the questions you ask is where to find the dataset you’ll be working with. Your supervisor explains that the company database has all the information you need. Next, you continue to the prepare step. You access the database and write a query to retrieve data about Splashtastic. You notice that there are only 38 rows of data, representing the company’s 38 stores. In addition, your dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products). Considering the size of your dataset, what’s the best way to proceed with the process and analyze steps?1 pointDownload the data, then use a spreadsheet to process and analyze it.Use SQL to process and analyze the data.Upload the data, then process and analyze it using Tableau.Continue using the company database to process and analyze the data.

A data analyst is researching the buying behavior of people who shop at a company’s retail store and those who might shop there in the future. During the analysis, it will be important to stay in communication with the people who most often interact with these shoppers. They are members of the executive team.1 pointTrueFalse

Question 4Data analysts act as detectives to uncover clues within the data. Like a detective, a data analyst may use their _______ to solve business problems. Select all that apply.1 pointrational thoughtpersonal opiniongut instinctawareness

A data professional considers how they can best manage the key elements of an analysis project. They confirm that team members know how to use the right data, ensure there’s a clear path to a solution, and check that the right technology is in place. Which analytical skill does this scenario describe?1 pointData strategyUnderstanding contextTechnical mindsetCuriosity