Data Analytics Diagnostic Quiz

Data Analytics Diagnostic Quiz 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 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 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 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 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 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 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 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 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 Imagine you are sharing your data with a company stakeholder. Why might you display data with a data visualization instead