Immediate joiner · Open to relocation

Ashish
Rawat.

Data Analyst · AI & Data Science

›

Aspiring Data Analyst with hands-on experience in SQL, Python, Power BI, Excel, and Streamlit. I turn raw operational data into clean analysis, interactive dashboards, and decisions people can act on.

View Projects Hire Me Resume

Projects

Roles

Certifications

MCA Score %

analytics_summary.bi

📊 Dashboard Projects 2

⚡ Current Role Intern

🎯 Core Stack SQL + Python

📉 Live Delivery Streamlit

Power BICore

SQLCore

PythonCore

About Me

Turning Data Into Decisions

I'm an aspiring Data Analyst with an MCA in Artificial Intelligence & Data Science from Graphic Era Hill University and a practical toolkit across SQL, Python, Power BI, Excel, and Streamlit.

As a Data Analyst Intern at Unified Mentor, I work on real-world projects, including shipping-route efficiency analysis for a candy distributor using Python and Pandas, delivered through a live dashboard.

My earlier customer support experience at Concentrix taught me how to work carefully with operational data, maintain accurate records, and build Excel trackers that connect performance metrics to day-to-day work.

📍
Location
Dehradun, India

🎓
Degree
MCA – AI & DS · 81%

⚡
Availability
Immediate Joiner

✈️
Relocation
Willing to Relocate

Name: Ashish Rawat
Email: Ashishrawat.da@gmail.com
Phone: +91 9105335275
GitHub: github.com/Ashish-da
LinkedIn: linkedin.com/in/ashish-da
Current Role: Data Analyst Intern
Core Tools: SQL, Python, Power BI, Excel

              Resume Summary

Aspiring Data Analyst with an MCA in AI & Data Science and hands-on project experience in SQL, Python, Power BI, and Excel-based dashboard design. Currently building real-world analytics projects as a Data Analyst Intern. Immediate joiner and open to relocation.

Technical Skills

Skills & Expertise

A comprehensive toolkit for end-to-end data analytics — from raw data wrangling to production-ready dashboards.

Microsoft Excel

Pivot Tables & Power Query90%

VLOOKUP / Advanced Formulas85%

Dashboard Reporting88%

SQL

Joins & Subqueries80%

Aggregations & Filtering82%

Query Optimization72%

Power BI

Interactive Dashboards80%

DAX Formulas70%

KPI Monitoring85%

Python

Pandas / NumPy75%

Data Cleaning & EDA78%

Streamlit Dashboards70%

Data Analytics

Tools & Platforms

Portfolio

Featured Projects

Real-world data analytics projects demonstrating end-to-end analytical thinking, dashboard development, and business impact.

📊

Power BI

EV Market Analysis Dashboard

Built a multi-page interactive dashboard to analyze EV market trends, vehicle performance, and brand comparisons.

Created dynamic KPIs for range, battery capacity, charging time, horsepower, torque, and top speed

Transformed source data with Power Query and built a structured data model

Presented actionable insights through interactive report pages

Power BIDAXPower QueryExcel

📈

Power BI

Sales Performance Dashboard

Developed an end-to-end sales dashboard tracking revenue, profit, customer performance, and regional sales trends.

Designed KPI cards, drill-through analysis, and dynamic filters with DAX

Structured an optimized data model for efficient reporting

Translated sales patterns into decision-ready business views

Power BIDAXPower QueryExcel

🐍

Python

Shipping Route Efficiency Analysis

Built an end-to-end analysis for a candy distributor as part of the Unified Mentor internship, covering data cleaning, geographic bottleneck analysis, and ship-mode comparison.

Cleaned and explored operational shipping data with Python and Pandas

Compared ship modes and surfaced route efficiency patterns

Delivered the analysis as a live Streamlit dashboard published on GitHub

PythonPandasStreamlitGitHub

🗃️

SQL

SQL Data Analysis Project

Performed exploratory analysis across customer, sales, and operational datasets using MySQL to identify trends, business insights, and performance metrics.

Applied JOINs, CTEs, window functions, aggregates, and subqueries

Optimized queries for efficient data retrieval

Developed analytical reports for data-driven decisions

MySQLCTEsWindow FunctionsEDA

Work History

Work Experience

Data Analyst Intern

Unified Mentor Pvt. Ltd. · Gurugram, India (Remote)

Jul 2026 – Present

Work on real-world data analytics projects as part of a structured internship program.
Built an end-to-end shipping route efficiency analysis for a candy distributor using Python and Pandas.
Covered data cleaning, geographic bottleneck analysis, and ship-mode comparison.
Delivered the analysis as a live, interactive Streamlit dashboard published on GitHub.

Python Pandas Streamlit GitHub

Customer Support Executive – Chat & Email

Concentrix · Gurugram, India

Sep 2023 – Oct 2024

Provided customer support through chat and email while maintaining service quality and SLA standards.
Maintained a personal Excel performance tracker using Pivot Tables and VLOOKUP to monitor KPIs over time.
Maintained accurate customer interaction records to support consistent, high-quality service delivery.

ExcelKPI TrackingCRM

Academics