👋 Hello! I'm Rahul Rai

A passionate Data Analyst from Sahadatpurra, Maunath Bhanjan, UP, turning raw data into actionable insights. With a foundation in Mechanical Engineering and training in Data Science 360 at AnalytixLabs, I specialize in uncovering trends, building dashboards, and driving data-backed decisions.

📊 Recently led a Financial Forecasting Project to analyze quarterly revenue, model future trends using time-series analysis and predict credit risk using machine learning classification models. Delivered automated dashboards using Power BI and Python.

💡 Skilled in Python, SQL, Power BI, Excel, Tableau, Streamlit, ML (XGBoost, Regression), Clustering, and NLP. I'm actively seeking opportunities to collaborate and solve real-world business problems through data.

📘 About Me

Location: Maunath Bhanjan, UP - 275101
Email: rahulraimaiu5@gmail.com
Education:
- B.Tech, Mechanical Engineering - GLA Institute (2009–2013)
- Data Science 360 Program - AnalytixLabs (2022–2023)
Background: UPSC prep (2016–2020) → Data Science career

🛠 Skills

Python SQL Power BI Excel Machine Learning Pandas Streamlit Tableau Seaborn Scikit-learn XGBoost NLP

📊 Featured Projects

📘 Facebook Engagement Dashboard (Streamlit)

Built with Streamlit — visualizes reactions and comments by post type.

🛒 E-commerce KPI Dashboard (Streamlit)

Analyzes revenue, orders, and customers by region/category.

📌 Correlation Heatmap for ML

Feature selection using correlation matrix.

🌟 Rating Distribution (NLP)

Visual analysis of review sentiments.

🧠 Image Classifier (CNN)

Built a CNN on CIFAR-10 to classify Cat/Dog/Deer. Includes Streamlit demo.

🧾 Sales Analysis via SQL

Sales trend analysis and customer behavior using SQL joins, aggregates, CTEs.

📈 Financial Forecasting & Credit Risk Prediction

Developed a two-part solution:

Forecasting: Used Python (ARIMA/Prophet) to project future quarterly revenue and growth.
Credit Risk: Built a classification model (Logistic Regression, XGBoost) to predict loan default risk.
Dashboard: Created interactive Power BI dashboard for stakeholders with KPIs, risk tiers, and timelines.

Tools: Python, Pandas, Scikit-learn, Power BI, Time Series, Streamlit