Skip to content
View kra10m's full-sized avatar

Block or report kra10m

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

Python SQL PostgreSQL Power BI Excel

Hi, I'm Abhinav Tandon

Data Analyst | SQL · Python · Power BI · Excel

I enjoy transforming raw data into actionable insights through analytics, dashboarding, and business intelligence solutions. My experience includes data analysis, KPI reporting, customer segmentation, cohort analysis, and interactive dashboard development.

Currently pursuing a Minor in Artificial Intelligence & Data Science at IIT Mandi and actively seeking opportunities in Data Analytics and Business Intelligence.

Technical Skills

Category Technologies
Programming Python, SQL
Databases PostgreSQL
Data Analysis Pandas, NumPy
Visualization Matplotlib, Seaborn
BI Tools Power BI, DAX, Power Query
Spreadsheet Analytics Microsoft Excel
Development Tools Git, GitHub, VS Code, DBeaver

Featured Projects

Customer Segmentation & Cohort Revenue Analysis

Tech Stack: PostgreSQL, SQL, Window Functions

  • Analyzed 100,000+ retail transactions using advanced SQL.
  • Built customer segmentation models using behavioral metrics.
  • Performed cohort revenue analysis using LAG, LEAD, and window functions.

🔗 Repository: github.com/kra10m/SQL_Projects_Data_Analytics

Data Analyst Job Market Analysis

Tech Stack: Python, Pandas, Matplotlib, Seaborn

  • Performed exploratory data analysis on 10,000+ job postings.
  • Built data cleaning and transformation pipelines.
  • Identified salary trends, skill demand, and hiring patterns.

🔗 Repository: github.com/kra10m/Python_Projects_Data_Analytics

Data Jobs Dashboard

Tech Stack: Power BI, DAX, Power Query

  • Interactive dashboard tracking salary benchmarks, role demand, skill gaps, and location trends.
  • Built KPI-focused visualizations for multiple stakeholder perspectives.

🔗 Repository: github.com/kra10m/Power_BI_Projects_Data_Analytics

Data Science Job Market Dashboard

Tech Stack: Excel, Power Query

  • Built a dynamic Excel dashboard using Pivot Tables, XLOOKUP, SUMIFS, and slicers.
  • Automated salary benchmarking and reporting workflows.

🔗 Repository: github.com/kra10m/Excel_Projects_Data_Analytics

Experience

Data Analyst Intern | Ingenious Prime

June 2024 – December 2024

  • Built Power BI dashboards and Excel reports for educational analytics.
  • Analyzed enrollment, fee collection, and operational datasets.
  • Supported KPI monitoring and reporting for stakeholders.

Education

Minor in Artificial Intelligence & Data Science

IIT Mandi | 2025 – Present

Bachelor of Computer Applications

LN Mishra Institute | 2021 – 2024

Contact

📧 atandon027@gmail.com

🔗 LinkedIn: linkedin.com/in/abhinav-tandon-212a54388

🔗 GitHub: github.com/kra10m

Pinned Loading

  1. Excel_Projects_Data_Analytics Excel_Projects_Data_Analytics Public

    Excel dashboards, reports, and analysis projects organized in separate folders.

  2. Power_BI_Projects_Data_Analytics Power_BI_Projects_Data_Analytics Public

    Power BI dashboards, reports, and analytics projects organized in separate folders.

  3. Python_Projects_Data_Analytics Python_Projects_Data_Analytics Public

    Python data analytics projects using Pandas, Matplotlib, Seaborn, and Jupyter Notebooks, organized in separate project folders.

    Jupyter Notebook

  4. SQL_Projects_Data_Analytics SQL_Projects_Data_Analytics Public

    SQL customer segmentation, cohort analysis, and retention analysis projects using PostgreSQL.