Pritam.

Initializing Analytics Engine...

Data Analyst Portfolio

Pritam
Nagar

Transforming raw data into business insights using SQL, Python, Power BI, and analytics-driven solutions.

Pritam Nagar

+

Projects Built

K+

Records Analyzed

+

Dashboards

+

Technologies

Technical Expertise

Skills & Technologies

Combining analytics, business intelligence, machine learning, and frontend technologies to build impactful digital solutions.

Analytics

PythonPandasNumPyEDA

Business Intelligence

Power BIExcelDashboardingKPI Tracking

Database

SQLPostgreSQLETLData Warehousing

Frontend

Next.jsReactTailwindTypeScript

Machine Learning

Scikit-learnStreamlitModel Training

Quality Analysis

Root Cause AnalysisDefect TrackingReporting

Analytics Intelligence

Transforming Data into Decisions

Combining data analysis, business intelligence, and visualization techniques to uncover insights and support data-driven business strategies.

KPI Formula

ROI =

(Revenue - Cost) / Cost × 100

Business intelligence metrics used to evaluate profitability, performance, and strategic growth opportunities.

SQL Analytics

SELECT region,
SUM(revenue) AS total_sales
FROM sales_data
GROUP BY region
ORDER BY total_sales DESC;

Dashboard Reporting

Interactive KPI dashboards using Power BI and analytics tools.

Data Warehousing

ETL pipelines and structured business intelligence systems.

Trend Analysis

Identifying patterns and business opportunities from datasets.

Predictive Insights

Leveraging machine learning and forecasting models.

Featured Work

Major Projects

End-to-end analytics, business intelligence, machine learning, and dashboard projects focused on solving real-world business problems.

Amazon Sales Data Warehouse

Amazon Sales Data Warehouse

Built a PostgreSQL-powered data warehouse with Power BI dashboards for revenue trends, customer insights, and regional analysis.

SQLPostgreSQLPower BIETL
GitHub
Eicher Defect Analysis Dashboard

Eicher Defect Analysis Dashboard

Designed KPI dashboards for defect tracking and root-cause analysis in manufacturing quality assurance systems.

ExcelPower QueryPower BI
GitHub
Uber Ride Analytics

Uber Ride Analytics

Analyzed ride demand patterns, cancellations, and revenue trends using business intelligence dashboards.

PythonPower BISQL
GitHub
Customer Churn Analysis

Customer Churn Analysis

Built predictive analytics workflows to identify churn behavior and retention opportunities.

PythonMachine LearningEDA
GitHub
BlinkIT Grocery Dashboard

BlinkIT Grocery Dashboard

Performed business analysis on grocery sales and outlet performance using SQL and Power BI.

SQLPythonPower BI
GitHub
Skin Cancer Classification

Skin Cancer Classification

Machine learning application for skin cancer prediction using feature engineering and Streamlit deployment.

PythonMLStreamlit
GitHub

Journey

Experience & Education

My journey across analytics, quality assurance, engineering, and business intelligence.

Quality Assurance & Data Analytics Trainee

Eicher TMTL

May 2024 - Jun 2024

Analyzed manufacturing defect data, built KPI dashboards, and supported quality assurance reporting using Excel, Power BI, and Power Query.

B.Tech Mechanical Engineering

MANIT Bhopal

2022 - 2026

Focused on Data Analytics, Business Intelligence, Machine Learning, and frontend technologies alongside core engineering.

Higher Secondary Education (Class XII)

Govt. Model HS School, Khujner

2021

Completed Higher Secondary Education with 86% and developed a strong analytical and technical foundation.

Achievements

Certifications & Learning

Continuous learning across analytics, business intelligence, machine learning, and modern technologies.

Google Data Analytics Professional Certificate

Google Data Analytics Professional Certificate

Coursera • Google

2024
Verify
Process Data from Dirty to Clean

Process Data from Dirty to Clean

Google

2024
Verify
Analyze Data to Answer Questions

Analyze Data to Answer Questions

Google

2024
Verify
Data Analysis with R Programming

Data Analysis with R Programming

Google

2024
Verify
Industrial Training – Production Department

Industrial Training – Production Department

Eicher TMTL

2024
Verify
Volunteer – BAJA SAEINDIA 2022

Volunteer – BAJA SAEINDIA 2022

SAEINDIA

2022
Verify

Open Source

GitHub Activity

Consistent contributions across analytics, machine learning, business intelligence, and frontend development projects.

Pritam9952

Data Analyst & Developer

GitHub StatsGitHub Streak

Contribution Graph

Contribution Graph

Contact

Let's Work Together

Open to Data Analyst, Business Analyst, QA, and dashboard-based opportunities.

Email

pritamnagar1211@gmail.com

Pritam.

Initializing Analytics Engine...

AI Assistant

Online

Hi 👋 I'm Pritam's AI Assistant. Ask me about skills, projects, experience, or certifications.