Skip to content
View AdityaK-27's full-sized avatar

Block or report AdityaK-27

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

Hi there 👋, I'm Aditya Kankarwal

🎓 4th Year Undergraduate at VIT Chennai
📊 Aspiring Data Analyst | Power BI Enthusiast | SQL & Python Learner
🚀 Passionate about turning data into impactful stories and insights

🔧 Tech Stack & Tools

  • Languages: SQL, Python, C, Java, Embedded C, JavaScript
  • Data Tools: Power BI, Excel, Pandas, NumPy, Tableau
  • Databases: MySQL, PostgreSQL
  • Web: HTML, CSS, JavaScript
  • Other Tools: Git, GitHub, Jupyter, Keil uVision, VS Code, Cisco Packet Tracer

💼 Experience

🔹 Data Analyst Intern – Reliance Industries Limited

  • Worked with operational data to generate business insights.
  • Contributed to internal analytics dashboards and reporting systems.
  • Practiced data wrangling, visualization, and summary report generation for senior stakeholders.

🔹 AICTE – IBM SkillBuild AI Internship (via Edunet Foundation)

  • Underwent structured training in AI foundations, data science, and applied projects.
  • Participated in hands-on modules focused on solving real-world business problems using data.
  • Gained exposure to IBM tools and collaborative data workflows.

🔹 Data Analyst Intern – Elevate Labs

  • Analyzed performance data for user behavior and product insights.
  • Automated reports using Python and SQL to enhance decision-making workflows.
  • Delivered visual insights and dashboards to improve product adoption and user engagement.

📈 Projects

🔹 Telco Customer Churn Analysis – Power BI

  • Conducted deep-dive analysis on customer churn behavior using a Kaggle dataset.
  • Designed and developed a 5-page interactive Power BI dashboard to analyze customer churn patterns in a telecom dataset.
  • Performed full ETL processes using Power Query, applied DAX functions for KPI tracking, and implemented drill-through reports, slicers, and layered visuals to support strategic insights and data storytelling.

🔹 Netflix Data Analysis – SQL

  • This project focused on analyzing Netflix’s Movies and TV Shows dataset using SQL to uncover meaningful content insights.
  • The analysis explored content types, genres, ratings, release years, and country-wise distribution across the platform.
  • Raw data was cleaned and transformed to handle missing values, inconsistent formats, and multi-valued fields like genres and cast.
  • A series of structured SQL queries were used to answer business-relevant questions and highlight content trends. The project demonstrated the practical application of SQL in solving real-world data problems and delivering clear analytical outcomes.
  • Overall, it reflects strong data handling, query design, and insight generation skills using SQL alone.

🔹 Smart Network Intrusion Notifier – Python

  • Lightweight IDS system based on EGT (Evolutionary Game Theory) using Scapy for packet analysis and Telegram API for real-time threat alerts.

📜 Certifications

  • ✅ Google Data Analytics Professional Certificate
  • ✅ Analysis and Visualization with Power BI - Microsoft
  • ✅ Starting with Git and Github - IBM
  • ✅ BI Dashboards with IBM Cognos Analytics and Google Looker - IBM
  • ✅ Fractal Analytics – Data Analysis Using SQL
  • ✅ HackerRank SQL Certificates – Basic, Intermediate, Advanced
  • ✅ HTML, CSS, and JavaScript for Web Developers – Johns Hopkins University

🌱 Currently Working On

🔹 Port Management System – SQL | Python

  • A terminal-based Port Management System built using Python and MySQL.
  • This project simulates operations at a port such as managing ship arrivals, departures, berth assignments, and maintaining a live ship register.
  • It demonstrates backend-database integration and record management using SQL.

Languages and Tools:

c cplusplus git java mysql postgresql python

📫 Let's Connect

Thanks for visiting my profile! 🚀

Popular repositories Loading

  1. Telco-Customer-Churn-Analysis-PowerBI Telco-Customer-Churn-Analysis-PowerBI Public

    A Power BI project to analyze customer churn using real-world telecom data. Includes ETL, DAX, KPI tracking, and interactive dashboards.

  2. Road-Extraction-DL Road-Extraction-DL Public

    Comparative analysis of deep learning models (U-Net, ResUNet, VGG16 U-Net, Self-Attention U-Net, Custom CNN) for road extraction from satellite imagery using the DeepGlobe dataset.

    Jupyter Notebook

  3. jbbmo-Introduction-to-Git-and-GitHub jbbmo-Introduction-to-Git-and-GitHub Public

    Forked from ibm-developer-skills-network/jbbmo-Introduction-to-Git-and-GitHub

    Introduction to Git and GitHub

    Python

  4. Port-Management-System Port-Management-System Public

    A terminal-based Port Management System using Python and MySQL.

    Python

  5. Netflix_Data_Analysis_SQL Netflix_Data_Analysis_SQL Public

    SQL-based analysis of Netflix Movies and TV Shows dataset to uncover trends in content type, genre, ratings, and countries. Includes 15+ business-focused queries with insights drawn from real-world…

  6. Elevate-Labs Elevate-Labs Public

    This repository is maintained as part of my internship with Elevate Labs for Data Analyst role. It documents daily task progress, data analysis work, and learnings throughout the internship.

    Jupyter Notebook