YASH PORWAL

Data Analyst
A-83;84 Khyala, 110018, Delhi, IN.

About

Highly analytical Data Analyst with expertise in SQL, Python, Power BI, and Tableau, adept at transforming complex datasets into actionable insights. Proven ability to leverage data cleaning, exploratory data analysis (EDA), and statistical modeling to drive data-informed decision-making and optimize performance. Eager to apply expanding knowledge in cloud and big data technologies to enhance analytical capabilities in a dynamic professional environment.

Projects

Independent Data Analysis Project
|

Data Analyst

Vellore, Tamil Nadu, India

Summary

Conducted student trend analysis using SQL and Tableau, identifying key correlations and delivering actionable insights to improve student performance and engagement.

Highlights

Executed comprehensive student trend analysis utilizing SQL for robust data transformation, cleaning, and feature engineering, successfully identifying key correlations to inform educational strategies.

Designed and developed an interactive Tableau dashboard featuring dynamic visualizations, delivering actionable insights that enhanced student performance and engagement by an estimated 15-20% through targeted interventions.

Retail Sales and Customer Insights Analysis
|

Data Analyst

Vellore, Tamil Nadu, India

Summary

Executed sales and customer analysis using Excel, Pivot Tables, and Conditional Formatting to identify purchasing trends and segment customers, supporting data-driven decision-making.

Highlights

Conducted in-depth sales and customer analysis using Excel, Pivot Tables, and Conditional Formatting, identifying critical purchasing trends and segmenting customers to inform targeted marketing strategies.

Implemented robust data cleaning and transformation techniques, ensuring 99% data accuracy and consistency, which yielded highly reliable insights for strategic planning.

Designed and developed interactive dashboards to visualize key sales performance metrics, improving data-driven decision-making and contributing to a clearer understanding of market dynamics.

Education

Vellore Institute Of Technology
Vellore, Tamil Nadu, India

B.Tech

Electronics And Communication Engineering In Ai And Cybernetics

Courses

Database Management Systems

Operating System

Computer Network

Data Warehousing and Mining

Certificates

Python Essentials, Fundamentals of AI & ML

Issued By

VITYARTHI

Excel for Beginners to Advanced with ChatGPT and Copilot

Issued By

Online Learning Platform

Data Analyst Bootcamp- Basics to Advanced

Issued By

Online Learning Platform

MATLAB – MATLAB Fundamentals

Issued By

Online Learning Platform

Skills

Technical Skills

Python, SQL, Microsoft Power BI, Tableau, Excel, Statistics, Exploratory Data Analysis, Data Cleaning and Preprocessing, Feature Engineering, Data Visualization.

Databases

MySQL, PostgreSQL, SQL Server Management Studio.

Soft Skills

Analytical Thinking, Cross-Functional Collaboration, Verbal Communication, Task Prioritization, Project Coordination.