data-inspired decision-making can discover

Course 2 – Ask Questions to Make Data-Driven Decisions Quiz Answers

Week 2: Data-Driven Decisions

GOOGLE DATA ANALYTICS PROFESSIONAL CERTIFICATION

Complete Study Guide

Data-Driven Decisions INTRODUCTION

Data-driven decision-making is a popular concept in the business world today. Google Data Analytics Professional Certificate offered by Coursera provides an interactive, comprehensive program that teaches participants how to leverage data and analytics to make informed decisions. It covers topics such as data collection, visualization, analysis, and interpretation, helping learners gain valuable skills that can be used to develop effective strategies for their organization.

Through this course, you will learn how to accurately identify patterns from large datasets and draw meaningful insights from them. You will also develop the ability to present your data through reports and dashboards that are clear and concise for stakeholders. By taking this course, you will become a more informed analyst and be able to make decisions confidently based on data-driven evidence.

Learning Objectives

  • Discuss the use of data in the decision-making process
  • Compare and contrast data-driven decision making with data-inspired decision making
  • Explain the difference between quantitative and qualitative data including reference to their use and specific examples
  • Discuss the importance and benefits of dashboards and reports to the data analyst with reference to Tableau and spreadsheets
  • Differentiate between data and metrics, giving specific examples
  • Demonstrate an understanding of what is involved in using a mathematical approach to analyze a problem

Test your knowledge on the power of Data

1. What is the difference between qualitative and quantitative data?

  • Qualitative data can be used to measure qualities and characteristics. Quantitative data can be used to measure numerical facts. (Correct)
  • Qualitative data describes the kind of data being analyzed. Quantitative data describes how much data is being analyzed.
  • Qualitative data is about the quality of a product or service. Quantitative data is about how much of that product or service is available.
  • Qualitative data is specific. Quantitative data is subjective.

Correct: Qualitative data can be used to measure qualities and characteristics. Quantitative data can be used to measure numerical facts.

2. Fill in the blank: Data-inspired decision-making can discover _____ when exploring different data sources.

  • if a decision was properly made
  • which experts can give advice
  • where the largest amount of data is
  • what the data has in common (Correct)

Correct: Data-inspired decision-making deals with exploring different data sources to discover what they have in common.

3. Which of the following examples describes using data to achieve business results? Select all that apply.

  • A movie theater tracks the number of weekend movie goers for three months.
  • A large retailer performs data analysis on product purchases to create better promotions. (Correct)
  • A video streaming service analyzes user preferences to customize movie recommendations. (Correct)
  • A grocery chain collects data on sale items and pricing from each store.

Correct: Analyzing user preferences to customize movie recommendations and analyzing product purchases to create better promotions are examples of using data to achieve business results. These examples demonstrate putting analysis to work to achieve business results.

4. If someone is subjectively describing their feelings or emotions, it is qualitative data.

  • True (Correct)
  • False

Correct: If someone is describing their feelings or emotions, they are providing qualitative data. Qualitative data is a subjective and explanatory measure of a quality or a characteristic.

Test your knowledge on following the evidence

1. Fill in the blank: Pivot tables in data processing tools are used to _____ data.

  • populate
  • validate
  • clean
  • summarize (Correct)

Correct: Pivot tables are used to summarize data.

2. In data analytics, how are dashboards different from reports?

  • Dashboards provide a high-level presentation of historical data. Reports provide a more detailed presentation of live, interactive data.
  • Dashboards monitor live, incoming data from multiple datasets and organize the information into one central location. Reports are static collections of data. (Correct)
  • Dashboards are used to share updates with stakeholders only periodically. Reports give stakeholders continuous access to data.
  • Dashboards contain static data. Reports contain data that is constantly changing.

Correct: Dashboards monitor live, incoming data from multiple datasets and organize the information into one central location. Reports are static collections of data.

3. Describe the difference between data and metrics.

  • Data is a collection of facts. Metrics are quantifiable data types used for measurement. (Correct)
  • Data can be used for measurement. Metrics cannot be used for measurement.
  • Data is quantifiable and used for measurement. Metrics are unorganized collections of facts.
  • Data is quantifiable. Metrics are unquantifiable.

Correct: Data is a collection of facts. Metrics are quantifiable data types used for measurement.

4. Return on Investment (ROI) uses which of the following metrics in its definition?

  • Sales and margin
  • Supply and demand
  • Profit and investment (Correct)
  • Inventory and units

Correct: Return on Investment (ROI) = Profit/Investment.

Test your knowledge on connecting data dots

1. Describe the key differences between small data and big data. Select all that apply.

  • Small data is effective for analyzing day-to-day decisions. Big data is effective for analyzing more substantial decisions. (Correct)
  • Small data involves datasets concerned with a small number of specific metrics. Big data involves datasets that are larger and less specific. (Correct)
  • Small data focuses on short, well-defined time periods. Big data focuses on change over a long period of time. (Correct)
  • Small data is typically stored in a database. Big data is typically stored in a spreadsheet.

Correct: Small data involves a small number of specific metrics over a shorter period of time. It’s effective for analyzing day-to-day decisions. Big data involves larger and less specific datasets and focuses on change over a long period of time. It’s effective for analyzing more substantial decisions.

2. Which of the following is an example of small data?

  • The trade deficit between two countries over a hundred years
  • The total absences of all high school students
  • The bed occupancy rate for a hospital for the past decade
  • The number of steps someone walks in a day (Correct)

Correct: The number of steps someone walks in a day is an example of small data.

3. The amount of exercise time it takes for a single person to burn a minimum of 400 calories is a problem that requires big data.

  • True
  • False (Correct)

Correct: This problem can be solved using small data. It contains a specific metric (400 calories) and a short, defined period of time (amount of exercise time).

GOOGLE DATA ANALYTICS COURSERA ANSWERS AND STUDY GUIDE

Liking our content? Then don’t forget to add us to your bookmarks so you can find us easily!

Weekly Breakdown | Google Study Guides | Back to Top

Ask Questions to Make Data-Driven Decisions Weekly Challenge 2

1. In data analytics, a pattern is defined as a process or set of rules to be followed for a specific task.

  • True
  • False (Correct)

Correct: In data analytics, an algorithm is defined as a process or set of rules to be followed for a specific task.

2. In data analytics, quantitative data measures qualities and characteristics.

  • True
  • False (Correct)

Correct: In data analytics, quantitative data is specific and measures numerical facts.

3. In data analytics, dashboards monitor data that is a continuous source of incoming information. Which of the following terms describes this type of data?

  • Comprehensive
  • Live (Correct)
  • Filtered
  • Sorted

Correct: Live data is a continuous source of incoming information.

4. Fill in the blank: A _____ is a data-summarization tool used to sort, reorganize, group, count, total, or average data.

  • dashboard
  • pivot table (Correct)
  • function
  • report

Correct: A pivot table is a data summarization tool used to sort, reorganize, group, count, total, or average data.

5. What is an example of using a metric? Select all that apply.

  • Using column headers to sort and filter data
  • Using a pie chart to visualize data
  • Using key performance indicators, such as click-through rates, to measure revenue  (Correct)
  • Using annual profit targets to set and evaluate goals (Correct)

Correct: Using key performance indicators to measure revenue and using annual profit targets to set and evaluate goals are examples of using metrics.

6. Fill in the blank: A _____ goal is measurable and evaluated using single, quantifiable data.

  • metric (Correct)
  • benchmark
  • finite
  • conceptual

Correct: A metric goal is measurable and evaluated using single, quantifiable data.

7. If a data analyst compares the cost of an investment to the net profit of that investment over a period of time, they’re analyzing the investment scope.

  • True
  • False (Correct)

Correct: If a data analyst compares the cost of an investment to the net profit of that investment over a period of time, they’re analyzing the return on investment.

8. Describe the main differences between big and small data.

  • Small data is specific and concerns a short time period. Big data is less specific and concerns a longer time period. (Correct)
  • Small data has been cleaned and sorted. Big data has not yet been cleaned or sorted.
  • Small data is less useful to data analysts. Big data is more useful to data analysts.
  • Small data is typically stored and organized in databases. Big data is typically stored and organized in spreadsheets.

Correct: Small data is specific and concerns a short time period. Big data is less specific and concerns a longer time period.

9. Which of the following statements describes an algorithm?

  • A tool that enables data analysts to spot something unusual
  • A process or set of rules to be followed for a specific task (Correct)
  • A method for recognizing the current problem or situation and identifying the options
  • A technique for focusing on a single topic or a few closely related ideas

Correct: A process or set of rules to be followed for a specific task describes an algorithm.

10. In data analytics, reports use live, incoming data from multiple datasets; dashboards use static collections of data.

  • True
  • False (Correct)

Correct: Dashboards monitor live, incoming data from multiple datasets; reports use static collections of data.

11. Which data-summarization tool do data analysts use to sort, reorganize, group, count, total, or average data?

  • A dashboard
  • A function
  • A report
  • A pivot table (Correct)

Correct: To sort, reorganize, group, count, total or average data, data analysts use a pivot table.

12. A metric is a single, quantifiable type of data that can be used for what task?

  • Sorting and filtering data
  • Setting and evaluating goals (Correct)
  • Defining a problem type
  • Cleaning data

Correct: A metric is a single, quantifiable type of data used when setting and evaluating goals.

13. Fill in the blank: Return on investment compares the cost of an investment to the _____ of that investment.

  • future success
  • purpose
  • timing
  • net profit (Correct)

Correct: Return on investment compares the cost of an investment to the net profit gained from that investment.

14. A data analyst is using data from a short time period to solve a problem related to someone’s day-to-day decisions. They are most likely working with small data.

  • True (Correct)
  • False

Correct: A data analyst using data from a short time period to solve a problem related to someone’s day-to-day decisions is most likely working with small data.

15. Fill in the blank: In data analytics, a process or set of rules to be followed for a specific task is _____.

  • a domain
  • a value
  • an algorithm (Correct)
  • a pattern

Correct: In data analytics, a process or set of rules to be followed for a specific task is an algorithm.

16. Fill in the blank: A metric goal is a _____ goal set by a company that is evaluated using metrics.

  • conceptual
  • measurable (Correct)
  • finite
  • theoretical

Correct: A metric goal is a measurable goal set by a company that is evaluated using metrics.

17. Fill in the blank: In data analytics, qualitative data _____. Select all that apply.

  • measures numerical facts
  • is subjective (Correct)
  • is always time bound
  • measures qualities and characteristics (Correct)

Correct: A metric goal is a measurable goal set by a company that is evaluated using metrics.

18. A metric is a specific type of data that companies use to identify a problem domain.

  • True
  • False (Correct)

Correct: A metric is a single, quantifiable type of data used when setting and evaluating goals.

19. In data analytics, reports use data that doesn’t change once it’s been recorded. Which of the following terms describes this type of data?

  • Comprehensive
  • Static (CORRECT)
  • Real-time
  • Monitored

Correct: Static data is data that doesn’t change once it’s been recorded.

20.  Fill in the blank: A data analyst is using data to address a large-scale problem. This type of analysis would most likely require _____. Select all that apply.

  • data represented by a limited number of metrics
  • small data
  • data that reflects change over time (CORRECT)
  • big data (CORRECT)

Correct: A data analyst using data to address a large-scale problem would most likely require big data that reflects change over time. 

Correct: A data analyst using data to address a large-scale problem would most likely require big data that reflects change over time. 

21.  A pivot table is a data-summarization tool used in data processing. Which of the following tasks can pivot tables perform? Select all that apply.

  • Clean data
  • Calculate totals from data (CORRECT)
  • Reorganize data (CORRECT)
  • Group data (CORRECT)

Correct: Pivot tables are used to reorganize, group, and calculate totals from data.

Correct: Pivot tables are used to reorganize, group, and calculate totals from data.

Correct: Pivot tables are used to reorganize, group, and calculate totals from data.

22 Fill in the blank: Return on investment compares the _____ of an investment to the net profit gained from that investment. 

  • Cost (CORRECT)
  • timing
  • success
  • purpose

Correct: Return on investment compares the cost of an investment to the net profit gained from that investment.

23. Which of the following options describes a metric goal? Select all that apply. 

  • Indefinite
  • Based on theory
  • Evaluated using metrics (CORRECT)
  • Measurable (CORRECT)

Correct: A metric goal is a measurable goal set by a company that is evaluated using metrics.

Correct: A metric goal is a measurable goal set by a company that is evaluated using metrics.

24. A data professional at a retail store automates a process to identify their company’s best-selling products. First, a list of all products is compiled. Then, the number of times they have been sold is counted. Finally, the products are sorted, with best-sellers at the top. What does this scenario describe?

  • Creating an algorithm (CORRECT)
  • Using a formula
  • Data-inspired decision-making
  • Making a pivot table

Correct!

25. Which of the following statements accurately describe qualitative and quantitative data? Select all that apply.

  • The weight of a cruise ship is an example of qualitative data.
  • The texture of a wool sweater is an example of quantitative data.
  • Qualitative data describes explanatory assessments of qualities. (CORRECT)
  • Quantitative data involves specific and objective measures. (CORRECT)

Correct!

26. When working with big data, analysts consider the veracity of the data within large, complex datasets. What does this entail?

  • Assessing the amount of data included
  • Evaluating the quality and reliability of the data
  • Understanding how quickly the data can be processed
  • Identifying the different kinds of data available (CORRECT)

Correct!

27. A data professional uses a spreadsheet tool to create a visualization that totals productivity data by organization, department, and employee. What tool are they using?

  • Pivot table (CORRECT)
  • Format
  • Data validation
  • Sort

Correct!

28. Company decision-makers at a gas utility want to improve business performance. How could they use metrics and a metric goal to help them do so?

  • Establish a metric goal as a single data point. Then, quantify it with metrics.
  • Set a metric as the business objective. Then, quantify it using numerous data points.
  • Develop a metric. Then, evaluate it to determine whether it advances performance.
  • Create a metric goal as the business objective. Then, evaluate it using metrics. (CORRECT)

Correct!

29. Which of the following statements correctly describe dashboards and reports? Select all that apply.

  • Reports offer ongoing access to dynamic information.
  • An HR dashboard could be used to track employee hours worked daily. (CORRECT)
  • A dashboard enables stakeholders to monitor live, incoming data. (CORRECT)
  • Reports are useful for data visualization. (CORRECT)

Correct!

30. Fill in the blank: ROI is calculated by comparing the two metrics of _____, enabling a company to determine the success of the investment.

  • investment cost and profit (CORRECT)
  • value and expenses
  • sales and revenue
  • gross margin and net margin

Correct!

31. What are some typical challenges that may be faced by businesses that are beginning to collect and use big data? Select all that apply.

  • Cannot help large organizations spot trends
  • Less efficient decision-making time frames (CORRECT)
  • Difficulty finding important data (CORRECT)
  • There may be gaps in big data business tools (CORRECT)

Correct!

32. A data analyst at a staffing agency automates a process to schedule temporary employees. First, a list of all employees is compiled. Then, they are sorted by availability, area of expertise, and past performance ratings. Finally, employees for each open position are listed. What does this scenario describe?

  • Making a pivot table
  • Data-inspired decision-making
  • Using a formula
  • Creating an algorithm (CORRECT)

Correct!

33. A data team uses a spreadsheet tool to create a visualization that summarizes financial data by region, facility, and time period. What tool are they using?

  • Format
  • Sort
  • Data validation
  • Pivot table (CORRECT)

Correct!

34. Company leaders at a cafeteria supplier want to improve business performance. How could they use metrics and a metric goal to help them do so?

  • Develop a metric. Then, evaluate it to determine whether it advances performance.
  • Establish a metric goal as a single data point. Then, quantify it with metrics.
  • Set a metric as the business objective. Then, quantify it using numerous data points.
  • Create a metric goal as the business objective. Then, evaluate it using metrics. (CORRECT)

Correct!

35. Which of the following statements correctly describe dashboards and reports? Select all that apply.

  • Reports provide continual access to information. 
  • A sales dashboard could be used to track daily e-commerce sales. (CORRECT)
  • Dashboards are useful for data visualization. (CORRECT)
  • A report is a static collection of data given to stakeholders periodically. (CORRECT)

Correct!

36. What are some typical challenges that may be faced by businesses that are beginning to collect and use big data? Select all that apply.

  • Inappropriate for use by large organizations
  • Needed data may be inaccessible (CORRECT)
  • Having too much unimportant information (CORRECT)
  • Technology may not provide reportable data (CORRECT)

Correct!

36. A junior data analyst uses a spreadsheet tool to create a visualization that groups and counts shipping data by carrier, route, and trip length. What tool are they using?

  • Format
  • Pivot table (CORRECT)
  • Data validation
  • Sort

Correct!

37. Fill in the blank: A company determines the _____ of an investment using ROI, which is calculated by comparing the two metrics of investment cost and profit.

  • expense
  • difficulty
  • urgency
  • success (CORRECT)

Correct!

38. Fill in the blank: A company determines the success of an investment using _____, which is calculated by comparing the two metrics of investment cost and profit.

  • reasoning on investment
  • retention of investment
  • rating of investment
  • return on investment (CORRECT)

Correct!

39. What are some typical challenges that may be faced by businesses that are beginning to collect and use big data? Select all that apply.

  • Cannot help large organizations spot trends
  • Less efficient decision-making time frames (CORRECT)
  • There may be gaps in big data business tools (CORRECT)
  • Difficulty finding important data (CORRECT)

Correct!

40. What is the relationship between a metric and a metric goal?

  • A metric goal is a business objective that is evaluated using metrics.
  • A metric is a goal that is set and evaluated by a business. (CORRECT)
  • A metric goal is a single data point that is quantified with metrics.
  • A metric is a business goal that is evaluated using numerous data points.

Correct!

Data-Driven Decisions CONCLUSION

Learning about data and its impact on analytics decisions is crucial in the business world. The Coursera course “Data-Driven Decision Making” dives into all different types of data and how it can be used to make informed choices in businesses. You’ll learn practical skills that you can use in your own career, including how to share data through reports and dashboards. Join the learning experience today!