Netransh Parashar

Data Aspirant

[email protected] +91 7987209169

Resume

Hello, I am

Netransh Parashar.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

About Me

I’m Netransh Parashar, a recent B.Tech graduate in Artificial Intelligence & Data Science with a keen interest in transforming data into actionable insights.
During my internship at Smollan India, I was involved in data validation and manual testing, ensuring accuracy and reliability in business reporting workflows. I've also worked on academic and personal projects involving tools like Power BI, Tableau, Excel, and SQL, with hands-on experience in analyzing real-world datasets.
From evaluating Fitbit fitness tracker data to simulating IPL auction strategies using SQL, I enjoy breaking down complex problems and creating clear, data-driven solutions.
I’m eager to apply my analytical mindset and technical skills to solve business challenges and contribute meaningfully as a data analyst.

Key Skills

Power BI

Tableau

Excel

SQL

Python

My SQL

Google Sheets

My Projects

Fitbit Fitness Tracker Data Analysis for WeFit & Subsidiaries

Domain/Function: Data Analytics / Health & Wellness

Hospitality Analysis – Hotel Chain Business

Domain/Function: Business Intelligence / Hospitality Analytics

Sales Performance – The Bike Haven

Domain/Function: Sales Analytics / Business Intelligence

Business 360 – Brick & Mortar and E-commerce

Domain/Function: Retail Analytics / Business Intelligence

Auction Strategy – IPL Franchise Team Building

Domain/Function: Sports Analytics / Data Strategy

My Experience

Data Analyst Intern – Smollan India
Oct 2024 – Apr 2025
• Conducted data validation and manual testing of reporting workflows to ensure accuracy, consistency, and reliability across business datasets.
• Collaborated with cross-functional teams to troubleshoot data discrepancies and maintain data quality across multiple reporting sources.
• Documented testing processes and maintained audit logs, improving traceability and reducing recurring data issues.
• Gained hands-on experience working with structured datasets using tools like Excel and SQL, supporting internal data operations and reporting tasks.
• Assisted in identifying areas of improvement in existing data workflows, contributing to streamlined processes and improved reporting efficiency.

Awards & Certificate

Data Science Placement guarantee course - Internshala Trainings

Data Analytics Job Simulation - Forage

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/netransh-parashar-313059179/

Call Me

+91 7987209169

GitHub

https://github.com/NetranshP

Excel Project

Fitbit Fitness Tracker Data Analysis for WeFit & Subsidiaries

Domain/Function: Data Analytics / Health & Wellness

Analyzed Fitbit fitness tracker data using Excel to derive customer insights for three brands under WeFit: LeanFit (diet plans), FitWear (fitness gear), and Sleepy-Nights (sleep app). Identified high-potential user segments based on activity, health, and sleep patterns.

View Project
on GitHUB

Other Tools

MS Excel

Power Query

Grouped users into Beginner, Intermediate, and Pro categories based on average distance walked. Includes pivot summary and visual charts (bar & pie)

Categorized users as Active, Moderate, or Light based on their number of active days. Includes classification logic, pivot summary, and visual charts

Project Details

Used Excel and Power Query to clean and analyze Fitbit data collected from thousands of users. Identified fitness enthusiasts for LeanFit’s diet plans, shoppers for FitWear’s gear, and irregular sleepers for Sleepy-Nights’ app. Created user personas based on activity levels, heart rate, and sleep quality. Delivered business recommendations to boost conversions across all three brands. Analysis also included identifying peak activity trends, regional health insights, and sleep habit correlations.

PowerBI Project

Hospitality Analysis – Hotel Chain Business

Domain/Function: Business Intelligence / Hospitality Analytics

Built a Power BI dashboard to analyze hotel chain performance metrics like occupancy rate, RevPAR, booking trends, and guest segmentation. Enabled data-driven decisions for improving customer satisfaction, seasonal strategy, and revenue growth.

View Project
on GitHUB

Other Tools

Power BI

MS Excel

Power BI dashboard showing hotel KPIs: Revenue, RevPAR, ADR, Occupancy, booking platforms, and property-wise performance metrics.

Line chart showing Average Daily Rate (ADR) trends by week number for weekday vs. weekend stays using dynamic filtering.

Project Details

Used Excel for data preprocessing and Power BI for visualization of hotel booking data. Created KPIs such as occupancy rate, average daily rate (ADR), and revenue per available room (RevPAR). The dashboard includes dynamic filters by region, room type, customer segment, and booking channel. Delivered actionable insights to optimize pricing strategy, increase booking efficiency, and enhance guest experience. Helped decision-makers identify peak and off-peak trends, top-performing channels, and guest behavior patterns.

Project video

Live Interactive Dashboard

Sales Performance – The Bike Haven

Domain/Function: Sales Analytics / Business Intelligence

Developed an interactive Tableau dashboard for The Bike Haven to visualize sales trends across products, regions, and customer segments. Enabled stakeholders to monitor performance KPIs and optimize business strategies.

View Project
on GitHUB

Other Tools

Tableau

MS Excel

A4-sized Tableau dashboard showing top products, customers, category-wise sales, budget vs sales, and region-wise performance.

Top 10 selling products bar chart in Tableau using filters for year, country, and category, with color-coded sales amount.

Project Details

Built a Tableau dashboard analyzing retail sales data for The Bike Haven. Used Excel for preprocessing and Tableau for visual storytelling. Visualized KPIs like total revenue, product-wise sales, regional growth, and customer segmentation. The dashboard includes dynamic filters, line charts, bar graphs, and maps. Delivered insights to help identify top-performing categories, high-value regions, and underperforming areas for strategic intervention.

Project video

PowerBI Project

Business 360 – Brick & Mortar and E-commerce

Domain/Function: Retail Analytics / Business Intelligence

Developed a Power BI dashboard integrating sales, returns, and profit data from physical stores and e-commerce platforms. Delivered unified insights on channel performance, customer behavior, and profitability.

View Project
on GitHUB

Other Tools

Power BI

SQL

Excel

DAX Studio

Power BI dashboard showing forecast accuracy, net error, and risk analysis by customer and product segments across sales channels.

Marketing view showing segment-wise sales, gross margin, and profit distribution across regions, with dynamic visual filters and performance insights.

Project Details

Built an end-to-end Power BI solution to consolidate and visualize performance data for both retail stores and online platforms. Used SQL for data preparation, Excel for initial cleaning, and DAX for KPI calculations. The dashboard includes channel-wise profit analysis, return rates, customer segmentation, top products, and regional trends. Key KPIs like net sales, profit margin, return % were dynamically filterable by channel, product, and region. The project helped reveal gaps in performance between sales channels and supported strategic planning for inventory and marketing.

Live Interactive Dashboard

SQL Project

Auction Strategy – IPL Franchise Team Building

Domain/Function: Sports Analytics / Data Strategy

Used historical IPL player performance and auction data to identify undervalued players and design a balanced, cost-effective team. Applied SQL joins, filtering, and ranking to support data-driven team selection.

View Project
on GitHUB

Other Tools

MySQL

Imported IPL match and ball-by-ball data from CSV files into PostgreSQL for player performance and auction analysis.

Wrote SQL queries to calculate top 10 IPL batsmen by strike rate using total runs and balls faced, and visualized results using bar chart.

Project Details

Analyzed past IPL auction data to help a franchise build a balanced squad within budget. Used SQL to join player stats, role categories, and auction prices. Designed queries to filter undervalued players by role (batsman, bowler, all-rounder), calculate performance-price ratios, and simulate ideal team combinations. Ranked players using calculated metrics and presented final selections ensuring role diversity and budget efficiency. This project highlights how SQL can drive strategic sports decisions.