KEMBAR78
Power Query Sales Data | PDF
Scribd
Upload
23 views12 pages

Power Query Sales Data

The document contains detailed sales data for various products managed by different sales managers across multiple regions, including Delhi, Lucknow, Mumbai, and Surat. It includes information on units sold, sales rates, and monthly sales figures, allowing for analysis of overall performance, product popularity, and sales manager effectiveness. Key tasks outlined include consolidating sales data region-wise, identifying products with the highest and lowest sales, determining the month with the highest sales, and grouping sales by managers.

Uploaded by

Lovika Saluja
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
23 views12 pages

Power Query Sales Data

The document contains detailed sales data for various products managed by different sales managers across multiple regions, including Delhi, Lucknow, Mumbai, and Surat. It includes information on units sold, sales rates, and monthly sales figures, allowing for analysis of overall performance, product popularity, and sales manager effectiveness. Key tasks outlined include consolidating sales data region-wise, identifying products with the highest and lowest sales, determining the month with the highest sales, and grouping sales by managers.

Uploaded by

Lovika Saluja
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/ 12

S. No.

Product Name Sales Manager Date Units Sold Rate


1 Board Games Pooja Sharma 3/6/2024 50 525
2 Trousers Rohan Verma 5/4/2024 124 1295.25
3 Shirts Rohan Verma 3/4/2024 74 2999.25
4 Tea Uma Shankar 8/8/2024 193 54.75
5 Laptops Pooja Sharma 9/24/2024 23 52999
6 Smartphones Uma Shankar 1/10/2024 87 72000
7 Washing Machines Rohan Verma 12/11/2024 34 56999
8 Laptops Uma Shankar 11/14/2024 81 51299
9 Smartphones Kriti Mathur 5/3/2024 100 25999.95
10 Microwaves Pooja Sharma 2/18/2024 62 43000
11 Snacks Kriti Mathur 12/13/2024 172 299
12 Washing Machines Kriti Mathur 1/16/2024 80 62000
13 Trousers Pooja Sharma 7/7/2024 128 3500
Month Name Monthly Sales
January 11239750
September 9071693
February 4570000
December 4402458
November 4155219
May 2997721
June 599988
July 475772.5
March 248194.5
August 10566.75
Month Name Monthly Sales
May 2997721
December 4402458
September 9071693
July 475772.5
January 11239750
June 599988
February 4570000
March 248194.5
August 10566.75
November 4155219
S. No. Product Name Sales Manager Date Units Sold Rate Date - Copy
1 Shirts Jai Kishan 5/23/2024 450 499 5/23/2024
2 Refrigerators Suparna Joshi 12/14/2024 23 34500 12/14/2024
3 Washing Machines Ramesh Vij 9/29/2024 91 39999 9/29/2024
4 Puzzles Suparna Joshi 12/3/2024 120 250 12/3/2024
5 Snacks Reena Jain 7/8/2024 230 120.75 7/8/2024
6 Tea Jai Kishan 1/16/2024 350 45 1/16/2024
7 Board Games Jai Kishan 12/19/2024 100 399 12/19/2024
8 Refrigerators Jai Kishan 6/16/2024 12 49999 6/16/2024
9 Microwaves Jai Kishan 2/23/2024 34 56000 2/23/2024
10 Smartphones Reena Jain 12/1/2024 56 26999 12/1/2024
11 Tea Ramesh Vij 12/9/2024 1886 20 12/9/2024
12 Laptops Reena Jain 9/17/2024 93 45299 9/17/2024
13 Coffee Ramesh Vij 5/23/2024 35 359 5/23/2024
14 Board Games Pooja Sharma 3/6/2024 50 525 3/6/2024
15 Trousers Rohan Verma 5/4/2024 124 1295.25 5/4/2024
16 Shirts Rohan Verma 3/4/2024 74 2999.25 3/4/2024
17 Tea Uma Shankar 8/8/2024 193 54.75 8/8/2024
18 Laptops Pooja Sharma 9/24/2024 23 52999 9/24/2024
19 Smartphones Uma Shankar 1/10/2024 87 72000 1/10/2024
20 Washing Machines Rohan Verma 12/11/2024 34 56999 12/11/2024
21 Laptops Uma Shankar 11/14/2024 81 51299 11/14/2024
22 Smartphones Kriti Mathur 5/3/2024 100 25999.95 5/3/2024
23 Microwaves Pooja Sharma 2/18/2024 62 43000 2/18/2024
24 Snacks Kriti Mathur 12/13/2024 172 299 12/13/2024
25 Washing Machines Kriti Mathur 1/16/2024 80 62000 1/16/2024
26 Trousers Pooja Sharma 7/7/2024 128 3500 7/7/2024
Month Name Sales Amount
May 224550
December 793500
September 3639909
December 30000
July 27772.5
January 15750
December 39900
June 599988
February 1904000
December 1511944
December 37720
September 4212807
May 12565
March 26250
May 160611
March 221944.5
August 10566.75
September 1218977
January 6264000
December 1937966
November 4155219
May 2599995
February 2666000
December 51428
January 4960000
July 448000
S.No. Product Name Sales Manager Date Units Sold Rate
1 Shirts Jai Kishan 5/23/2024 450 499
2 Refrigerators Suparna Joshi 12/14/2024 23 34500
3 Washing Machines Ramesh Vij 9/29/2024 91 39999
4 Puzzles Suparna Joshi 12/3/2024 120 250
5 Snacks Reena Jain 7/8/2024 230 120.75
6 Tea Jai Kishan 1/16/2024 350 45
7 Board Games Jai Kishan 12/19/2024 100 399
1 Refrigerators Jai Kishan 6/16/2024 12 49999
2 Microwaves Jai Kishan 2/23/2024 34 56000
3 Smartphones Reena Jain 12/1/2024 56 26999
4 Tea Ramesh Vij 12/9/2024 1886 20
5 Laptops Reena Jain 9/17/2024 93 45299
6 Coffee Ramesh Vij 5/23/2024 35 359
S.No. Product Name Sales Manager Date Units Sold Rate
1 Board Games Pooja Sharma 3/6/2024 50 525
2 Trousers Rohan Verma 5/4/2024 124 1295.25
3 Shirts Rohan Verma 3/4/2024 74 2999.25
4 Tea Uma Shankar 8/8/2024 193 54.75
5 Laptops Pooja Sharma 9/24/2024 23 52999
6 Smartphones Uma Shankar 1/10/2024 87 72000
7 Washing Machines Rohan Verma 12/11/2024 34 56999
S.No. Product Name Sales Manager Date Units Sold Rate
1 Laptops Uma Shankar 11/14/2024 81 51299
2 Smartphones Kriti Mathur 5/3/2024 100 25999.95
3 Microwaves Pooja Sharma 2/18/2024 62 43000
4 Snacks Kriti Mathur 12/13/2024 172 299
5 Washing Machines Kriti Mathur 1/16/2024 80 62000
6 Trousers Pooja Sharma 7/7/2024 128 3500
S.No. Product Name Sales Manager Date Units Sold Rate
1 Shirts Jai Kishan 5/23/2024 450 499
2 Refrigerators Suparna Joshi 12/14/2024 23 34500
3 Washing Machines Ramesh Vij 9/29/2024 91 39999
4 Puzzles Suparna Joshi 12/3/2024 120 250
5 Snacks Reena Jain 7/8/2024 230 120.75
6 Tea Jai Kishan 1/16/2024 350 45
7 Board Games Jai Kishan 12/19/2024 100 399
S.No. Product Name Sales Manager Date Units Sold Rate
1 Refrigerators Jai Kishan 6/16/2024 12 49999
2 Microwaves Jai Kishan 2/23/2024 34 56000
3 Smartphones Reena Jain 12/1/2024 56 26999
4 Tea Ramesh Vij 12/9/2024 1886 20
5 Laptops Reena Jain 9/17/2024 93 45299
6 Coffee Ramesh Vij 5/23/2024 35 359
Sales Data of X Ltd. for Delhi
S.No. Product Name Sales Manager Date Units Sold Rate
1 Board Games Pooja Sharma 03-06-2024 50 525
2 Trousers Rohan Verma 05-04-2024 124 1295.25
3 Shirts Rohan Verma 03-04-2024 74 2999.25
4 Tea Uma Shankar 08-08-2024 193 54.75
5 Laptops Pooja Sharma 24-09-2024 23 52999
6 Smartphones Uma Shankar 01-10-2024 87 72000
7 Washing Machines Rohan Verma 12-11-2024 34 56999

Sales Data of X Ltd. for Lucknow


S.No. Product Name Sales Manager Date Units Sold Rate
1 Laptops Uma Shankar 14-11-2024 81 51299
2 Smartphones Kriti Mathur 05-03-2024 100 25999.95
3 Microwaves Pooja Sharma 18-02-2024 62 43000
4 Snacks Kriti Mathur 13-12-2024 172 299
5 Washing Machines Kriti Mathur 16-01-2024 80 62000
6 Trousers Pooja Sharma 07-07-2024 128 3500

n below:
Sales Data of X Ltd. for Mumbai
S.No. Product Name Sales Manager Date Units Sold Rate
1 Shirts Jai Kishan 23-05-2024 450 499
2 Refrigerators Suparna Joshi 14-12-2024 23 34500
3 Washing Machines Ramesh Vij 29-09-2024 91 39999
4 Puzzles Suparna Joshi 12-03-2024 120 250
5 Snacks Reena Jain 07-08-2024 230 120.75
6 Tea Jai Kishan 16-01-2024 350 45
7 Board Games Jai Kishan 19-12-2024 100 399

Sales Data of X Ltd. for Surat


S.No. Product Name Sales Manager Date Units Sold Rate
1 Refrigerators Jai Kishan 16-06-2024 12 49999
2 Microwaves Jai Kishan 23-02-2024 34 56000
3 Smartphones Reena Jain 12-01-2024 56 26999
4 Tea Ramesh Vij 12-09-2024 1886 20
5 Laptops Reena Jain 17-09-2024 93 45299
6 Coffee Ramesh Vij 23-05-2024 35 359
1. Consolidate the sales data of the company: (i) region wise and (ii) overall.
2. Identify the names of the products with highest and lowest sales.
3. Identify month with highest sales.
4. Group Sales by Sales Managers.

You might also like