Skip to content
View prathams0ni's full-sized avatar

Block or report prathams0ni

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
prathams0ni/README.md

πŸ‘‹ Hi, I'm Pratham Soni

🎯 Aspiring Data Analyst | AI/ML Enthusiast
πŸ“Š Solving Real-World Business Problems Using Data


πŸ’‘ About Me

I am a Data Analytics and Machine Learning fresher with strong hands-on experience in solving real-world business problems using data.

While I do not have formal industry experience yet, I have independently built multiple end-to-end analytics projects simulating real business environments β€” including fintech transaction analysis, airline performance dashboards, retail intelligence systems, and predictive machine learning models.

My focus is not just building models, but understanding business problems and delivering data-driven insights.


πŸ›  Technical Skills

πŸ”Ή Programming & Querying

Python | SQL | Excel

πŸ”Ή Python Libraries

Pandas | NumPy | Matplotlib | Seaborn | Scikit-Learn

πŸ”Ή Data Visualization

Power BI | Tableau | Excel Dashboards

πŸ”Ή Machine Learning

  • Linear Regression
  • Logistic Regression
  • Decision Trees
  • Random Forest
  • K-Means Clustering
  • Time Series Forecasting
  • Model Evaluation & Hyperparameter Tuning

πŸ”Ή Core Analytics Skills

Data Cleaning
Exploratory Data Analysis (EDA)
Feature Engineering
Statistical Analysis
Business Insight Generation


πŸš€ Real-World Problem Based Projects


πŸ”₯ Digital Transaction & Failure Risk Analysis

(Python + Power BI)

Problem: Digital payment platforms face high failure rates during peak hours and network instability.

Solution:

  • Generated realistic synthetic transaction dataset
  • Performed full data cleaning & EDA in Python
  • Built interactive Power BI dashboard using DAX
  • Identified:
    • Peak-hour failure spikes
    • Network-based system risks
    • Seasonal load impact
    • Payment method reliability gaps

Outcome: Demonstrated how data can improve platform reliability and reduce transaction failures.


πŸ• Pizza Hut Sales Intelligence System

(SQL)

Problem: Understanding revenue drivers and customer ordering behavior.

Solution:

  • Built 13 business-driven SQL queries
  • Used JOINs, subqueries, aggregations
  • Identified top-selling products and revenue trends
  • Analyzed order patterns and size preferences

Outcome: Converted raw transactional data into actionable revenue insights.


✈ Indian Airlines Performance Dashboard

(Power BI)

Problem: Analyzing operational performance and passenger trends.

Solution:

  • Cleaned and transformed data
  • Built KPI-based dashboard
  • Created DAX measures
  • Identified route-level performance gaps

Outcome: Presented insights in executive-level visual storytelling format.


πŸ“‰ HR Attrition Prediction Model

(Machine Learning)

Problem: Predicting employee attrition using historical HR data.

Solution:

  • Applied Logistic Regression
  • Performed feature engineering
  • Evaluated using Precision, Recall, F1-score
  • Interpreted model for business impact

Outcome: Showcased predictive analytics for workforce retention strategy.


πŸ“Š Additional Analytics & ML Projects

  • House Price Prediction
  • Advertising ROI Analysis
  • Student Performance Prediction
  • Customer Segmentation (K-Means)
  • Retail Sales Forecasting
  • Google Reviews Clustering
  • Public Transportation Optimization

These projects demonstrate practical application of regression, classification, clustering, and forecasting techniques.


🎯 What Makes My Work Different

βœ” Business-problem-first approach
βœ” Clean and structured data pipelines
βœ” Strong visualization and storytelling
βœ” End-to-end project execution
βœ” Focus on practical implementation


πŸ“ˆ Currently Learning & Building

  • Advanced Machine Learning (XGBoost, Model Optimization)
  • Real-time analytics dashboards
  • LLM-powered data assistants
  • Failure prediction systems

πŸ“« Let's Connect

πŸ“§ Email: prathamsoni1128@gmail.com

πŸ’» Portfolio: https://pratham-soni-portfolio.lovable.app

πŸ”— LinkedIn: https://www.linkedin.com/in/pratham-soni-600787268


⭐ Open to entry-level Data Analyst / Business Analyst / ML roles.

Pinned Loading

  1. DigitalPay_Analytics_End-to-End_Payment_Transaction_Dropoff_Analysis_Intelligence_Dashboard DigitalPay_Analytics_End-to-End_Payment_Transaction_Dropoff_Analysis_Intelligence_Dashboard Public

    End-to-end analytics project simulating real-world digital payment data, performing EDA & data engineering in Python, and building an executive-level Power BI dashboard for transaction success, fai…

    Jupyter Notebook

  2. Pizza_Sales_SQL_Project Pizza_Sales_SQL_Project Public

    SQL-based analysis of Pizza Hut sales data solving 13 real-world business questions using joins, aggregations, and window functions.

  3. Predictive_HR_Analytics_Employee_Attrition_Forecasting_using_ML_Streamlit_Deployment Predictive_HR_Analytics_Employee_Attrition_Forecasting_using_ML_Streamlit_Deployment Public

    This project is an end-to-end Machine Learning web application that predicts whether an employee is likely to leave the company based on HR analytics data. The system helps organizations identify h…

    Jupyter Notebook

  4. Mumbai_House_Rent_Prediction_EDA_ML_Streamlit_Deployment Mumbai_House_Rent_Prediction_EDA_ML_Streamlit_Deployment Public

    A complete end-to-end machine learning project to predict monthly house rent in Mumbai using data cleaning, outlier handling, feature encoding, and regression models (Linear Regression, Decision Tr…

    Jupyter Notebook

  5. Indian_Airlines_Analysis_Power_BI_Dashboard Indian_Airlines_Analysis_Power_BI_Dashboard Public

    This project presents analytical view of Indian domestic airline flights, covering pricing trends, booking behavior, class distribution, city-wise connections, and timing analysis. The dashboard is…