Python Data Analytics & Git Bootcamp
1. E-Commerce Sales Performance Analysis
Scenario:
An online store is experiencing fluctuating sales and wants to understand which
products and months generate the highest revenue.
Tasks:
• Clean, messy sales dataset (missing values, duplicates)
• Analyze top-selling products
• Identify monthly sales trends
• Create visualizations (bar chart, line chart)
Tools Covered: Pandas, NumPy, Matplotlib
2. Student Performance & Result Analytics
Scenario:
A college wants to analyze student marks to identify toppers, weak students, and
overall class performance.
Tasks:
• Calculate average, grade, and pass/fail status
• Identify subject-wise performance
• Create performance dashboards (charts)
• Compare class-wise or subject-wise results
Tools Covered: Python basics, Pandas, Visualization
3. HR Employee Attrition Analysis
Scenario:
A company is facing high employee turnover and wants insights into why
employees are leaving.
Tasks:
• Clean employee dataset
• Analyze attrition rate by department, salary, experience
• Identify key factors affecting attrition
• Visualize trends (pie charts, bar graphs)
Tools Covered: Pandas (GroupBy), Data Cleaning, Visualization
4. Food Delivery Sales & Customer Insights
Scenario:
A food delivery company wants to understand customer ordering patterns and
popular food items.
Tasks:
• Analyze order data (time, location, item)
• Identify peak order times
• Find most popular dishes
• Create a dashboard for business insights
Tools Covered: Pandas, Filtering, Matplotlib
5. Hospital Patient Data Analysis
Scenario:
A hospital wants to analyze patient records to improve service efficiency and
understand common diseases.
Tasks:
• Clean patient dataset
• Analyze patient count by disease, age group
• Identify peak admission periods
• Visualize patient trends
Tools Covered: Data Cleaning, Pandas, Visualization