Skip to content

README.md

Latest commit

 

History

History
338 lines (228 loc) · 7.29 KB

README.md

File metadata and controls

338 lines (228 loc) · 7.29 KB
Raw

👋 Hi, I'm Shelly Garg

📊 Data Analyst | Power BI | SQL | Excel | Python | Tableau

Welcome to my GitHub profile! 🚀 I am passionate about transforming raw data into meaningful insights, interactive dashboards, and business solutions.

I enjoy working with data, discovering patterns, building dashboards, automating repetitive tasks, and creating data-driven solutions that help businesses make better decisions. 📈💡

🧑‍💻 About Me

  • 🎓 MCA Graduate – Chandigarh University
  • 📊 Aspiring Data Analyst
  • 💻 Skilled in Power BI, SQL, Excel, Python & Tableau
  • 📈 Interested in Data Visualization & Business Intelligence
  • 🧹 Experienced with Data Cleaning, Data Transformation & Data Analysis
  • 📊 Passionate about creating interactive dashboards and reports
  • 🐍 Currently strengthening my Python & AI skills
  • 🚀 Completed 50+ Data Analytics Projects
  • 🌐 Projects and work are available on my GitHub
  • 📍 Based in Gurgaon, India
  • 🔎 Open to Data Analyst opportunities

🛠️ Technical Skills

📊 Data Analytics & BI

Power BI Tableau Excel

🗄️ Database & Querying

SQL

🐍 Programming

Python

🔄 Data Preparation

  • Power Query
  • ETL
  • Data Cleaning
  • Data Transformation
  • Data Modeling
  • Data Validation

📐 Analytics

  • DAX
  • Statistics
  • KPI Analysis
  • Business Analysis
  • Exploratory Data Analysis
  • Trend Analysis

⚙️ Automation

  • Excel VBA
  • Python Automation
  • API Integration
  • Automated Reporting

📈 What I Do

Raw Data
    ↓
Data Cleaning
    ↓
Data Transformation
    ↓
Data Analysis
    ↓
Data Modeling
    ↓
Dashboard Development
    ↓
Business Insights
    ↓
Data-Driven Decisions 🚀

🚀 Featured Data Analytics Projects

🏨 1. Hotel Booking Cancellation Analysis

Tools: Python | Power BI | SQL | Excel | Power Query | DAX

📊 Analyzed hotel booking data to understand:

  • Booking cancellations
  • Revenue performance
  • Occupancy trends
  • Customer behavior
  • Booking patterns
  • Key business KPIs

🔍 Used Python, SQL and DAX for data cleaning, transformation, analysis and KPI development.

🛒 2. Amazon Sales & Vendor Performance Dashboard

Tools: Power BI | SQL | Excel | DAX | Power Query

📊 Developed an interactive dashboard to monitor:

  • 💰 Sales
  • 📈 Profit
  • 📦 Inventory
  • 🏪 Vendor performance
  • 📊 Product KPIs
  • 🎯 Business performance

Built automated reporting using Power Query, SQL and DAX.

🎵 3. Spotify Data Analysis

Tools: Excel | Power BI | Tableau | Python | SQL

Analyzed Spotify data to discover:

  • 🎧 Popular songs
  • 🎤 Artist performance
  • 📈 Streaming trends
  • ⭐ Track popularity
  • 🎶 Music characteristics

Created interactive dashboards and visualizations to communicate insights effectively.

🎬 4. Netflix Data Analysis

Tools: Python | SQL | Excel | Power BI | Tableau

Analyzed Netflix content to identify:

  • 🎬 Movies vs TV Shows
  • 🌎 Country-wise content
  • 📅 Content trends
  • ⭐ Ratings
  • 🎭 Genres
  • 📊 Popular categories

❤️ 5. Heart Disease Analysis

Tools: Python | SQL | Power BI | Tableau | Excel

Performed exploratory and statistical analysis to understand:

  • ❤️ Patient characteristics
  • 📊 Risk factors
  • 📈 Health-related patterns
  • 🔍 Correlations
  • 📉 Data trends

Built dashboards to present analytical findings visually.

✈️ 6. Airlines Data Analysis

Tools: Python | Power BI | Excel | SQL | Power Query | DAX

Analyzed airline-related data including:

  • ✈️ Flight performance
  • 👥 Customer information
  • 📊 Operational KPIs
  • 💰 Revenue
  • 📈 Performance trends

🚚 7. Supply Chain Analytics

Tools: Python | SQL | Tableau

Analyzed supply-chain data to identify:

  • 📦 Inventory trends
  • 🚚 Delivery performance
  • 💰 Cost analysis
  • 📊 Supplier performance
  • 📈 Operational insights

📊 Dashboard Gallery

💼 Power BI Dashboards

📈 Tableau Dashboards

📊 Excel Dashboards

💡 Replace the image URLs above with your actual GitHub image links.

📚 Currently Learning

🐍 Python for Data Analytics
🤖 Artificial Intelligence
📊 Advanced Power BI
📈 Advanced Tableau
🗄️ Advanced SQL
📐 Statistics
⚙️ Python Automation
🌐 API Integration

🧰 Tools & Technologies

Category Technologies
📊 BI Power BI, Tableau
📗 Spreadsheet Advanced Excel
🗄️ Database SQL
🐍 Programming Python
🔄 ETL Power Query
📐 Analytics Statistics, DAX
⚙️ Automation VBA, Python
🌐 Integration APIs
📝 Version Control Git, GitHub

📊 My Data Analytics Workflow

flowchart LR
A[📁 Raw Data] --> B[🧹 Data Cleaning]
B --> C[🔄 Data Transformation]
C --> D[📊 Data Analysis]
D --> E[🗄️ Data Modeling]
E --> F[📈 Dashboard]
F --> G[💡 Business Insights]
G --> H[🚀 Decision Making]
Loading

🎯 Career Objective

"Turning data into insights, insights into strategies, and strategies into impact." 📊💡🚀

I am looking for opportunities where I can use my skills in Data Analytics, Business Intelligence, Data Visualization and Reporting to solve real-world business problems.

🤝 Let's Connect

💼 LinkedIn: [Add your LinkedIn URL]

🌐 Portfolio: [Add your Portfolio URL]

🐙 GitHub: [Add your GitHub URL]

📧 Email: [Add your professional email]

💬 Open to Opportunities

🚀 Data Analyst 📊 Power BI Developer 📈 BI Analyst 🗄️ SQL Analyst 📊 MIS / Reporting Analyst

If you have a suitable opportunity, project, collaboration, or freelance requirement, feel free to connect with me. 🤝

⭐ Support My Work

If you find my projects useful:

⭐ Star my repositories 🍴 Fork the projects 💬 Share your feedback 🤝 Connect with me

Your support motivates me to keep learning, building and sharing! ❤️

👩‍💻 Author

Shelly Garg

Data Analyst | Power BI | SQL | Excel | Python | Tableau

📊 Turning Data Into Insights 🚀

⭐ Thanks for visiting my GitHub profile! ⭐

Made with ❤️ by Shelly Garg