Data Analyst Portfolio

Hi, I'm Nikunj Agarwal.

Data Analyst | Python | SQL | Power BI

I'm a motivated Data Science undergraduate seeking to contribute as a Data Analyst where I can apply my skills in data analysis, visualization, and problem-solving to help businesses make better decisions. I enjoy working with data – finding patterns, building dashboards, and turning numbers into stories that people can actually act on.

I build insights with  |
View / Download CV View Projects Contact
nikunjagarwal532@gmail.com +91 9548257079 LinkedIn GitHub
Nikunj Agarwal

Nikunj Agarwal

Data Analyst • Power BI • SQL • Python

Location Agra, Uttar Pradesh
Role Data Analyst
Focus Dashboards & EDA
Strength KPI & Trend Analysis
Data Analyst Power BI DAX Data Visualization Dashboard Development Business Intelligence SQL Python Excel
Turning raw data into actionable insights that drive business decisions.

About

Profile

I'm a motivated Data Science undergraduate seeking to contribute as a Data Analyst where I can apply my skills in data analysis, visualization, and problem-solving to help businesses make better decisions.

I enjoy working with data – finding patterns, building dashboards, and turning numbers into stories that people can actually act on. Eager to grow in a collaborative environment and take on real-world challenges.

  • Power BI dashboards (DAX, Power Query, data modeling)
  • Python & SQL for data analysis and cleaning
  • Excel for business reporting and ad-hoc analysis
  • Cross-functional collaboration and stakeholder communication

What I deliver

Dashboards KPI views with drill-down
Insights Trends, patterns & drivers
Reports Automated business reporting
Data Cleaning ETL & transformation pipelines
0 + Projects
0 + Certifications
0 .0 CGPA
0 + Experiences

Skills

Core Skills

Power BI

Dashboards, DAX, Power Query

SQL (MySQL)

Complex Queries, Joins, CTEs

Python

Pandas, NumPy, Matplotlib

Microsoft Excel

Pivot Tables, VLOOKUP, Charts

DAX

Measures, Calculated Columns

Data Cleaning & EDA

Transformation & ETL

Toolbox

Power BI Desktop MySQL Workbench Jupyter Notebook Pandas NumPy Matplotlib Power Query Data Modeling Pivot Tables VLOOKUP KPI Analysis Data Visualization Dashboards Business Reporting

Projects

Zepto Sales Dashboard

Zepto Sales & Demand Analytics

Power BI SQL Data Analysis

Nov 2025

Zepto Sales & Demand Analytics Dashboard

Analysed a catalogue of 3,700+ products across 15 categories, covering 796K units sold and ₹2M in total revenue at a 7.6% average discount. Identified the highest revenue-driving categories and built a 2-page interactive dashboard.

GitHub LinkedIn
Earthquake Analysis Dashboard

Global Earthquake Risk & Trend Analysis

Power BI Python EDA

Nov 2025

Global Earthquake Risk & Trend Analysis

Analysed 20 years of global earthquake data (775 records) to identify 4 high-risk geographic zones and uncover trends in earthquake frequency and severity over time. Presented findings through an interactive Power BI dashboard.

GitHub LinkedIn
World Layoffs Data Cleaning

World Layoffs SQL Data Cleaning

SQL MySQL Data Cleaning

Mar 2025

World Layoffs SQL Data Cleaning

Cleaned a real-world global layoffs dataset using a structured 5-step SQL pipeline – created a staging table, removed duplicates, standardized company names, fixed date formats, and filled missing industry values using a self-join.

GitHub LinkedIn
Retail Sales Analysis

Retail Sales Business Analysis

SQL Excel Business Analysis

Mar 2026

Retail Sales Business Analysis

Analysed retail transaction data for Wayne Inc. (NY & LA) to improve profit margins. Identified top 5 multi-store customers for a targeted 10% discount campaign, confirmed TV campaign boosted revenue, and flagged Store LA_333 as a low-risk closure candidate.

GitHub LinkedIn

Experience

Internships

Data Analytics Intern

CopG Global Pvt. Ltd. • Jun 2025 – Jul 2025
  • Worked on real-world datasets across the full analytics pipeline
  • Cleaning and preprocessing raw data for analysis
  • Built visualizations to support internal business reporting and decision-making

Tools: Python, SQL, Power BI, Excel

Job Simulations

Data Analytics Job Simulation

Deloitte Australia (Forage) • Jun 2025
  • Analysed 160,704 telemetry records across 4 factories in Japan, Germany, and China
  • Identified daikibo-factory-seiko as the highest-risk facility
  • Flagged LaserWelders and LaserCutters as the most failure-prone machine types

Tools: Data Analysis, Risk Assessment, Manufacturing Analytics

Data Visualisation Job Simulation

Tata (Forage) • Jun 2025
  • Framed 8 strategic questions across CEO and CMO perspectives
  • Covered revenue trends, customer retention, and marketing ROI
  • Built a Power BI dashboard to communicate findings to senior leadership

Tools: Power BI, Strategic Thinking, Dashboard Design

Education

B.Tech in Computer Science Engineering

Specialization: Data Science

Swami Keshwanand Institute of Technology, Jaipur

2023 – Present CGPA: 9.0

Schooling

Senior Secondary (Class XII) — CBSE Board

Agra, Uttar Pradesh

2022 Percentage: 90.4%

Secondary (Class X) — CBSE Board

Agra, Uttar Pradesh

2020 Percentage: 95%

Certifications

SQL (Advanced)

HackerRank

Complete Data Science Bootcamp

Udemy

SQL 50

LeetCode

Contact

I'm actively looking for Data Analyst opportunities. Whether you have a question, a project idea, or just want to say hello — my inbox is always open!

Quick contact

nikunjagarwal532@gmail.com +91 9548257079 LinkedIn GitHub

Location: Agra, Uttar Pradesh, India

Message form