Scribd
Upload
16 views1 page

Data Analysis Practice Dataset Guide

The document contains two datasets for data analysis practice: Sales Data and Employee Performance Data. The Sales Data includes information on orders, products, and profits, while the Employee Performance Data includes employee details, salaries, and performance metrics. Suggested analyses include total sales by region, profit percentage, and department-wise average salary.

Uploaded by

brocklessner42
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
16 views1 page

Data Analysis Practice Dataset Guide

The document contains two datasets for data analysis practice: Sales Data and Employee Performance Data. The Sales Data includes information on orders, products, and profits, while the Employee Performance Data includes employee details, salaries, and performance metrics. Suggested analyses include total sales by region, profit percentage, and department-wise average salary.

Uploaded by

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

Data Analysis Practice Dataset

1. Sales Data (Best for Beginners in Data Analysis)


Order ID Date Product Category Region Sales Quantity Profit
1001 2025-01-01 Laptop Electronics North 55000 2 8000
1002 2025-01-03 Mobile Electronics South 22000 1 2500
1003 2025-01-05 Shoes Fashion East 3500 3 900
1004 2025-01-06 Chair Furniture West 7500 2 1200
1005 2025-01-08 Fan Home Appliances North 4200 1 700
1006 2025-01-10 Watch Fashion East 6000 2 1300
1007 2025-01-12 Table Furniture South 12000 1 2000
1008 2025-01-13 Refrigerator Electronics West 34000 1 5000

■ You can analyze:


• Total sales by region (using Pivot Table)
• Profit percentage (=Profit/Sales*100)
• Most sold category
• Date-wise trends (charts)

2. Employee Performance Data


Employee ID Name Department Salary Projects Completed Overtime Hours Performance Rating
E001 Aditi Sales 40000 8 10 4.3
E002 Ravi HR 35000 6 2 3.8
E003 Meena IT 50000 10 12 4.7
E004 Arjun IT 48000 9 8 4.5
E005 Neha Marketing 42000 7 5 4.1

■ You can analyze:


• Department-wise average salary
• Correlation between overtime and rating
• Create bar charts and scatter plots

You might also like