Digiskills Data Analytics exercise 2 Batch 2.0 Data Analytics and Business Intelligence exercise 2

Digiskills Data Analytics exercise 2 Batch 2.0 Data Analytics and Business Intelligence exercise 2

Instructions:

Please read the following instructions carefully before submitting this Hands-on Exercise:

• Use MS Excel to prepare exercise solution.

• You may consult tutorials and videos if the concept is not clear.

• Your submitted exercise will not be considered/counted if:

▪ It is submitted after due date.

▪ It is not in the required format (.xlsx)

▪ It does not open, or file is corrupt.

▪ It is copied (partial or full) from any source (websites, forums, students, etc.)

Learning Outcome:

After completing this exercise, you shall be able to:

• download and add a dataset

• create a Pivot table by using Microsoft Excel

• perform segmentation analysis by using pivot table

 

Problem Statement:

In this exercise, you are required to perform all the given tasks.:

Tasks:

1) You are required to download the dataset from Kaggle through the following link (2 Marks)

https://www.kaggle.com/datasets/aungpyaeap/supermarket-sales

2) Insert a pivot table and show "Gross income" for a specific branch (2 Marks)

3) In Pivot table, show gross income according to the "Gender" in specific branch (2 Marks)

4) In Pivot table, show gross income according to the "Customer type" in specific branch (2 Marks)

5) In the Pivot table, show the gross income according to the "Payment" in specific branch (2 Marks)

    

Exercise 1 Here