Data source – Global Superstore Dataset (Attached)

Business Questions

1. Create a Bar/Column chart Showing top 10 sub-category by descending order according to sum of sales.
2. Create a line chart showing monthly sales
3. Create a pie chart showing Sales percentage of Segment
4. Create a scatterplot of sales vs profit according to subcategory
5. Create a map by state and highlight color by profit
6. Create a dashboard including all charts from above.

Rubric

Questions         

Grade

1

0.5

2

0.5

3

1

4

1

5

1

6

1

Total

5

While submitting the assignment, please include your First Name & Last name with the file name.

Please submit .twb or .twbx file.