Scribd
Upload
26 views3 pages

Power Query Assignment

The document contains sales data for various products across different regions and months, detailing units sold, unit price, and total sales. It also includes customer information such as ID, name, age, gender, location, and loyalty score. Additionally, product details like name, category, supplier, cost, and price are provided.

Uploaded by

rythmbansal1
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
26 views3 pages

Power Query Assignment

The document contains sales data for various products across different regions and months, detailing units sold, unit price, and total sales. It also includes customer information such as ID, name, age, gender, location, and loyalty score. Additionally, product details like name, category, supplier, cost, and price are provided.

Uploaded by

rythmbansal1
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/ 3

Date Product ID Category Region SalespersonUnits Sold Unit Price Total Sales Customer ID

2023-01-31 00:00:00 101 ElectronicsNorth Alice 10 100 1000 n1


2023-02-28 00:00:00 102 Clothing South Bob 15 50 750 s1
2023-03-31 00:00:00 103 Furniture East Charlie 8 200 1600 e1
2023-04-30 00:00:00 104 Toys West David 20 30 600 w1
2023-05-31 00:00:00 105 Groceries North Eve 30 10 300 n1
2023-06-30 00:00:00 101 ElectronicsSouth Alice 10 100 1000 s1
2023-07-31 00:00:00 102 Clothing East Bob 15 50 750 e1
2023-08-31 00:00:00 103 Furniture West Charlie 8 200 1600 w1
2023-09-30 00:00:00 104 Toys North David 20 30 600 n1
2023-10-31 00:00:00 105 Groceries South Eve 30 10 300 s1
2023-11-30 00:00:00 101 ElectronicsEast Alice 10 100 1000 e1
2023-12-31 00:00:00 102 Clothing West Bob 15 50 750 w1
2024-01-31 00:00:00 103 Furniture North Charlie 8 200 1600 n1
2024-02-29 00:00:00 104 Toys South David 20 30 600 s1
2024-03-31 00:00:00 105 Groceries East Eve 30 10 300 e1
2024-04-30 00:00:00 101 ElectronicsWest Alice 10 100 1000 w1
2024-05-31 00:00:00 102 Clothing North Bob 15 50 750 n1
2024-06-30 00:00:00 103 Furniture South Charlie 8 200 1600 s1
2024-07-31 00:00:00 104 Toys East David 20 30 600 e1
2024-08-31 00:00:00 105 Groceries West Eve 30 10 300 w1
Customer ID Name Age Gender LocationLoyalty Score
n1 John 25 Male New York 80
s1 Jane 30 Female Los Angele 75
e1 Sam 35 Male Chicago 90
w1 Lucy 40 Female Houston 85
n1 Mike 28 Male Phoenix 95
s1 Nina 32 Female New York 80
e1 Tom 45 Male Los Angele 75
w1 Kate 50 Female Chicago 90
n1 Paul 38 Male Houston 85
s1 Laura 27 Female Phoenix 95
e1 John 25 Male New York 80
w1 Jane 30 Female Los Angele 75
n1 Sam 35 Male Chicago 90
s1 Lucy 40 Female Houston 85
e1 Mike 28 Male Phoenix 95
w1 Nina 32 Female New York 80
n1 Tom 45 Male Los Angele 75
s1 Kate 50 Female Chicago 90
e1 Paul 38 Male Houston 85
w1 Laura 27 Female Phoenix 95
Product ID
Product NameCategory Supplier Cost Price
101 Laptop ElectronicsSupplier A 80
102 T-Shirt Clothing Supplier B 30
103 Sofa Furniture Supplier C 150
104 Toy Car Toys Supplier D 20
105 Rice Bag Groceries Supplier E 5

You might also like