Week 6 Lab

.docx

School

Temple University *

*We aren’t endorsed by this school

Course

4501

Subject

Management

Date

Apr 3, 2024

Type

docx

Pages

10

Uploaded by JusticeSnowRook481

Lab 4-1 (Tableau track) Part 1 Lab 4-1 Part 1 Objective Questions (LO 4-2) OQ1. What is the top-selling product by total revenue overall? Imperial Stout. OQ2. How much total revenue did the top-selling product generate overall? 370,440. OQ3. Which state had the highest total revenue overall? Taxes. OQ4. How much total revenue did that state generate overall? 294,440. Lab 4-1 Part 1 Analysis Questions (LO 4-2, 4-3)
AQ1. How do size and color make certain data points stand out relative to other data points? Size and color make it easier to see the comparison. In "Sales Revenue by State," the bigger the size, the larger the state is; the darker, the higher the values. In this case, we can see the relationship: the bigger state has higher sales revenue. AQ2. What other visualizations might you use to describe sales revenue? Pie chart. AQ3. What other ways might you slice sales revenue to help management understand performance? Slicing sales revenue by time might help management understand performance and wisely order inventory. Part 2
Lab 4-1 Part 2 Objective Questions (LO 4-2) OQ1. What is the total sales volume for January 2020? 2295. OQ2. By how much did Sláinte miss or exceed its overall sales goal of 10,000 units? Hint: Hover over Sales Volume By Target to see specific values. Sláinte exceeded its overall sales goal by 2380 units, and the total sales order is 12380. OQ3. Which products sold over 300 units in February 2020? Stout, IPA, and Imperial Stout sold over 300 units in February 2020. OQ4. Click the year 2020 in the Sales Volume By Month table. By how much did Sláinte miss or exceed its sales goal of 10,000 units for the year so far? The total sales were 8186 units; Sláinte missed its sales goal by 1814 units. Lab 4-1 Part 2 Analysis Questions (LO 4-2, 4-3) AQ1. What do you notice about sales revenue and sales volume based on your dashboard? I notice that the sales revenues generated by pale ale and imperial IPA are similar, while their sales volume contains a 60-unit difference. I can tell which products are more profitable. AQ2. What are some additional ways you could slice sales volume that would be useful to management as they evaluate performance?
Slicing sales volume by time and areas would be useful. AQ3. Which additional visualizations might be useful for showing declarative data in this instance? Scatter plots and pie charts. Lab 4-2 (Tableau track) Lab 4-2 Objective Questions (LO 4-2) OQ1. Who is the largest customer in Iowa (IA)? Beverage Distributors is the largest customer in Iowa (IA). OQ2. How many customers reside in Texas? There are 14 customers residing in Texas.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help