Hi, I'm Pritam Nagar

Final-year B.Tech Mechanical Engineering @ NIT Bhopal

View Projects Email Me LinkedIn GitHub

At a Glance

Data Analytics • Visualization • Frontend

Python SQL Power BI Excel HTML CSS JavaScript

Skills & Tools

A toolbox focused on analytics, dashboards, and UI.

Data Python • Pandas • Numpy
BI Power BI • DAX • Power Query
DB MySQL • SQL Joins • Views
Excel Pivots • Charts • Automation
Web HTML • CSS • JavaScript
Viz Matplotlib • Seaborn • Plotly

Featured Projects

Deeper cards with tech stack + outcomes.

Eicher dashboard

Defect Analysis Dashboard — Eicher TMTL

Excel + Power Query dashboard for real-time scratch/defect tracking in tractor lines.

Excel Power Query ETL
More details
  • Automated weekly refresh & trend snapshots.
  • Root-cause drilldowns for QA team.
  • Reduced manual reporting overhead.
Source
Hospital system

Hospital Management System

Python + SQL application for patient, staff, billing & appointment workflows.

Python MySQL Data Model
More details
  • Designed normalized schema & CRUD operations.
  • Reports for occupancy and revenue.
  • Modular codebase for easy extension.
Source
Real estate ML

Dragon Real Estate — Price Prediction

ML regression on housing data with EDA, feature engineering & evaluation.

Python Scikit-learn Pandas
More details
  • Handled missing values & outliers robustly.
  • Compared Linear Regression vs. Random Forest.
  • Visualization of drivers impacting price.
Source
IPL analytics

IPL Data Analysis

Exploratory analytics on batting strike rates & match patterns.

Python Pandas Matplotlib
More details
  • Season-wise strike-rate trends & powerplay insights.
  • Top performers & consistency metrics.
Source
BlinkIT Grocery Sales Dashboard

BlinkIT Grocery Sales Analysis

SQL, Power BI, and Python to extract insights, visualize trends, and enhance decision-making for business growth.

Python SQL Power BI
More details
  • Built an interactive Power BI dashboard.
  • Performed data cleaning & transformation using Python and SQL.
  • Visualization of drivers impacting priceAnalyzed sales patterns, customer preferences, ratings, and outlet performance..
Source
Uber Cab Data Analysis Dashboard

🚖 Uber Cab Data Analysis & Dashboard

Analyzed Uber ride data using Python, SQL, and Power BI to uncover patterns in rides, revenue, cancellations, and payment methods. Built an interactive dashboard for business insights.

Python Power BI SQL
More details
  • Performed data cleaning, transformation, and exploratory data analysis using Python.
  • Built an interactive dashboard in Power BI/Tableau for visualization and KPIs tracking.
  • Analyzed ride patterns, monthly revenue trends, payment method performance, and cancellations.
  • Identified top drop locations, peak booking hours, and key business insights.
Source

Experience

Industry exposure & contributions.

Eicher TMTL — Trainee (May–June 2024) Bhopal

Contact

Open to internships & full-time roles in Data Analytics and Frontend.

Let's build something great

Email: pritamnagar2211@gmail.com

LinkedIn GitHub Portfolio

About Me

Final-year B.Tech Mechanical Engineering student at NIT Bhopal with a strong focus on Data Analytics, Visualization, and Frontend Development.

I enjoy transforming raw data into actionable insights and building responsive, user-friendly applications. Outside work, I explore new tech and polish open-source projects.