Data Drives Discovery!

Swapnil Pharate

Detail-Oriented Aspiring Data Analyst with good problem solving skills. Specialized in Data Analytic tools like Excel, SQL, Python, Tableau, Machine Learning. Interested in learning more. Looking for an opportunity to prove my skills in a healthy work environment.

Skills

MySQL

Python

Amazon AWS

Pandas

Numpy

Pyspark

Jupyter

Scikit-learn

GIT

Microsoft SQL Server

Tableau

Microsoft Excel

Projects

Retail Analysis

• Analyzed Retail Stored Data To Identify Behavioral Patterns. Generated Reports Using SQL Queries.

• Identified Trend In Between Rejection And Successfully Shipping Orders Rate.

• Analyzed KPIs Like Total Revenue, User Counts, Login Counts etc. For Year 2021 and 2022.

• Created Dynamic Dashboard With Interactive Graphs Using Excel.

• Techstack : Excel | SQL | Power Point

Hyundai-Price-Regression

• Build an ML model to predict Hyundai used cars prices based on different column features.

• Performed EDA (Exploratory Data Analysis), Feature engineering, and Feature selection.

• Price and Year have high positive correlation.

• From Analysing Multi Models Regressions Decision Tree Gives Best Results Among the All and Visualizing Of Predicted and Actual Data.

• Techstack : Python, Numpy, Pandas,Matplotlib, Seaborn, Sk-learn

| Power Point

Indian-Fertilizers-Case-Study

• Made a Whole Summary On Indian Fertilizer Business.

• India's Global Position In Fertilizer Market.

• Studied Future Growth In Fertilizer Sector And Its Demand.

• Find Strategies For Export Fertilizers From India.

• How India Will Be Self-Reliance In Fertilizer Production.

• Techstack : Tableau | Power Point

Brazil-E-Commerce-Sales

• Identified Sales Trends Across Different States Over The Years. Analyzed The Different Metrics Like Sales, Customer Acquisitions, Total no. Of Orders For Each Year.

• Extract Useful Data using SQL and Created Dashboard using Excel.

• It Helps To Create Sales Strategy Across Different States in the Future.

• Techstack : Excel | SQL | Power Point.

HR-Data-Analysis

The purpose of this report is to analyze the attrition data for an HR department.

The objective of this analysis is to identify the factors that contribute to employee attrition and provide recommendations to reduce it.

The HR data analysis has identified key factors contributing to employee attrition. The recommendations provided can help the organization improve employee retention and reduce the associated costs.

The HR department can implement these recommendations to improve employee engagement and job satisfaction, resulting in a more productive and loyal workforce.

Let's connect