Pranit Patil

1) Budget Sales Analysis ● Explored sales data and utilized statistical techniques using Python, extracted information on Products, resulting in a 20% increase in Profit. ● Implemented data cleansing and data wrangling on customer data, resulting in customer segmentation analysis that revealed 45% of the clientele are between the ages of 40-59, leading to targeted marketing campaigns with improved precision. ● Analyzed order processing data and defined an average order that has a 7-day gap between factory export readiness and shipping, prompting process improvements resulting in a 50% reduction in the gap. ● Achieved correlation analysis and found a strong negative correlation (-0.8) between Price and Quantity ordered, leading to pricing adjustments that increased sales volume by 25%. 2) Heart Disease Diagnostic Analysis ● Validated data and found that 45.87% of individuals are suffering from heart disease, highlighting the need for preventative measures. ● Investigated symptoms of heart disease and discovered that individuals with asymptomatic chest pain of about 105 have a higher chance of heart disease. ● Regulated a correlation analysis and found 80% of males and 62.5% of females with heart disease also have elevated cholesterol levels, highlighting the importance of managing cholesterol.