KEMBAR78
Lec02 Assignment2 | PDF | Data Management | Data
Scribd
Upload
5 views4 pages

Lec02 Assignment2

The document presents a sales dataset detailing sales by region, salesperson, product, units sold, and unit price, with total sales calculated for each region. It outlines an exercise objective to clean and analyze the dataset to generate insights, including tasks such as handling missing values and creating pivot tables. The total sales result across all regions is noted as 2418.89, with a target of 3000.

Uploaded by

Lê Minh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
5 views4 pages

Lec02 Assignment2

The document presents a sales dataset detailing sales by region, salesperson, product, units sold, and unit price, with total sales calculated for each region. It outlines an exercise objective to clean and analyze the dataset to generate insights, including tasks such as handling missing values and creating pivot tables. The total sales result across all regions is noted as 2418.89, with a target of 3000.

Uploaded by

Lê Minh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Column1 Region Salesperson Product Units Sold Unit Price

1001 East John Doe Widget A 10 25


1002 West Jane Smith Widget B 5 35
1003 North Alice Brown Widget C 9.66666666666667 20
1004 South Bob White Widget A 20 25
1005 East John Doe Widget B 7 35
1006 West Jane Smith Widget C 3 20
1007 North Alice Brown Widget A 15 25
1008 South Bob White Widget B 10 25.555555555556
1009 East John Doe Widget C 12 20
1010 West Jane Smith Widget A 5 25
9.66666666666667 25.555555555556
Total Sales Order Date
250 1/5/2023 Region Sum of Total Sales
175 2/10/2023 East 735
193.333333333333 3/15/2023 North 568.333333333333
500 4/20/2023 South 755.555555555556
245 5/25/2023 West 360
60 6/30/2023 Total Result 2418.88888888889
375 7/5/2023
255.555555555556 8/10/2023
240 9/15/2023 Total
125 10/20/2023 3000

2500

2000
Sum of Total Sales
1500

1000

500

0
East North South West Total
Result
Sum of Total Sales

Total
Result
Exercise: Clean and Analyse a Dataset to Generate Insights with Excel
Objective:
● Clean and analyse a dataset to generate insights.
Tasks:
1. Identify and Handle Missing Values
2. Analyse Sales by Region
3. Create Pivot Tables to Summarise Sales Data

You might also like