Data analytics diagnostic quiz
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? Big-picture thinking Correlation Visualization Problem-orientation
correlation
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? Share Act Process Analyze
Act
What is the process of guiding business strategy using facts? Data-driven decision-making Identification of data and decisions Analytical planning Strategic improvement
Data-driven decision-making
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? Alphabetize range Organize range Name range Sort range
Sort range
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's easy to understand It thoroughly describes each data point It's aesthetically pleasing It helps them identify trends more quickly
It's easy to understand It's aesthetically pleasing It helps them identify trends more quickly
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. personal insights thought processes business skills analytical skills
analytical skills
A data analyst adds descriptive headers to columns of data in a spreadsheet. How does this improve the spreadsheet? It improves the aesthetic appeal It eliminates unnecessary details It adds context It clarifies the business strategy
It adds context
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 Increase the efficiency of a car manufacturer based on its current assembly process Spread awareness about income inequality based on local salaries Improve accessibility for an educational app based on its current functionality
Reduce a company's carbon footprint based on its current emissions Increase the efficiency of a car manufacturer based on its current assembly process Improve accessibility for an educational app based on its current functionality
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 database of sales revenue The cloud that store its database Records of its inventory The databases of competing retailers
The database of sales revenue The cloud that store its database Records of its inventory
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? SELECT supplier_id 85317 COLUMN supplier_id = 85317 WHERE supplier_id = 85317 FROM supplier_id 85317
WHERE supplier_id 85317