Skip to content
View aks-data's full-sized avatar

Block or report aks-data

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 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
aks-data/README.md

Hi, I'm Anurag Kumar Singh

Data Analyst · Python · SQL · Power BI · Excel | MCA Graduate, Lovely Professional University

Typing SVG

profile views


About Me

  • MCA Graduate from Lovely Professional University (2022 – 2024)
  • Passionate about Data Analytics & Business Intelligence
  • Fresher actively building my Data Analyst portfolio
  • Currently learning Advanced SQL & DAX
  • I turn raw data into clear, actionable business insights
  • Based in Kolkata, India | Immediate Joiner | Open to Relocate

Tech Stack & Tools

Languages & Libraries:

Python SQL Pandas NumPy Matplotlib

BI & Visualization Tools:

Power BI Excel Jupyter

Databases & Tools:

MySQL GitHub VS Code


Projects

1. Customer Churn Risk & RFM Segmentation Dashboard

Python + Power BI | Online Retail Dataset

Status Tools

My first end-to-end Data Analytics project — performed RFM (Recency, Frequency, Monetary) segmentation on an Online Retail dataset to identify customer churn risk and revenue patterns.

Metric Value
Total Revenue Analyzed ₹8.91M
Customers Segmented 4,000+
Top Segment (Champions) 39.49% of customers
At Risk Customers 14.59%

Key Insights:

  • Champions drive the majority of total revenue (~₹4M)
  • At Risk segment flagged for urgent retention campaigns
  • Loyal customers show high frequency but lower spend
  • Retention campaign strategy recommended from RFM scores

Tools Used: Python · Pandas · Power BI · RFM Analysis · DAX

View Project →


Experience

** Student Intern — TechTree Technology** (Aug 2020 – Oct 2020)

  • Worked with MySQL for structured data storage & retrieval
  • Wrote SQL queries for data handling & backend operations
  • Built dynamic web pages using HTML, CSS & JavaScript

Education

  • MCA — Lovely Professional University (2022 – 2024)
  • BCA — George College (2018 – 2021)

GitHub Stats

Just getting started on GitHub More projects coming as I build my portfolio!


Let's Connect!


"Every expert was once a beginner. Every pro was once an amateur."

If you like my work, consider starring my repos!

Pinned Loading

  1. customer-churn-rfm-segmentation customer-churn-rfm-segmentation Public

    Customer Churn Risk & RFM Segmentation Dashboard built using Python + Power BI

    Jupyter Notebook