Categorizing things is one of the six problem types data analysts solve. This type of problem might involve which of the following actions?
- Classifying or grouping items
- Using data to envision how something might happen in the future
- Noticing something outside of the ordinary
- Analyzing how one action leads to or affects another
Categorizing things involves classifying or grouping items in order to gain insights.
Finding patterns is one of the six problem types data analysts aim to solve. This type of problem might involve which of the following?
- Taking categorized items and grouping them into broader topic areas
- Noticing something outside of the ordinary
- Analyzing how one action leads to or affects another
- Identifying trends from historical data
Finding patterns involves identifying trends from historical data.
In the SMART methodology, questions that encourage change are described how?
- Relevant
- Specific
- Time-bound
- Action-oriented
Action-oriented questions encourage change.
Fill in the blank: In data analytics, qualitative data _____. Select all that apply.
- measures numerical facts
- measures qualities and characteristics
- is specific
- is subjective
Qualitative data is subjective and measures qualities and characteristics.
In data analytics, how are dashboards different from reports?
- Dashboards contain static data. Reports contain data that is constantly changing.
- Dashboards are used to share updates with stakeholders only periodically. Reports give stakeholders continuous access to data.
- Dashboards provide a high level look at historical data. Reports provide a more detailed look at 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.
Dashboards monitor live, incoming data from multiple datasets and organize the information into one central location. Reports are static collections of data.
Small data differs from big data in what ways? Select all that apply.
- Small data focuses on short, well-defined time periods. Big data focuses on change over a long period of time.
- Small data is typically stored in a database. Big data is typically stored in a spreadsheet.
- Small data is effective for analyzing day-to-day decisions. Big data is effective for analyzing more substantial decisions.
- Small data involves datasets concerned with a small number of specific metrics. Big data involves datasets that are larger and less specific.
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.
Fill in the blank: Some of the most common symbols used in formulas include + (addition), - (subtraction), * (multiplication), and / (division). These are called _____.
- references
- operators
- counts
- domains
Operators are symbols used in formulas, including + (addition), - (subtraction), * (multiplication), and / (division).
In the function =SUM(G1:G35), identify the range.
- G1:G35
- =SUM
- G35
- =SUM(G1)
In the function =SUM(G1:G35), the range is G1:G35. A range is a collection of two or more cells.
To address a vague, complex problem, a data analyst breaks it down into smaller steps. They use a process to help them recognize the current problem or situation, organize available information, reveal gaps and opportunities, and identify options. What does this scenario describe?
- Gap analysis
- Structured thinking
- Data-driven decision-making
- Analytical thinking
Structured thinking is the process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying the options.
Asking questions including, “Does my analysis answer the original question?” and “Are there other angles I haven’t considered?” enable data analysts to accomplish what tasks? Select all that apply.
- Identify primary and secondary stakeholders
- Use data to get to a solid conclusion
- Help team members make informed, data-driven decisions
- Consider the best ways to share data with others
Data analysts ask thoughtful questions to help them reach solid conclusions, consider how to share data with others, and help team members make effective decisions.