Skip to content
View Lavkush-2005's full-sized avatar
1 follower · 2 following

Block or report Lavkush-2005

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

Hi there, I'm Lavkush! 👋

Profile Views

🚀 About Me

I turn messy spreadsheets and disconnected tables into dashboards people actually trust and use. Based in Dehradun, I work in Python, SQL, Power BI, and Excel — writing queries that answer the question behind the question, and building models that hold up under scrutiny.

I've shipped projects across retail, e-commerce, supply chain, and hospitality: tracing a 129K-order supply chain back to its bottlenecks, surfacing a 72% non-subscriber gap hiding in repeat buyers, cutting reporting turnaround by 30% through automation. My favorite part of the job isn't the chart, it's the moment someone who's never touched a query says, "oh, that's why."

🎯 My Interests

  • Business Analytics: Solving real-world problems using SQL, Python, and dashboards
  • Data Visualization: Building dashboards in Power BI that people actually use, not just look at
  • Customer & Retail Analytics: Understanding buying behavior, segmentation, and retention
  • Automation: Using tools like Selenium to eliminate repetitive manual data collection

🛠️ Technical Skills

  • Languages & Query: Python (pandas, NumPy), SQL (PostgreSQL)
  • BI & Visualization: Power BI, Excel (Pivot Tables, Lookup Functions, Dashboards)
  • Other Tools: Selenium (Web Scraping), Jupyter Notebook · Git/GitHub

📌 Featured Projects

Project Description
Customer Behavior & Segmentation Analysis End-to-end analysis of 3,900+ customer records — Python cleaning, SQL analysis, Power BI dashboard
Supply Chain Analytics Dashboard Power BI dashboard covering supplier performance, inventory, shipments, and revenue
Hotel Booking Analysis Identified key drivers of booking cancellations and seasonal trends
Zepto Sales Data Analysis SQL-driven analysis of quick-commerce sales data
Iris Flower Classification (ML) Species classification using Python and Scikit-learn
Corporate Network Design Multi-department LAN topology design in Cisco Packet Tracer

📫 How to Reach Me

LinkedIn

⭐️ Feel free to explore my repositories — feedback and suggestions are always welcome!

Pinned Loading

  1. customer-behavior_segmentation-analysis customer-behavior_segmentation-analysis Public

    End-to-end analysis of 3,900+ customer shopping behavior — from raw data cleaning in Python, to business-question SQL queries in PostgreSQL, to an interactive Power BI dashboard for stakeholders.

    Jupyter Notebook

  2. supply-chain-analytics-dashboard-powerbi supply-chain-analytics-dashboard-powerbi Public

    End-to-end Supply Chain & Logistics dashboard built in Power BI, providing insights into supplier performance, inventory, shipments, and revenue.

  3. hotel-booking-analysis hotel-booking-analysis Public

    Hotel Bookings Analysis and Cancellation Insights

    Jupyter Notebook

  4. zepto-data-analysis zepto-data-analysis Public

    This project focuses on analyzing Real Zepto's sales dataset using SQL to extract meaningful business insights.

  5. iris_flower_classification_machine_learning iris_flower_classification_machine_learning Public

    This repository is collection of Machine learning project to classify iris flowers into Setosa, Versicolor, and Virginica using Python and Scikit-learn.

    Jupyter Notebook

  6. Corporate-network-design_Cisco-Packet-Tracer Corporate-network-design_Cisco-Packet-Tracer Public

    Designed a multi-department corporate LAN topology for HR, IT, and Finance teams using Cisco Packet Tracer.