Optional: Familiar with data analytics? Take our diagnostic quiz

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

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?

Act

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?

Correlation

What is the process of guiding business strategy using facts?

Data-driven decision-making

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

Increase the efficiency of a car manufacturer based on its current assembly process Improve accessibility for an educational app based on its current functionality Reduce a company's carbon footprint based on its current emissions

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

It adds context

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 It's easy to understand It's aesthetically pleasing

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.

Records of its inventory The cloud that store its database The database of sales revenue

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?

Sort range

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?

WHERE supplier_id = 85317