You’ve just started a new job as a data analyst. You’re working for a midsized pharmacy chain with 38 stores in the American Southwest. Your supervisor shares a new data analysis project with you.
She explains that the pharmacy is considering discontinuing a bubble bath product called Splashtastic. Your supervisor wants you to analyze sales data and determine what percentage of each store’s total daily sales come from that product. Then, you’ll present your findings to leadership.
You know that it’s important to follow each step of the data analysis process: ask, prepare, process, analyze, share, and act. So, you begin by defining the problem and making sure you fully understand stakeholder expectations.
One of the questions you ask is where to find the dataset you’ll be working with. Your supervisor explains that the company database has all the information you need.
Next, you continue to the prepare step. You access the database and write a query to retrieve data about Splashtastic. You notice that there are only 38 rows of data, representing the company’s 38 stores. In addition, your dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products).
Considering the size of your dataset, you decide a spreadsheet will be the best tool for your project. You proceed by downloading the data from the database. Describe why this is the best choice.
Correct
A spreadsheet is a smart choice when working with a dataset of 38 rows and five columns.
Related Questions & Answers:
- Fill in the blank: _____ involves the ability to break things down into smaller steps or pieces and work with them in an orderly and logical way. 3.Fill in the blank: _____ involves the ability to break things down into smaller steps or pieces and work with ... Read more...
- A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes which step of the data analysis process? 5.A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a ... Read more...
- Fill in the blank: A business task is described as the problem or _____ a data analyst answers for a business. 4.Fill in the blank: A business task is described as the problem or _____ a data analyst answers for a ... Read more...
- Next, you create a slideshow, which includes a data visualization to highlight the Splashtastic sales insights you’ve discovered. You’ve reached which phase of the data analysis process? 5. Scenario 1 continued Next, you create a slideshow, which includes a data visualization to highlight the Splashtastic sales insights ... Read more...
- What is an example of using a metric? Select all that apply. 5. What is an example of using a metric? Select all that apply. 1 / 1 point Using annual profit ... Read more...
- A data analyst might use descriptive column headers in order to achieve what goal? 8. A data analyst might use descriptive column headers in order to achieve what goal? 1 / 1 point Add context to ... Read more...