Solution provider

Recommended Courses: Coursera: Machine Learning Google Data Analytics Professional Certificate.   Scenario 1, questions 1-7 Question 1 As part of the data science team at Gourmet Analytics, you use data analytics to advise companies in the food industry. You clean, organize, and visualize data to arrive at insights that will benefit your clients. As a member of a collaborative team, sharing your analysis with others is an important part of your job. Your current client is Chocolate and Tea, an up-and-coming chain of cafes.

  Recommended Courses: Coursera: Machine Learning Google Data Analytics Professional Certificate.   4.Weekly challenge. Question 1 A data analyst gives a presentation about predicting upcoming investment opportunities. How does establishing a hypothesis help the audience understand their predictions? It provides context about the presentation’s purpose It visualizes the data clearly and concisely It describes the data thoroughly It summarizes the findings succinctly Establishing a hypothesis provides the audience with context about the analyst’s presentation. In this scenario, it establishes what the analyst wants to prove or disprove about which investment opportunities are most promising. Question 2 According to the McCandless Method, what is the most effective way to first present a data visualization to an audience? Introduce the graphic by name Answer obvious questions before they’re asked Tell the audience why the graphic matters State the insight of the graphic Accordin...

    Recommended Courses: Coursera: Machine Learning Google Data Analytics Professional Certificate.   4.Weekly challenge. Question 1 You are analyzing sales data in a spreadsheet. Which of the following could you find out by using the MAX function? The month with the highest sales Difference between two months of sales Sales per month over a year Total sales for the year You could find out the month with the highest sales using the MAX function. The MAX function returns the largest numeric value from a range of cells.   Question 2 A data analyst is working with a spreadsheet from a furniture company. Sample Transaction Table. The analyst inputs a function to find the number of product prices that are less than $150.00. Which formula will return that result? =COUNTIF(G2:G30, ">=150") =SUMIF(G2:G30, ">150") =SUMIF(G2:G30, "<150") =COUNTIF(G2:G30, "<150") The COUNTIF formula =COUNTIF(G2:G30, "<150") will allow the analyst to...

  Recommended Courses: Coursera: Machine Learning Google Data Analytics Professional Certificate. 4.Always remember the stakeholder. Scenario 1, questions 1-5 Question 1 You’ve just started a job as a data analyst at a small software company that provides data analytics and business intelligence solutions. Your supervisor asks you to kick off a project with a new client, Athena’s Story, a feminist bookstore. They have four existing locations, and the fifth shop has just opened in your community. Athena’s Story wants to produce a campaign to generate excitement for an upcoming celebration and introduce the bookstore to the community. They share some data with your team to help make the event as successful as possible. Your task is to review the assignment and the available data, then present your approach to your supervisor. Then, review the email, and review the Customer Survey and Historical Sales datasets: You may click the link to create a copy of the dataset: Customer Survey Yo...

  Recommended Courses: Coursera: Machine Learning. Google Data Analytics Professional Certificate. 5.Endless career possibilities. Question 1 Scenario 1, question 1-5 You’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...