Portfolio - ARTI | Codebasics

Hello, I am

ARTI

Data Aspirant

Resume

1

Excel
Project

About

I’m a data enthusiast with a strong foundation in data analysis, visualization, and business intelligence, skilled in Power BI, SQL, Excel, and Python. I’m passionate about applying analytical thinking to real-world problems through hands-on projects.

I enjoy turning raw data into clear, actionable insights that drive business decisions. From creating interactive Power BI dashboards to writing optimized SQL queries, I focus on accuracy, clarity, and visual storytelling.

Curious by nature, I constantly explore new techniques to improve my skills and stay ahead in analytics. My goal is to grow as a data analyst who bridges the gap between data and decision-making.

📩 Open to data analytics opportunities where I can learn, contribute, and deliver value through data-driven insights.

My

Projects

India vs New Zealand Teams Comparison

Domain/Function: Sports Domain

This Excel-based project analyzes candidate of India and NZ to uncover trends in employee performance, salary distribution, and customer service efficiency. The analysis covers data cleaning, exploratory data analysis (EDA), pivot tables, and dashboard creation.

My

Experience

Analyst May 2025– June 2025

Future Interns India

Task1: Road Accident Analysis Project | Excel Dashboard

• Built an interactive dashboard analysing 2021 & 2022 road accident data using Microsoft Excel.

• Tracked key metrics: Casualties by severity, vehicle type, road type, road surface, and light condition.

• Used PivotTables, slicers, custom columns, and interactive filters to compare Current Year vs Previous Year trends.

• Stakeholders: Ministry of Transport, Road Safety Corps, Police Force, Media, Emergency Services, Public.

Task 2: Social Media Analytics Dashboard | Power BI

• Built an interactive Power BI dashboard to monitor performance across Facebook, Instagram, and Twitter using marketing data.

• Tracked key KPIs, including followers, impressions, and engagements, offering platform-wise comparative insights

Awards

& Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Data Analyst for Beginner by Udemy

Hp Life

Contact Me

Email

[email protected]

Github

https://github.com/ARTI-ui

https://www.linkedin.com/in/arti-singh-116249341

ARTI

Data Aspirant

Download Resume

Resume

Excel Project

India vs New Zealand Teams Comparison

Domain/Function: Sports Domain

View Project
Engagement

View Project
on GitHUB

Male vs Female comparison

Salary Expand.

Project Details

Key Steps in Analysis:
1️⃣ Cleaning & Preparing Data – Fixed inconsistencies, handled missing values, and structured data before analysis.
2️⃣ Exploratory Data Analysis (EDA) – Used formulas like COUNTIFS, SUMIFS, XLOOKUP to extract insights.
3️⃣ Power Query Magic – Combined multiple datasets for better insights.
4️⃣ Pivot Tables for Quick Insights – Analyzed male vs. female salaries, bonus calculations, and regional comparisons.
5️⃣ Visualizing Data – Created histograms, box plots, and trend charts.
6️⃣ Dashboard & Reports – Applied formatting tricks, conditional formatting, and data validation for cleaner reports.

📊 Key Insights:
Salary Distribution – Histograms & Box Plots showed salary spread and variation.
Performance & Rating Relationship – Explored how salary relates to performance ratings.
Staff Growth Over Time – Trend analysis of workforce expansion.
Regional Scorecard – Compared between New Zealand and India.

Hello, I am

ARTI

1

About

My

India vs New Zealand Teams Comparison

My

Awards

Contact Me

Email

Github

Linkedin

ARTI

Download Resume