Nikita Pardeshi

Data Analyst

0+ yrs exp 83 · Excellent

About

Data Analyst with a strong foundation in SQL, Python, Excel, and Power BI. Skilled in cleaning, analyzing, and visualizing data to generate insights and support data-driven decision-making. Interested in collaborating on meaningful analytical work in fast-paced environments.

Skills & Expertise (13)

Advanced MS Excel Advanced

8.0/10

Years Exp

SQL Intermediate

7.4/10

Years Exp

Power BI Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Exploratory data analysis Intermediate

7.0/10

Years Exp

Python Intermediate

6.8/10

Years Exp

Insight Generation Intermediate

6.0/10

Years Exp

Descriptive Statistics Intermediate

6.0/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

Matplotlib Intermediate

6.0/10

Years Exp

SQL Server Intermediate

6.0/10

Years Exp

Tableau Intermediate

5.0/10

SQLAlchemy Intermediate

5.0/10

Work Experience

Data Analytics Virtual Experience

Deloitte (Forage)

Apr 2026 - Apr 2026

Processed and standardized a dataset of 100,000+ rows from multiple regions to enable KPI tracking across time and geography. Built advanced Excel templates using lookup functions and pivot tables, reducing reporting effort by 40%. Developed interactive dashboards in Power BI to analyze revenue trends, customer segmentation, and monthly performance. Collaborated in a simulated business setting to define and validate 6 KPIs, improving clarity and consistency in reporting.

Project

Airline Price Analysis

Apr 2026 - May 2026

Performed exploratory data analysis on airline dataset (250+ records) to understand pricing patterns. Engineered features such as journey dates and weekday/weekend classification for deeper insights. Analyzed pricing trends across airlines, routes, and travel classes to identify cost drivers. Visualized distributions and trends using Matplotlib to highlight pricing patterns and outliers. Integrated dataset with SQL Server using SQLAlchemy and pyodbc for structured storage and querying.

Project

Employee Analytics Dashboard

Nov 2025 - Dec 2025

Processed and cleaned employee dataset (500+ records) including department, salary, attendance, and attrition metrics. Built dynamic dashboards using Pivot Tables, slicers, and charts to track headcount and attrition rate. Automated reporting using advanced Excel formulas (XLOOKUP, IF, COUNTIFS), reducing manual effort. Identified trends in employee attrition and absenteeism for workforce planning.