Which of the following terms refers to the collection transformation and organization of data in order to draw conclusions make predictions and DR?

Coursera – STUDY GUIDE

Click To Enroll in Coursera

Show

INTRODUCING DATA ANALYTICS

CONTENT

Data helps us make decisions in everyday life and in business. In this first part of the course, you’ll learn how data analysts use data analytics and the tools of their trade to inform those decisions. You’ll also discover more about this course and the overall program expectations.

Learning Objectives

  • Define key concepts involved in data analytics including data, data analysis, and data ecosystem
  • Discuss the use of data in everyday life decisions
  • Identify the key features of the learning environment and their uses
  • Describe principles and practices that will help to increase one’s chances of success in this certificate
  • Explain the use of data in organizational decision-making
  • Describe the key concepts to be discussed in the program, including learning outcomes

OPTIONAL: FAMILIAR WITH DATA ANALYTICS? – TAKE OUR DIAGNOSTIC QUIZ

1. A clothing retailer collects and stores data about its sales revenue. Which of the following would be part of its data ecosystem? Select all that apply.

  • The databases of competing retailers (Correct)
  • The cloud that stores its database (Correct)
  • Records of its inventory (Correct)
  • The database of sales revenue

2. What is the process of guiding business strategy using facts?

  • Data-driven decision-making (Correct)
  • Analytical planning
  • Strategic improvement
  • Identification of data and decisions

3. Fill in the blank: Curiosity, understanding context, having a technical mindset, data design, and data strategy are _____. They enable data analysts to solve problems using facts.

  • Analytical skills (Correct)
  • Business skills
  • Personal insights
  • Thought processes

4. The owner of a skate shop notices that every time a certain employee has a shift, there are higher sales numbers at the end of the day. After some investigation, the owner realizes that since the employee was hired, the store earns 15% more each month. In this scenario, the manager used which quality of analytical thinking?

  • Visualization
  • Correlation (Correct)
  • Problem-orientation
  • Big-picture thinkingIncorrectYou didn’t select an answer.

5. Gap analysis is a process that could help accomplish which of the following tasks? Select all that apply.

  • Reduce a company’s carbon footprint based on its current emissions (Correct)
  • Increase the efficiency of a car manufacturer based on its current assembly process (Correct)
  • Spread awareness about income inequality based on local salaries
  • Improve accessibility for an educational app based on its current functionality (Correct)

6. An advertising firm has used insights from its analytics team to create a strategy for improving sales. Now, they implement a plan to increase annual revenue. The firm is at which step of the data analysis process?

  • Analyze
  • Act (Correct)
  • Process
  • ShareIncorrectYou didn’t select an answer.

7. A data analyst adds descriptive headers to columns of data in a spreadsheet. How does this improve the spreadsheet?

  • It adds context (Correct)
  • It clarifies the business strategy
  • It improves the aesthetic appeal
  • It eliminates unnecessary details

8. This is a selection from a spreadsheet that ranks the 10 most populous cities in North Carolina. To alphabetize the county names in column D, which spreadsheet tool would you use?

A B C D
1 Rank Name Population County
2 7 Cary 170,282 Wake, Chatham
3 1 Charlotte 885,708 Mecklenburg
4 10 Concord 96,341 Cabarrus
5 4 Durham 278,993 Durham (seat), Wake, Orange
6 6 Fayetteville 211,657 Cumberland
7 3 Greensboro 296,710 Guilford
8 9 High Point 112,791 Guilford, Randolph, Davidson, Forsyth
9 2 Raleigh 474,069 Wake (seat), Durham
10 8 Wilmington 123,784 New Hanover
11 5 Winston-Salem 247,945 Forsyth
Familiar with data analytics – Week 1

  • Organize range
  • Alphabetize range
  • Name range
  • Sort range (Correct)

9. You are querying a database of manufacturing company suppliers. The column name for supplier identification numbers is supplier_id. What is the correct clause to retrieve only data about the supplier with identification number 85317?

  • FROM supplier_id 85317
  • SELECT supplier_id 85317
  • WHERE supplier_id = 85317 (Correct)
  • COLUMN supplier_id = 85317

Correct: The correct clause is WHERE supplier_id = 85317. This clause tells the database to return only information about the supplier whose ID is 85317.

10. Imagine you are sharing your data with a company stakeholder. Why might you display data with a data visualization instead of a table? Select all that apply.

  • It helps them identify trends more quickly (Correct)
  • It thoroughly describes each data point
  • It’s easy to understand (Correct)
  • It’s aesthetically pleasing (Correct)

Test your knowledge on the data ecosystem

1. Which of the following statements best defines data?

  • Data is the use of calculations and statistics.
  • Data is an assortment of questions.
  • Data is a business process.
  • Data is a collection of facts. (Correct)

2. Fill in the blank: In data analytics, the data ecosystem refers to the various elements that interact with one another to produce, manage, store, _____, analyze, and share data.

  • locate
  • merge
  • ingest
  • organize (Correct)

3. Which of the following terms refers to the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making?

  • Data analysis (Correct)
  • Data life cycle
  • Data elements
  • Data insight

4. An airline collects, observes, and analyzes its customers’ online behaviors. Then, it uses the insights gained to choose what new products and services to offer. What business process does this describe?

  • Performance measurement
  • Collaboration with stakeholders
  • Analytical thinking
  • Data-driven decision-making (Correct)

Test your knowledge on proper use of the discussion forum

1. Which of the following examples is an appropriate use of the discussion forum?

  • Asking a question about a lesson from this program (Correct)
  • Sharing a photo of your new pet
  • Asking other learners to give your resume to their employer
  • Posting answers to quiz questions

2. In order to create clear and engaging discussions in the forum, which type of writing style should you use? Select all that apply.

  • Writing in complete sentences (Correct)
  • Typing in all lowercase
  • Writing in text message language, such as BTW for “by the way”
  • Including proper punctuation, such as commas and periods (Correct)

3. When posting in the discussion forum, what type of behavior is acceptable?

  • Using cursing to emphasize your point
  • Sharing advertisements and product promotions
  • Conveying your opinion clearly by arguing against someone’s perspective
  • Being sensitive, kind, and open-minded (Correct)

*Weekly Challenge 1*

1. The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making describes what?

  • Data analytics
  • Data life cycle
  • Data analysis (Correct)
  • Data science

2. Fill in the blank: Data ecosystems are made up of elements that _____ with each other. This makes it possible for them to produce, manage, store, organize, analyze, and share data.

  • gain insights
  • unite
  • interact (Correct)
  • problem-solve

3. Fill in the blank: Data _____ involves creating new ways of modeling and understanding the unknown by using raw data.

  • engineering
  • design
  • science (Correct)
  • analysis

4. What tactics can a data analyst use to effectively blend gut instinct with facts? Select all that apply.

  • Focus on intuition to choose which data to collect and how to analyze it.
  • Use their knowledge of how their company works to better understand a business need. (Correct)
  • Apply their unique past experiences to their current work, while keeping in mind the story the data is telling. (Correct)
  • Ask how to define success for a project, but rely most heavily on their own personal perspective.

5. A company defines a problem it wants to solve. Then, a data analyst gathers relevant data, analyzes it, and uses it to draw conclusions. The analyst shares their analysis with subject-matter experts, who validate the findings. Finally, a plan is put into action. What does this scenario describe?

  • Customer service
  • Data science
  • Data-driven decision-making (Correct)
  • Identification of trends

6. To get the most out of data-driven decision-making, it’s important to include insights from people very familiar with the business problem. Identify what these people are called.

  • Customers
  • Stakeholders
  • Competitors
  • Subject-matter experts (Correct)

7. Sharing the results of your analysis with colleagues who are very familiar with the business problem supports what practice?

  • Data analytics
  • Data science
  • Data management
  • Data-driven decision-making (Correct)

Correct: Sharing the results of your analysis with people who are familiar with the business problem is an example of data-driven decision-making. Data-driven decision-making is using facts to guide business strategy.

8. You read an interesting article about data analytics in a magazine and want to share some ideas from the article in the discussion forum. In your post, you include the author and a link to the original article. This would be an inappropriate use of the forum.

  • True
  • False (Correct)

Which of the following terms refers to the collection transformation and organization of data in order to draw conclusions make predictions and DR?
Google Data Analytics Professional Certificate Study Guide

From the Quiztudy Team

Hi, Quiztudy is pleased to assist you with any study guide, certificate, or assessment test. More study guides will be published as we grow.

    Subscribe to our site

    Get new content delivered directly to your inbox.

    What is the process of examining datasets in order to draw conclusions called?

    The term data analytics refers to the process of examining datasets to draw conclusions about the information they contain. Data analytic techniques enable you to take raw data and uncover patterns to extract valuable insights from it.

    What term describes a collection of elements that interact with one another?

    In data analytics, a data ecosystem is a group of elements that interact with one another.

    Which data involves creating new ways of modeling and understanding the unknown by using raw data?

    Data analysis is also known as data analytics, described as the science of analyzing raw data to draw informed conclusions based on the data.

    What is the concept of data analysis?

    Data analysis, is a process for obtaining raw data, and subsequently converting it into information useful for decision-making by users. Data, is collected and analyzed to answer questions, test hypotheses, or disprove theories.