ACC555 Data Analystics - Practice Lab Problems-Chapter 7 Problem 1: Required information NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document

Subject:AccountingPrice:15.99 Bought14

Share With

ACC555 Data Analystics - Practice Lab Problems-Chapter 7

Problem 1:

Required information

NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to the step in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab.

In this lab, you will:

• Generate some key performance indicators
• Evaluate the data
• Perform analyses and generate visualizations

Refer to Chapter 7 pages 266 through 272 for instructions and steps for each of the lab parts. After completing Lab parts 1 through 4, complete the following requirements.

Software needed

• Tableau

Data

• Lab_7_2_Superstore.xls—Sales order data are available from 2013–2016, including demographic data about the customers, as well as main categories and subcategories of products.

Required:

1. Which product sub-categories have fallen below the profit goal of 13%? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

check all that apply

• Chairsunanswered
• Artunanswered
• Tablesunanswered
• Bookcasesunanswered
• Storageunanswered
• Envelopesunanswered
• Accessoriesunanswered
• Furnishings

Problem 2:

2. Which states are taking significantly more than 4 days to ship to? (Define significantly more than 4 days as 5 days or more). (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

check all that apply

• Californiaunanswered
• Maineunanswered
• Floridaunanswered
• Arkansasunanswered
• Wyomingunanswered
• District of Colombiaunanswered
• Texas

Problem 3:

3. Which region experienced a higher than 10% return rate from customers?

multiple choice

• East

• Central

• West

 Problem 4:

4. Which sales representative is leading the rest for the most recent month?

multiple choice

• Kelly Williams

• Anna Andreadi

• Cassandra Brandow

• Chuck Magee

Problem 5:

Upload the Word or PDF document containing your Lab screenshots using the button below.

Problem 6:

In this lab, you will:

• Learn to build a KPI. In this case, we are trying to assess whether we are improving sales over the same date a year earlier.

• Specifically, create a baseline measure in Excel and set a target value. These two measures will be used to create a KPI to compare sales data across two different periods.

Refer to Chapter 7 pages 273 through 279 for instructions and steps for each of the lab parts. After completing Lab parts 1 and 2, complete the following requirements.

Software needed

• Microsoft SQL Server Management Studio (available on the VMWare at the University of Arkansas)
• Excel 2016 (available on the VMWare at the University of Arkansas)
• PowerPivot Excel add-in. To create a date table, we'll extract and load the data through PowerPivot instead of through the Get & Transform tab. If you don't see PowerPivot as a tab in the Excel ribbon, you will need to activate the add-in.

   

  

   

  

   

  

   

  

  1. From the File tab on the ribbon, open Options.
  
  
  2. Select Add-ins from the left side of the Excel Options window.
  
  
  3. From the drop-down window at the bottom of the Add-ins screen, Select COM add-ins, then click Go…
  
  
  4. Place a check mark in the box next to Microsoft Power Pivot for Excel, then click OK.

Data

If you completed comprehensive Labs 3-4 and Labs 3-5, you can use the same Excel file that you created and saved in Lab 3-5, Dummy.xlsx.

If you did not complete those labs, you will need to extract that data and load them into Excel using the following query:

Select Transact.*, Store.STATE

From Transact

Inner Join Store

On Transact.Store = Store.STORE

Where TRAN_DATE BETWEEN '20160901' and '20160915'

Order By Tran_Date

The data for this lab and all other Dillard's labs must be accessed through the University of Arkansas Remote Desktop. Documentation on how to connect and log in to the remote desktop can be found below and on the Additional Student Resources page.
Once you have a remote access account, you can log in to access the University of Arkansas server using any web browser. Instructions for logging in can be found below:

Logging into UARK Remote Desktop - VMWare
Accessing the Dillard’s dataset in Excel

Required:

1. When looking at the comparison between Dillard's performance in 2015 and 2016, which day had the worst performance, compared to the same date in the previous period?

Day with worse performance : options are date