Lab 4-4
Lab 4-4 Part 1 Objective Questions
OQ1. Which state has the lowest sum of transaction amount?
WY (Wyoming)
OQ2. Which state has the highest sum of transaction amount?
TX (Texas)
OQ3. What is the average transaction amount for Montana (MT)?
18.23
OQ4. What is the average transaction amount for in-person transactions in Arkansas
(AR)?
18.95
OQ5. What type of analytics (descriptive, diagnostic, predictive, prescriptive) is represent
in these visualizations?
Descriptive and predictive analytics is represented in these visualizations.
Lab 4-4 Part 1 Analysis Questions
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?
The map visualization illustrates the states with the highest overall sales through color
differentiation. Meanwhile, the bar chart offers a clearer display of specific sales figures,
arranged in descending or ascending order.
AQ2. Texas has the highest sum of transaction amounts, but only the fourth-highest
average. What insight can you draw from that difference?
This phenomenon might occur because states with fewer transactions tend to have higher
average transaction amounts. Contrarily, Texas, being a larger state with more transactions,
exhibits a different pattern.
Lab 4-4 Part 2 Objective Questions
OQ1. What is the average online transaction amount for customers from Maine?
33.19
OQ2. What is the sum of ornline transactions in Alaska (AK)?
1,758.15
OQ3. Is the avergae 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 (32.00) greater than the
average transaction amount for stores located in Texas (19.75)
Lab 4-5
Lab 4-5 Part 1 Objective Questions
OQ1. Which Texas city is the store that has the highest sum of transactions located in?
Houston has the highest sum of transactions located in Texas (52,010,104.27)
OQ2. Which Texas city has the most stores?
TX EL PASO has the most stores (5 stores: 509, 510, 771, 774, 775)
OQ3. What type of analysis did you perform in Part 1 of this lab (descriptive, diagnostic,
predictive, or prescriptive)?
Descriptive analysis
Lab 4-5 Part 2 Objective Questions
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
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?
To delve deeper into these data, potential next steps could involve:
- Investigating the correlation between revenue and other variables to unearth potential
influences on revenue.
- Delving into a comprehensive analysis of revenue trends over time.
- Scrutinizing the revenue performance of individual stores or departments to pinpoint any
outliers or areas for enhancement.
- Undertaking a market segmentation analysis to comprehend revenue patterns across different
segments or demographics.
- Examining the relationship between revenue and other financial indicators of business health.
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?
Some attributes worth exploring further could encompass:
- Store types
- Department centuries and decades
- Department codes
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?
- Line charts
- Pie charts
- Heatmaps
- Scatter plots
