Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due
CDS504: Business Data Analytics
Term 1, 2024-2025
Individual Assignment 1
In this assignment, please use the Global Superstore.xls to perform customer analysis using Tableau, including worksheets with charts and tables.
Requirements
1. KPI Overview (two charts, 30 points)
- Create two additional worksheets for the remaining key performance indicators (KPIs): total profits and total quantity. Each worksheet should mirror the format of the total sales KPI worksheet from our tutorial.
- You may copy these two worksheets as images and insert them into a Word document.
2. Top 10 and Bottom 10 Customers by Profit (two tables, 30 points)
- Compile tables listing the top 10 customers and bottom 10 customers based on profits generated in 2023. Include the following details:
- Rank (Tip: Use a new calculation Index () in the Rows)- Total Current Sales- Total Current Profits- Total Quantity- Last Order Date (Tip: Calculate the maximum value of [Order Date])
- Your submission should consist of two tables accompanied by interpretations of the results.
3. Research on China Market (40 points)
Based on your data visualization analysis, answer the following questions:
- Which five cities in China have the highest profits?
- What are the top three most popular subcategories in these five cities?
- What are the bottom three least popular subcategories in these five cities?
- What recommendations can you make to improve profits in these five cities? Justify your recommendations with data analysis results.
Deadline for this assignment is October 18, 2024 11:59pm. In your submission, the files should include: 1) one WORD document, and 2) the Packaged Tableau workbook (the .twbx file).