5. Coursera - Google Data Analytics Pro - Module 2.2

Which of the following statements correctly describe dashboards and reports? Select all that apply. A dashboard could be used to track hourly error rates when programming code. Reports are effective at capturing high-level, historical data. Reports and dashboards are both useful for data visualization. Dashboards are designed and distributed periodically as a reference.

A dashboard could be used to track hourly error rates when programming code. Reports are effective at capturing high-level, historical data. Reports and dashboards are both useful for data visualization.

What is the relationship between a metric and a metric goal? A metric is a business goal that is evaluated using numerous data points. A metric goal is a single data point that is quantified with metrics. 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.

A metric goal is a business objective that is evaluated using metrics.

A dashboard would be most beneficial for which of the following scenarios? A consultant needs all historical data for an audit. An analyst needs a summary of data upon request. A project manager needs to monitor data as it becomes available. A cross functional team needs an ad-hoc update

A project manager needs to monitor data as it becomes available.

Which of the following statements correctly describe dashboards and reports? Select all that apply. A sales dashboard could be used to track daily e-commerce sales. Reports provide continual access to information. A report is a static collection of data given to stakeholders periodically. Dashboards are useful for data visualization.

A sales dashboard could be used to track daily e-commerce sales. A report is a static collection of data given to stakeholders periodically. Dashboards are useful for data visualization.

A data professional works with data that is stored in a database. They use SQL to sort and analyze it in order to ensure the insights are as accurate as possible. What type of data are they most likely using? Small External Big Internal

Big

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 Using a formula Making a pivot table Data-inspired decision-making

Creating an algorithm

A data team at a community center automates a process to segment clients. First, a list of all clients is compiled. Then, they are sorted by the classes they have taken and events attended. Finally, clients are segmented by their activity histories. What does this scenario describe? Data-inspired decision-making Making a pivot table Creating an algorithm Using a formula

Creating an algorithm

Which of the following statements accurately describe data? Select all that apply. Data can reveal important patterns, trends, and insights. Data is used to help organizations make more informed decisions. Data is a collection of facts. There are no limitations to data, as data measures are standard across users.

Data can reveal important patterns, trends, and insights. Data is used to help organizations make more informed decisions. Data is a collection of facts.

What are some typical challenges that may be faced by businesses that are beginning to collect and use big data? Select all that apply. Difficulty finding important data There may be gaps in big data business tools Cannot help large organizations spot trends Less efficient decision-making time frames

Difficulty finding important data There may be gaps in big data business tools Less efficient decision-making time frames

What are some key benefits of dashboards? Select all that apply. Easy access for stakeholders Data enters the dashboard precleaned Ability to monitor live data Low maintenance

Easy access for stakeholders Ability to monitor live data Low maintenance

When working with big data, analysts consider the variety of data within large, complex datasets. What does this entail? Evaluating the quality and reliability of the data Identifying the different kinds of data included Understanding how quickly the data can be processed Assessing the amount of data available

Identifying the different kinds of data included

What are some characteristics of small data? Select all that apply. Likely to focus on specific metrics Useful when making day-to-day decisions Often organized and analyzed using spreadsheets Has a significant impact on large frameworks

Likely to focus on specific metrics Useful when making day-to-day decisions Often organized and analyzed using spreadsheets

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 Having too much unimportant information Technology may not provide reportable data

Needed data may be inaccessible Having too much unimportant information

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 Sort Format Data validation

Pivot table

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? Data validation Sort Pivot table Format

Pivot table

A human resources manager collects feedback from employees during their exit interviews. The employees are asked to share their feelings about company culture, which benefits they enjoyed most, and suggestions for ways to improve performance. What type of data is the manager collecting? Incomplete Qualitative Quantitative Numerical

Qualitative

A data professional at a web design firm collects data about website users. The data indicates the number of times each user visits the website. It also shows the duration of their visits, in seconds. What type of data is being collected? Redundant Narrative Quantitative Qualitative

Quantitative

Stakeholders at a utility company request insights summarizing the past month's business results. The information will include high-level, historical data about electricity usage. What type of deliverable should the data team provide? Report Dashboard Proposal Contract

Report

When working with big data, analysts consider the velocity of processing large, complex datasets. What does this entail? Understanding how quickly the data can be processed Evaluating the quality and reliability of the data Identifying the different kinds of data available Assessing the amount of data to be processed

Understanding how quickly the data can be processed

A supervisor presents their data team with a clear objective that was set by company decision-makers and will be evaluated and measured. The data team then uses this objective to drive a work project. What does this scenario describe? Using a single, quantifiable type of data Data-driven decision-making Cross-team collaboration Using a metric goal

Using a metric goal

When considering the benefits and challenges of big data, which of the "four V words" describe the amount of data being analyzed? Veracity Velocity Volume Variety

Volume

Fill in the blank: An _____ is a process or set of rules that may be followed in order to perform a specific task. equation observation attribute algorithm

algorithm

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. retention of investment return on investment rating of investment reasoning on investment

return on investment

Fill in the blank: A data analyst creates a pivot table when using _____ in order to summarize, count, or average data from a worksheet. spreadsheets SQL coding languages statistical software

spreadsheets

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. success difficulty urgency expense

success

Fill in the blank: Big data typically involves large datasets containing data from long _____, which has to be organized before analysis. sales campaigns time periods research projects business presentations

time periods