# Vansh Mittal

Vansh Mittal is a remote worker on Himalayas, Data Analyst Intern at AI Variant, based in India.

Source: https://himalayas.app/@vanshmittal1

```text
Data Analyst at AI Variant who developed sales and manufacturing dashboards with Excel, Power BI, and Tableau.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 399k+ INR |
| Job categories | Data Analyst, Business Analyst, Dashboard Developer |
| Skills | Data Analysis, Dashboard Design, KPI Tracking, Data Cleaning, Business Reporting, Data Visualization, Descriptive Statistics, SQL, Excel, Pivot Tables, Pivot Charts, V Lookups, Power Query, Power BI, Tableau |

## About

```text
At AI Variant, I completed a project-based Data Analyst internship focused on interactive business dashboards using real-world datasets. I worked on sales analytics and manufacturing operations.

For the AdventureWorks Sales Analysis project, I built an Excel dashboard to analyze sales trends, product performance, and revenue patterns, and developed a Power BI dashboard for regional sales and business metrics.

I also wrote SQL queries to analyze sales data and identify revenue trends, product performance insights, top revenue-generating categories, and seasonal demand peaks.

For the Manufacturing Analytics Dashboard (Axon Labels), I built an Excel dashboard tracking produced quantity, rejected quantity, and wastage percentage, and developed a Tableau dashboard for machine- and employee-level production performance. I consolidated fragmented production data into a structured dashboard and wrote SQL queries to analyze rejection and wastage trends.
```

## Experience

### Data Analyst Intern

AI Variant. Oct 2025 - Apr 2026

```text
Completed a project-based internship focused on building interactive business dashboards for real-world datasets. Worked on 2 projects covering sales analytics and manufacturing operations.
```

Skills: Excel, Power-BI, Tableau, SQL, Pivot-Tables, Pivot-Charts, Dashboard-Design, KPI-Tracking, Data-Cleaning, Business-Reporting, Data-Visualization

## Education

### Kurukshetra University

Bachelor of Computer Applications, Computer Applications

```text
Pursuing a Bachelor of Computer Applications (BCA) at Kurukshetra University, DAV College, Karnal.
```

### IIT Jammu

Certificate Program on Data Analyst, Data Analysis

```text
Completed a Certificate Program on Data Analyst (Cohort 3) from IIT Jammu.
```

### NASSCOM

Data Analysis Certification, Data Analysis

```text
Earned a Data Analysis Certification from NASSCOM.
```

### AI Variant

Data Analyst Internship Completion Certificate, Data Analysis

```text
Completed a Data Analyst Internship Certification from AI Variant, Bangalore.
```

### ExcelR

Data Analytics Certification, Data Analytics

```text
Earned a Data Analytics Certification from ExcelR.
```

## Tech stack

- Tableau
- NumPy
- Pandas
- Python
- SQL
- Power BI

To contact Vansh, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Glavin Menezes](https://himalayas.app/@glavinmenezes): Data Analyst Intern, AIVariant
- [Chinnolla Sri Ram Goud](https://himalayas.app/@chinnollasriramgoud): Data Analyst Intern, Dataview Analytics
- [Akshay Juluru](https://himalayas.app/@akshayjuluru): Data Analytics Virtual Intern, AICTE
- [Hemalatha chikkalappa nagaraju gari](https://himalayas.app/@hemalathachikkalappa): Data Analyst Intern, Internship
- [Naveen Dummu](https://himalayas.app/@naveendummu): Data Analyst, Internzvalley
- [Priyanka D](https://himalayas.app/@priyankad1): Data Analyst Intern, AI Variant
- [Prathamesh Chinchole](https://himalayas.app/@prathameshchinchole): Data Analyst Intern, AI Variant
- [Deepti Patil](https://himalayas.app/@deeptipatil1): Data Analytics Intern Trainee, AI Varient
- [Saami Anware](https://himalayas.app/@saamianware): Data Analyst Intern, Intrepedians
- [Samim Mallick](https://himalayas.app/@samimmallick): Data Analyst Intern, AI Variant
