Srasti Porwal

Walmart Case Study
Analyzed raw data to derive actionable insights, improving sales strategies and contributing to data-driven decision-making at Walmart.

• Structured and analyzed data in detail using Pandas for comprehensive insights. Presented sales trends visually insightful representations. Created a pair plot to visualize relationships between numerical variables.
• Used NumPy for Calculating mean and standard deviation for male and female.
• Used hypothesis testing to conclude there is no significant difference in the mean purchase amounts between women and men using t-test.

Aerofit Case Study

Provided a better recommendation of the treadmills to the new customers.

• Checked the structure, null values, data duplicacy, outliers & characteristics of the dataset using Pandas. Analyzed product sales and customer demographics using Seaborn.
• Hypothesis Testing: Found Gender and Product type are dependent using chi-square Test. Marital Status and Product are independent using chi-square test.
• Established a positive correlation between education, income, and purchasing power using Heatmap.

Executed comprehensive on-page and off-page SEO strategies: Published WordPress blogs and analyzed traffic using Google Analytics, Google Search Console, Ahref, and other tools.
Achieved a 60% surge in organic website traffic over four years. Managed a rapid 30% increase in first-page keyword rankings.
Maintained growth, attaining a total of 50% increase in first-page rankings. Reduced bounce rate by 20% in three years, elevating user engagement.
Elevated domain authority by 60%, underscoring the website's heightened credibility

Optimized on-page elements: Updated meta tags and conducted keyword research for improved search engine visibility for 4 client projects.
Executed off-page activities: Developed strategies for link building and social media promotion to increase brand visibility and drive traffic.

Analyzed website traffic: Utilized tools like Google Analytics to monitor and provide insights into user behavior and engagement.

Executed off page activities on various third party sites. Created 2 PSDs using HTML, CSS
Created Blogs using WordPress.