Identify the top five states with the highest sales

Reference no: EM133740111

Question: You are a data analyst working for OfficeStuff, a company that sells office supplies, furniture, and equipment in the US. Your task is to analyze the company's transactional data Download company's transactional datato identify problems and opportunities, create a dashboard to visualize and communicate the findings, and compile a report to be shared with management for decision-making purposes.

To complete this assignment, follow the instructions below and organize your work accordingly:

1. Sales by State:

Use Tableau to visualize the sales data for each state on a map.

Identify the top five states with the highest sales based on your analysis.

Explain how you determined the top states in terms of sales.

2. Profitability by State:

Use Tableau to visualize the profitability data for each state on a map, using a different color scheme than in exercise 1.

Identify the top five states that are most problematic in terms of business profitability.

Explain how you determined the top states with profitability challenges.

3. Profitability/Discounts by Product Category/Sub-category:

Visualize the product categories and sub-categories as horizontal bar charts.

Determine which product categories and sub-categories face the most profitability challenges (bottom two).

Analyze the role of discounts in relation to these problematic sub-categories and visualize this information.
4. Profit Trends for Each Category/Sub-category:
Create line graphs to visualize the profit trends for each sub-category over the years.
Identify the product sub-categories that experienced the most significant increases or decreases in profit in 2017 (top and bottom three).

Reference no: EM133740111

Questions Cloud

What experiences can you connect to this learning : What experiences can you connect to this learning?

What part of the nervous system might be affected : During a health examination of a child aged 4, the pediatrician revealed that the child couldn't jump. What part of the nervous system might be affected?

Organizational learning and development : Identify three key stakeholders involved in organizational learning and development.

How does social disorganization theory : How does social disorganization theory explain the relationship between neighborhood characteristics and crime rates? In what ways can the principles of social

Identify the top five states with the highest sales : Identify the top five states with the highest sales based on your analysis. Explain how you determined the top states in terms of sales

Describe how the core ethical principals should be : Describe how the following core ethical principals should be used to guide decision making related to the behavioral intervention.

How should coach handle athletes who break team rules : How should a coach handle athletes who break team rules? What should the consequences be for rule violations?

Manager conflict resolution style : Would anyone care to describe an experience where you left a job because of the manager's conflict resolution style? What was the conflict?

How the situation impacts on the employers responsibilities : How the situation impacts on the rights and responsibilities of the client? How the situation impacts on the employers' responsibilities?

User Account

All Pages