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