Nishant Rana

Data Analyst

Chandigarh, India 0+ yrs exp 85 · Excellent

About

MBA Business Analytics student skilled in SQL, Excel, Power BI, and Python, with hands-on experience in data cleaning, MIS reporting, dashboard development, and KPI analysis. With a background in Finance, I use data to identify trends, generate business insights, and support better decision-making. Seeking a Data Analyst / MIS Executive role.

Skills & Expertise (33)

Cross-functional coordination Intermediate

5.1/10

0.2

Years Exp

KPI Tracking Intermediate

5.1/10

0.2

Years Exp

MIS Reporting Intermediate

5.1/10

0.2

Years Exp

Business Reporting Intermediate

5.1/10

0.2

Years Exp

Data Validation Intermediate

5.1/10

0.2

Years Exp

Data Cleaning Intermediate

5.1/10

0.2

Years Exp

stakeholder communication Intermediate

5.1/10

0.2

Years Exp

Time management Intermediate

5.1/10

0.2

Years Exp

Charts Intermediate

5.1/10

0.2

Years Exp

SUMIF Intermediate

5.1/10

0.2

Years Exp

If Intermediate

5.1/10

0.2

Years Exp

VLOOKUP Intermediate

5.1/10

0.2

Years Exp

XLOOKUP Intermediate

5.1/10

0.2

Years Exp

Pivot Tables Intermediate

5.1/10

0.2

Years Exp

Excel Intermediate

5.1/10

0.2

Years Exp

Attention to Detail Intermediate

5.1/10

0.2

Years Exp

Problem-solving Intermediate

5.1/10

0.2

Years Exp

Matplotlib Beginner

3.4/10

0.2

Years Exp

Jupyter Notebook Beginner

3.4/10

0.2

Years Exp

Jira Beginner

3.4/10

0.2

Years Exp

GitHub Beginner

3.4/10

0.2

Years Exp

Machine Learning Beginner

3.4/10

0.2

Years Exp

Dashboard Development Beginner

3.4/10

0.2

Years Exp

EDA Beginner

3.4/10

0.2

Years Exp

SQL Beginner

3.4/10

0.2

Years Exp

NumPy Beginner

3.4/10

0.2

Years Exp

Pandas Beginner

3.4/10

0.2

Years Exp

Power Query Beginner

3.4/10

0.2

Years Exp

Basic DAX Beginner

3.4/10

0.2

Years Exp

Data Modelling Beginner

3.4/10

0.2

Years Exp

Power BI Beginner

3.4/10

0.2

Years Exp

Python Beginner

3.4/10

0.2

Years Exp

MySql Beginner

3.4/10

0.2

Years Exp

Work Experience

Business Analyst

SmartED

Dec 2024 - Feb 2025

Collected, cleaned, and organised business data in Excel to improve data accuracy and maintain consistent reporting. Prepared MIS reports and performance reports using Excel to track key business metrics and support regular reporting. Used Pivot Tables, VLOOKUP/XLOOKUP, IF, SUMIF, and charts to analyse data and identify useful business trends. Shared data-driven insights through reports and emails, supporting stakeholders in understanding business performance and making informed decisions.

Education

Master of Business Administration (Business Analytics & Finance) - Chandigarh University

2024 - 2026 · Afghanistan

Bachelor of Commerce (B.Com) – Finance - Himachal Pradesh University

2020 - 2023 · Afghanistan

Certifications

SQL (Basic)

HackerRank · 2026

Microsoft Excel from Beginner to Advanced

Udemy · 2026

SQL Beginner to Advanced for Data Professionals

Codebasics · 2025

Power BI for Beginners

Simplilearn · 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10

📄 Resume 10/10

💼 Job Title 10/10

✍️ Bio 10/10

🛠️ Skills 20/20

🎓 Education 10/10

⏱️ Experience 5/15

💰 Rate 0/5

🏆 Certs 5/5

✅ Verified 5/5

Total Score 85/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation

Skills (33)

Click a skill to find developers with the same skill

Cross-functional coordination KPI Tracking MIS Reporting Business Reporting Data Validation Data Cleaning stakeholder communication Time management Charts SUMIF +23 more

Similar Profiles

Abhineet Verma

Data

K Sowmya

Entry Level Data Analyst

$20/hr

yaswanth data analytics

Tableau Developer | Data Visualization Specialist

Govardhani

Data Analyst

View All Developers →