Skip to content
View RafiQamar's full-sized avatar

Block or report RafiQamar

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.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, 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
RafiQamar/README.md

Hi, I'm Rafi Qamar 👋

🎯 Aspiring Data Scientist | 📊 SQL, Python, Power BI, Excel, Machine Learning| 💡 Passionate about turning data into actionable insights

Welcome to my GitHub profile!

🚀 About Me

Dynamic and detail-oriented Data Analyst with expertise in SQL, Python, Power BI, and exploratory data analysis (EDA). Proficient in crafting end-to-end analytics projects, focusing on clean, organized, and well-documented solutions for creating impactful dashboards and reports. Skilled at leveraging data insights and rapidly learning new technologies to drive informed decision-making.

My goal: To deliver data-driven solutions that empower businesses!

Feel free to explore my repositories and connect with me.

🛠️ Technical Skills

data science


  • Databases: MySQL
  • Python: pandas, numpy, seaborn, matplotlib
  • Visualization Tools: Power BI, Excel, Matplotlib, Seaborn
  • Web Scrapping: BeautifulSoup, requests, selenium
  • Machine Learning: scikit-learn, statsmodels
  • Other Tools: Jupyter Notebook, Streamlit, Excel

📈 Projects

IMDb Movies Analysis & Dashboard

  • Tech Stack: Python (Selenium, BeautifulSoup, Pandas, NumPy, Scikit-learn), MySQL, Power BI
  • Description: Scraped and analyzed 10,000 IMDb movies (2014-2024), built a machine learning model to predict missing genres, stored data in MySQL, and developed an interactive Power BI dashboard for insights.
  • Highlights:
    • Automated web scraping using Selenium & BeautifulSoup
    • Data cleaning & ML-based genre prediction using RandomForest
    • SQL queries for movie insights (top-rated, longest duration, trends)
    • Interactive Power BI dashboard with filters, charts, and KPIs
  • IMDb Movies Analysis
  • Demo

Customer Purchase Behavior and Sentiment Analysis

  • Tech Stack: SQL, Python, Power BI
  • Description: Insights into customer preferences and behavior through SQL-based data analysis and interactive Power BI dashboards.
  • Highlights:
    • Clean, normalized datasets
    • SQL scripts for transformations
    • Screenshots of Power BI dashboards
  • E-commerce Analytics

Customer Churn Prediction (Machine Learning)

  • Tech Stack: Python, Jupyter, Streamlit,
  • Description: Built and deployed a Streamlit-based customer churn prediction app using ML models.
  • Highlights:
    • Preprocessed and Exploratory Data Analysis
    • Hyperparameter tuning and evaluation on multiple models
    • Interactive Streamlit app
  • Customer Churn Prediction App

HR Analytics

  • Tech Stack: Python, SQL, Power BI
  • Description: Analyzed HR data to gain insights into employee performance, attrition, and workforce trends.
  • Highlights:
    • SQL queries for workforce analytics
    • Data-driven insights on employee engagement
    • Power BI dashboards for visualization
  • HR Analytics

Weight Change Prediction (Machine Learning)

  • Tech Stack: Python, XGB Regressor, Streamlit

  • Description: Predict weight changes based on lifestyle factors like caloric intake, sleep quality, and stress levels.

  • Highlights:

    • Interactive Streamlit app
    • Hyperparameter tuning and evaluation
    • Dataset insights via visualizations
  • Weight Change Prediction App

Colorado Motor Vehicle Sales Data Analysis Project

  • Analyzed Colorado motor vehicle sales data using Python (Pandas, Matplotlib, Seaborn) to identify trends, seasonality, and county-level performance. Developed ARIMA/SARIMA models for accurate sales forecasting, uncovering seasonal patterns and key economic factors. Provided actionable insights to guide business strategy and policy recommendations.
  • Colorado Motor Vehicle Sales Data Analysis Project

Target E-Commerce Dataset Analysis

  • Tech Stack: Python, SQL, Jupyter Notebook
  • Description: Uncovered customer behavior and sales trends with SQL queries and Python analysis.
  • Highlights:
    • SQL scripts for querying datasets
    • Python-based visualizations (matplotlib, seaborn)
    • Interactive findings in Jupyter
  • Target E-Commerce Data Analysis Project

KBC Quiz Game

  • Tech Stack: Python
  • Description: A Python-based quiz game inspired by 'Kon Banega Crorepati,' featuring rewards, penalties, and strategic gameplay.
  • Highlights:
    • General knowledge question bank
    • Engaging game logic with hints
    • Interactive terminal-based user interface
  • KBC (Kon Banega Crorepati) Python Game

📊 GitHub Stats

stats graph languages graph streak graph

powerbi logo jupyter logo excel logo python logo pandas logo numpy logo mysql logo selenium logo scikitlearn logo

📫 Connect with Me

linkedin logo

gmail logo: [email protected]

Thanks for visiting my profile! Feel free to reach out if you have any questions or just want to discuss data analytics. 🚀

Pinned Loading

  1. Colorado-Motor-Vehicle-Sales-Data-Analysis-Project Colorado-Motor-Vehicle-Sales-Data-Analysis-Project Public

    Analyzed Colorado motor vehicle sales data using Python (Pandas, Matplotlib, Seaborn) to identify trends, seasonality, and county-level performance. Developed ARIMA/SARIMA models for accurate sales…

    Jupyter Notebook 2

  2. Customer-Purchase-Behavior-and-Sentiment-Analysis Customer-Purchase-Behavior-and-Sentiment-Analysis Public

    Designed an end-to-end analysis pipeline using MySQL, Python, and Power BI. Analyzed purchase patterns and customer sentiment using SQL and Python (TextBlob, pandas). Built an interactive Power BI …

    Jupyter Notebook 2 1

  3. HR-Analytics-Project HR-Analytics-Project Public

    Cleaned and processed HR data using Python for analysis and visualization. Analyzed employee trends and performance using SQL and Python. Built an interactive Power BI dashboard connected to MySQL …

    Jupyter Notebook 3

  4. Weight-Change-Prediction-App Weight-Change-Prediction-App Public

    An app leveraging machine learning to estimate weight changes based on lifestyle inputs, offering actionable feedback.

    Jupyter Notebook 2

  5. IMDb-Movie-Analysis IMDb-Movie-Analysis Public

    This project involves web scraping, data preprocessing, database storage and visualization of IMDb movie data from the last decade (2014-2024). The dataset includes details of 10,000 movies such as…

    Jupyter Notebook 2