# Shivansh Rai

Shivansh Rai is a remote worker on Himalayas, Data Analytics Intern at InternshipStudio, based in India.

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

```text
Data Analytics Intern at InternshipStudio who turned complex datasets into KPI dashboards and business intelligence reports.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 456k-1000k INR |
| Job categories | Data Analyst, Business Analyst, Research Analyst |
| Skills | Data Analysis, Business intelligence reporting, Exploratory Data Analysis, Data Cleaning, Data Validation, Data Wrangling, ETL, Statistical Analysis, A B Testing, KPI Tracking, MIS Reporting, SQL, Python, Pandas, NumPy, Microsoft Excel (Logical Functions), Tableau, Power BI |
| GitHub | https://github.com/BigBasket-Capstone-Project |

## What I'm looking for

```text
I'm looking to bring my end-to-end analyst workflow to a consulting or insights team.
```

## About

```text
At InternshipStudio, I extracted, cleaned, and validated complex datasets using SQL and Advanced Excel, with data quality checks to maintain data integrity.

I built and deployed interactive Tableau dashboards to track KPIs, helping the team spot operational bottlenecks faster.

I used exploratory data analysis to surface sales trends, seasonal patterns, and customer behavior, then turned the findings into business intelligence reports and recommendations.

For my BigBasket Capstone Project, I analyzed consumer retail data for purchasing patterns, product affinity, and supply chain efficiencies, and created Tableau visualizations for inventory turnover and regional sales.
```

## Experience

### Data Analytics Intern

InternshipStudio. Mar 2026 - Aug 2026

```text
Extracted, cleaned, and validated complex datasets using SQL and Advanced Excel, ensuring data integrity. Built interactive Tableau dashboards to track KPIs and conducted exploratory data analysis to surface sales trends and customer behavior.
```

Skills: SQL, Excel, Tableau, Data-Cleaning, Data-Validation, Exploratory-Data-Analysis, KPI-Tracking, PowerPoint

## Education

### BITS School of Management

Minor, Business Analytics. 2026 - Present

```text
Pursuing a Minor in Business Analytics, expected to complete in September 2026.
```

### University of Lucknow

Bachelor of Commerce, Commerce. 2023 - 2026

```text
Bachelor of Commerce (B.Com) with relevant coursework in Economic Statistics, Business Administration, and Financial Accounting.
```

### IIT Patna

Certification, Applied AI and Data Intelligence

```text
Certification in Applied AI and Data Intelligence from Vishlesani Hub, IIT Patna.
```

### Deloitte

Job Simulation, Data Analytics

```text
Completed Data Analytics Job Simulation through Forage.
```

### Cisco Networking Academy

Certification, Data Analytics

```text
Completed Data Analytics Essentials certification.
```

### IBM

Certification, Generative AI

```text
Completed Generative AI in Action certification.
```

### Anthropic

Certification, AI Fluency

```text
Completed AI Fluency Framework and Foundations certification.
```

## Tech stack

- Tableau
- NumPy
- Pandas
- Node.js
- Python
- Google Sheets
- SQL
- Power BI

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

## People also viewed

- [Shruti Shekhar](https://himalayas.app/@shrutishekhar): Data Analyst Intern, Mentorness
- [Anke Jimrison](https://himalayas.app/@ankejimrison): Data Analyst Intern, InternshipStudio Data Analytics
- [Priyaranjan Bhatt](https://himalayas.app/@priyaranjanbhatt): Data Science Intern, Main Flow
- [Chaitanya User](https://himalayas.app/@chaitanyauser8): Data Analyst Intern, Analytics Space
- [Saami Anware](https://himalayas.app/@saamianware): Data Analyst Intern, Intrepedians
- [Haresh Dhasade](https://himalayas.app/@hareshdhasade): Data Analytics Intern, Internship Studio
- [Akash Anand](https://himalayas.app/@akashanand1): Associate Data Analyst Intern, Excelerate
- [Aryan NA](https://himalayas.app/@aryanna): Data Science Intern, InternBoot
- [Samim Mallick](https://himalayas.app/@samimmallick): Data Analyst Intern, AI Variant
- [Foram Garasiya](https://himalayas.app/@foramgarasiya): Data Analytics Intern, Internship Studio
