Order from us for quality, customized work in due time of your choice.
Module 4: Business Dashboard
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).
In addition to the worksheets described above, create a comprehensive dashboard for OfficeStuff management. The dashboard should include the following components:
Two maps displaying profitability by state and sales by state.
A visualization of profit trends.
An overview of profit and discount information by product category and sub-category.
Refer to the provided example to get an idea of how your dashboard should be structured and presented.
5. Conclusion
When writing your conclusion, summarize the key findings for each analysis and address the specific business questions related to sales, profitability, and product categories/sub-categories. Finally, present actionable insights and recommendations based on your analysis. By following these instructions and organizing your work effectively, you will create a comprehensive report and dashboard that effectively communicate your findings and recommendations to OfficeStuff management.
Submission Requirements
Submit your answers in a 1-2-page Word document along with your Tableau workbook (TWBX).
When writing your answers to the Word document, ensure that you address each aspect of the assignment separately.
Provide clear explanations, supported by data and visualizations from your Tableau worksheets.
Label each Tableau sheet with the corresponding question number.
Each question should have a dedicated Tableau sheet.
You will have a dashboard in addition to the 4 sheets.
This assignment will be assessed based on the accuracy of your responses to each question in the worksheet.
Order from us for quality, customized work in due time of your choice.