---
title: "Rupesh Gupta - Data Analytics Project Portfolio in Dehradun | Tal"
description: "Meet Rupesh Gupta, Data Analyst | Excel · SQL · Power BI | 3 Projects · 55K+ Rows Analyzed | Open to Internships based in Dehradun."
image: "https://tal.club/meet/rupesh-gupta-1/share-image"
---

# Rupesh Gupta on Tal

## Headline

Data Analyst \| Excel · SQL · Power BI \| 3 Projects · 55K\+ Rows Analyzed \| Open to Internships

## About

I'm a self\-taught Data Analyst \(BBA background, UTU Dehradun\) who has spent the last 8 months building real projects not toy datasets, not tutorials\. Projects: Here's what I've actually done: 📊 Global Superstore Analysis — 51,290 rows across 3 PostgreSQL tables\. Full pipeline: Excel cleaning → SQL analysis → Power BI dashboard\. Key finding: 24\.45% of orders were loss\-making due to excessive discounting a finding that directly maps to a pricing strategy decision\. 🏥 Healthcare Analytics — 54,966\-row Kaggle dataset\. SQL queries, Excel pivot tables, visual summaries of patient admission trends\. 📦 Hospital Data Analysis\- Executed end\-to\-end data cleaning, pivot\-table analysis, and SQL querying to extract admission trends and surface departmental bottlenecks\. All projects are documented on GitHub with business context, not just code\. Tools: Excel \(VLOOKUP, Power Query, Pivot Tables\) · SQL / PostgreSQL \(Joins, Subqueries, Window Functions\) · Power BI \(DAX, Dashboards\) · Google Data Analytics Certificate — 4 of 8 complete My BBA background isn't a limitation\. It means I understand the business question before I touch the data\. 📩 rupesh\.dataanalyst@gmail\.com 🔗 github\.com/rupesh\-gupta\-data Open to Data Analyst internships remote or on\-site, anywhere in India

## Location

Dehradun

## Work experience

Data Analytics Project Portfolio at Independent, Oct 2024 \- Present · 1 yr 9 mos, •Designed end\-to\-end analytics pipelines for 3 datasets totaling 160,000\+ rows from raw data ingestion to business\-ready dashboards in Power BI\. •Identified that 24\.45% of retail orders were loss\-making due to discounting patterns; quantified impact across 3 product categories using SQL window functions\. •Wrote recruiter\-readable GitHub READMEs documenting methodology, tools, and business recommendations for each project

## Education

Bachelor of Business Administration \- BBA, Veer Madho Singh Bhandari Uttarakhand Technical University \(UTU\)

XII and X, Business/Commerce, General, Doon Cambridge School

[View the original profile](https://tal.club/meet/rupesh-gupta-1)

```json
{
  "@context": "https://schema.org",
  "@graph": [
    {
      "@type": "Person",
      "@id": "https://tal.club/meet/rupesh-gupta-1#person",
      "name": "Rupesh Gupta",
      "url": "https://tal.club/meet/rupesh-gupta-1",
      "image": "https://tal.club/meet/rupesh-gupta-1/profile-photo.jpg",
      "description": "Meet Rupesh Gupta, Data Analyst | Excel · SQL · Power BI | 3 Projects · 55K+ Rows Analyzed | Open to Internships based in Dehradun.",
      "jobTitle": "Data Analytics Project Portfolio",
      "worksFor": {
        "@type": "Organization",
        "name": "Independent"
      },
      "hasOccupation": {
        "@type": "Occupation",
        "name": "Data Analytics Project Portfolio"
      },
      "homeLocation": {
        "@type": "Place",
        "name": "Dehradun"
      },
      "alumniOf": [
        {
          "@type": "EducationalOrganization",
          "name": "Veer Madho Singh Bhandari Uttarakhand Technical University (UTU)"
        },
        {
          "@type": "EducationalOrganization",
          "name": "Doon Cambridge School"
        }
      ],
      "mainEntityOfPage": {
        "@id": "https://tal.club/meet/rupesh-gupta-1#webpage"
      }
    },
    {
      "@type": "ProfilePage",
      "@id": "https://tal.club/meet/rupesh-gupta-1#webpage",
      "url": "https://tal.club/meet/rupesh-gupta-1",
      "name": "Rupesh Gupta on Tal",
      "description": "Meet Rupesh Gupta, Data Analyst | Excel · SQL · Power BI | 3 Projects · 55K+ Rows Analyzed | Open to Internships based in Dehradun.",
      "dateModified": "2026-06-10T13:55:48.219Z",
      "isPartOf": {
        "@id": "https://tal.club/#website"
      },
      "mainEntity": {
        "@id": "https://tal.club/meet/rupesh-gupta-1#person"
      },
      "primaryImageOfPage": {
        "@type": "ImageObject",
        "url": "https://tal.club/meet/rupesh-gupta-1/profile-photo.jpg",
        "contentUrl": "https://tal.club/meet/rupesh-gupta-1/profile-photo.jpg",
        "caption": "Rupesh Gupta profile photo on Tal"
      },
      "inLanguage": "en-IN"
    }
  ]
}
```