Scribd
Upload
24 views3 pages

SGRHDFHDHD

The document provides insights from a lab analysis of store transactions in Texas, identifying Houston as the city with the highest transaction sum and El Paso as having the most stores. It highlights women's shoes as the best-selling department in the shoes category and bedroom items as the top seller in big ticket cases. Additionally, it suggests further analysis on revenue trends, store performance, and potential visualizations for data representation.

Uploaded by

Nhiên An
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
24 views3 pages

SGRHDFHDHD

The document provides insights from a lab analysis of store transactions in Texas, identifying Houston as the city with the highest transaction sum and El Paso as having the most stores. It highlights women's shoes as the best-selling department in the shoes category and bedroom items as the top seller in big ticket cases. Additionally, it suggests further analysis on revenue trends, store performance, and potential visualizations for data representation.

Uploaded by

Nhiên An
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Lab 4-5 Part 1

OQ1. Which Texas city is the store that has the highest sum of
transactions located in?
Answer: Houston has the highest sum of transactions located in
Texas (52,010,104.27)
OQ2. Which Texas city has the most stores?
Answer: 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)?
Answer: Descriptive analysis
Part 2

OQ1. Which Department Decade is the best selling in the Shoes


Century?
Answer: Womens Shoes
OQ2. Which Department Century is the worst performing?
Answer: Juniors
OQ3. Which Department is the best selling in the Big Ticket
(Century) > Case Goods (Decade)?
Answer: Bedroom
AQ1. 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 attributes worth exploring further could encompass:
- Store types
- Department centuries and decades
- Department codes
AQ3. In addition to bar charts, alternative visualizations worth
exploring for these data might include:
- Line charts
- Pie charts
- Heatmaps
- Scatter plots

You might also like