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

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?

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

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.

OQ3. Use the filters to adjust the sales revenue forecast for each product description. Which product has the most uncertain forecast, that is, the widest range of possible values? Imperial Stout has the most uncertain forecast. OQ4. What is the trend in the forecast for sales overall relative to March? The trend is increasing for sales overall relative to March. OQ5. What type of analytics (descriptive, diagnostic, predictive, prescriptive) is represented in the Sales Revenue by Customer visualization? Descriptive analytics. OQ6. What type of analytics (descriptive, diagnostic, predictive, prescriptive) is represented in the Sales Revenue Forecast visualization? Predictive analytics. Lab 4-2 Analysis Questions (LO 4-2, 4-3) AQ1. If you're trying to find the top 10 customers, why would dividing the tree map by state make these harder to find? It's because dividing the tree map by state shows the top customers in each state easily, but it does not obviously show the top 10 customers overall. AQ2. What other visualizations might you use to explore sales revenue? Bar charts and pie charts. AQ3. What other ways might you slice sales revenue to help management explore or predict performance? Slicing sales revenue by time such as weekly and monthly.

Lab 4-4 (Tableau track) Part 1 Lab 4-4 Part 1 Objective Questions (LO 4-2) OQ1. Which state has the lowest sum of transaction amount? WY has the lowest sum of transaction amount. OQ2. Which state has the highest sum of transaction amount? TX has the highest sum of transaction amount. OQ3. What is the average transaction amount for Montana (MT)? The average transaction amount for Montana (MT) is 18.225. OQ4. What is the average transaction amount for in-person transactions in Arkansas (AR)? The average transaction amount for in-person transactions in Arkansas (AR) is 18.954. OQ5. What type of analytics (descriptive, diagnostic, predictive, prescriptive) is represented in these visualizations? Descriptive analytics. Lab 4-4 Part 1 Analysis Questions (LO 4-2, 4-3, 4-5)

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

AQ1. When working with geographic data, it is possible to view the output by a map or by a traditional visualization, such as the bar charts that you created in this lab. What type of insights can you draw more quickly with the map visualization than the bar chart? What type of insights can you draw more quickly from the bar chart? Yes, it is possible to view the output by a map or traditional visualization. I can draw more quickly with the map visualization about where the state is located and see if the middle areas or the east sides have higher values. I can draw more quickly from the bar chart to see which states have the highest and lowest values. AQ2. Texas has the highest sum of transaction amounts, but only the fourth-highest average. What insight can you draw from that difference? I can draw that even the sum of transaction amounts and the numbers of transactions themselves are not completely related. Part 2 Lab 4-4 Part 2 Objective Questions (LO 4-2) OQ1. What is the average online transaction amount for customers from Maine? The average online transaction amount for customers from Maine is 33.19. OQ2. What is the sum of online transactions in Alaska (AK)? The sum of online transactions in Alaska (AK) is 1758. OQ3. Is the average online transaction amount for customers from Texas greater than or less than the average transaction amount for stores located in Texas?

The average online transaction amount for customers from Texas is greater than the average transaction amount for stores located in Texas Lab 4-4 Part 2 Analysis Questions (LO 4-4, 4-5) AQ1. What insights should Dillard's draw from the online transactions that occur in states that already have Dillard's stores in them? What additional exploratory analysis would you perform on these transactions? Dillard's should be able to see if the customers prefer online or in-store shopping. Dillard's then can consider either expanding or scaling down the stores. I would perform customer segmentation analysis on these transactions to see customer buying criteria. AQ2. You would like to compare the average online transaction amount for customers who reside in states that do not have Dillard's stores with the online transaction amount for customers who reside in states that do have Dillard's stores. How would you prepare your data to make that comparison? I would do data cleaning to make sure there are no duplicates or missing values. Lab 4-5 (Tableau track) Part 1 Lab 4-5 Part 1 Objective Questions (LO 4-2, 4-3) OQ1. Which Texas city is the store that has the highest sum of transactions located in? Houston. OQ2. Which Texas city has the most stores? Houston.

OQ3. What type of analysis did you perform in Part 1 of this lab (descriptive, diagnostic, predictive, or prescriptive)? Descriptive a nalytics. Part 2 Lab 4-5 Part 2 Objective Questions (LO 4-2) OQ1. Which Department Decade is the best selling in the Shoes Century? Womens Shoes. OQ2. Which Department Century is the worst performing? Juniors. OQ3. Which Department is the best selling in the Big Ticket (Century) > Case Goods (Decade)? Bedroom. Lab 4-5 Part 2 Analysis Questions (LO 4-3, 4-4) AQ1. This lab is a starting point for exploring revenue across stores and departments at Dillard's. What next steps would you take to further explore these data? I would explore more about the average revenue across stores and departments at Dillard's. AQ2. Some of the department centuries and decades are not readily easy to understand if we're not Dillard's employees. Which attributes would you like to learn more about? I would like to learn more about what products sell the most and least in each store and state.

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

AQ3. In this lab we used relatively simple bar charts to perform the analysis. What other visualizations would be interesting to use to explore these data? Pie charts.

Related Documents

benchmark com 500.docx

EAS545.pdf

BMGT Organizational Culture.docx

Planning and the SWOT Analysis (1).docx

BMGT Week 2 Discussion.docx

BMGT Week 8 Discussion.docx

LEADERSHIP ASSIGNMENT.docx

BMGT Week 5 Discussion.docx

ACC 550 Hampshire Company Spreadsheet.xlsx

04_MGMT 3276 Corporate Analysis Project Plan Guidelines and Rubric_W24 (1).doc

BMGT 364 Project 3 (Week 6) - Leading.docx

Harrison Sisters Limited Case Study Assignment (W24).docx

Recommended textbooks for you

Understanding Business

Management

ISBN:9781259929434

Author:William Nickels

Publisher:McGraw-Hill Education

Management (14th Edition)

Management

ISBN:9780134527604

Author:Stephen P. Robbins, Mary A. Coulter

Publisher:PEARSON

Spreadsheet Modeling & Decision Analysis: A Pract...

Management

ISBN:9781305947412

Author:Cliff Ragsdale

Publisher:Cengage Learning

Management Information Systems: Managing The Digi...

Management

ISBN:9780135191798

Author:Kenneth C. Laudon, Jane P. Laudon

Publisher:PEARSON

Business Essentials (12th Edition) (What's New in...

Management

ISBN:9780134728391

Author:Ronald J. Ebert, Ricky W. Griffin

Publisher:PEARSON

Fundamentals of Management (10th Edition)

Management

ISBN:9780134237473

Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo

Publisher:PEARSON

SEE MORE TEXTBOOKS

Recommended textbooks for you

Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON