Pratik Jha
Data Analyst skilled in Excel, SQL, Python, and Power BI.
New to Contra
Pratik is building their profile!
Project Title: IPhone Sales Analysis in India
Objective:
Analyze iPhone product and sales-related data to identify popular models, pricing patterns, discounts, customer ratings, and factors associated with product popularity.
Tools:
Python – Pandas, NumPy
Matplotlib / Seaborn / Plotly – Visualization
Excel – Data cleaning & analysis
Power BI – Dashboard
SQL – Queries
Key Analysis:
Top 10 most popular iPhone models
Highest-rated iPhones
Most-reviewed iPhone
Sale price vs. ratings
Discount % vs. ratings
Original price vs. sale price
Cheapest and most expensive iPhone
Price distribution by model
Storage-wise analysis
0
5
Airbnb Sales Project
Project Title: Airbnb Listings & Pricing Analysis
Objective:
Analyze Airbnb listings to understand pricing patterns, popular locations, room types, customer reviews, and factors affecting listing prices.
Tools:
Excel – Data cleaning & basic analysis
SQL – Data querying
Python – Pandas, NumPy, Matplotlib
Power BI – Interactive dashboard
Key Analysis:
Average price by neighbourhood
Price by room/property type
Number of listings by location
Rating vs. price
Reviews vs. price
Availability analysis
Top-performing locations
Host/superhost analysis
Factors affecting Airbnb prices
0
19
Project title:
Madhav Ecommerce Sales Dashboard
description:
Interactive Power BI dashboard analyzing e-commerce sales, profit, customers, products, states, and payment methods to generate actionable business insights.
Tools: Power BI • Excel • Power Query • DAX • Data Visualization
0
28