Skip to content
View hetachavda's full-sized avatar

Block or report hetachavda

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.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

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

Report abuse
hetachavda/README.md

Hi, I'm Heta Chavda 👋

📊 Data Analyst | Business Intelligence | SQL • Power BI • Python

Turning raw data into decisions that move the business.

Python SQL Power BI Tableau scikit-learn Pandas Excel

LinkedIn GitHub


🎯 About Me

I'm a data analytics professional who enjoys transforming complex datasets into clear, actionable business insights. I work across the analytics lifecycle - from SQL querying and Python analysis to Power BI and Tableau dashboards - helping stakeholders understand performance, identify trends, and make informed decisions.

  • 🔭 Focused on data analytics, business intelligence, predictive analytics, and reporting
  • 📊 Experienced with Power BI, SQL, Python, Tableau, and Excel
  • 🌱 Continuously improving my skills in data modeling, automation, visualization, and machine learning
  • 💬 Interested in solving business problems through data-driven analysis

🏆 Tech Stack

Domain Tools
Languages Python, SQL
Business Intelligence Power BI, Tableau, Excel
ML / Analytics scikit-learn, Predictive Modeling, Clustering, Regression, Time-Series
Data Wrangling Pandas, NumPy, Power Query
Visualization Power BI, Tableau, Matplotlib, Seaborn
Optimization Google OR-Tools, Linear / Integer Programming
Databases MySQL, Relational Design, Data Modeling, 3NF

🏆 Featured Projects

A selection of projects demonstrating practical experience in data analysis, business intelligence, predictive modeling, visualization, database design, and optimization.

🏦 Bank Loan Repayment Analysis

Python · Pandas · scikit-learn · Machine Learning

Developed a classification model to identify customers at risk of loan default. Performed data preprocessing, exploratory analysis, feature evaluation, and model comparison, achieving a ROC-AUC score of 0.915.

View Project →


📱 Google Play Store Predictive Analytics

Python · Pandas · Machine Learning · NLP

Analyzed application ratings and customer reviews to identify factors associated with user satisfaction. Applied sentiment analysis and compared five machine-learning models for predictive analysis.

View Project →


🎯 Marketing Segmentation Analysis

Python · K-Means · Excel · Customer Analytics

Applied K-Means clustering to segment customers into four distinct behavioral groups and translated analytical findings into targeted marketing opportunities.

View Project →


⚡ Electric Vehicle Adoption Analysis

Tableau · Data Visualization · Trend Analysis

Built an interactive Tableau analysis of 14.8K+ electric vehicle registrations, examining adoption patterns, vehicle types, manufacturers, geographic trends, and BEV versus PHEV distribution.

View Project →


🏠 Housing & Bike-Sharing Analytics

Python · Power BI · Predictive Analytics · Prescriptive Analytics

Combined predictive modeling and business intelligence to analyze housing prices and bike-sharing demand. Developed Power BI visualizations to communicate patterns, analytical results, and decision-oriented insights.

View Project →


🚦 Urban Public Transit Route Optimization

Python · Google OR-Tools · Mixed-Integer Programming

Developed an optimization model for public transportation scheduling using Google OR-Tools, applying mixed-integer programming to evaluate operational constraints and improve resource allocation.

View Project →


📂 Additional Projects

Project Focus Technologies
PM2.5 Air Quality Forecasting Time-series forecasting and environmental analytics Python ARIMA
End-to-End Python Data Analysis Data cleaning, EDA and analytical modeling Python Pandas
Customer Behavior Models Regression, classification and clustering Python SQL Power BI
Car Dealership Database System Relational database design with 9 entities and 3NF normalization MySQL SQL
Uber vs Lyft Comparative Analysis Statistical analysis of approximately 650K ride records Python Statistics
PESTEL Analysis — Ethanol Blending Policy, economic and strategic analytics Python Analytics
Ethics in Prescriptive Analytics Responsible analytics, optimization and data privacy Optimization

"Without data, you're just another person with an opinion."

Explore my projects and feel free to connect with me on LinkedIn.

Pinned Loading

  1. pm25-capstone-jupyter pm25-capstone-jupyter Public

    PM2.5 Air Pollution Prediction using Machine Learning & Time-Series Models (Python, Power BI, NAPS Data)

    Jupyter Notebook