Skip to content

Repository files navigation

Data Analysis Portfolio - Akash Ghosh

πŸ” Overview

Welcome to my data analysis portfolio! This repository showcases my projects in data analytics, demonstrating proficiency in SQL, Python, Power BI, and Tableau. Each project displays different aspects of data manipulation, analysis, and visualization techniques.

πŸ“‚ Projects

1. Global Workforce Analytics

  • Tools Used: Power BI, SQL, Python
  • Dataset: Stack Overflow Survey Data (18,845 responses)
  • Key Findings:
    • Analyzed workforce demographics across 100+ countries
    • Identified 20% gap in job satisfaction across industries
    • Automated cleaning of 15,000+ entries

2. Credit Card Spending & Risk Analysis

  • Tools Used: Power BI, SQL
  • Dataset: 10,000+ credit card records
  • Key Findings:
    • Analyzed spending patterns across 5 key demographics
    • Reduced manual analysis time by 40%
    • Enhanced user engagement by 30%

3. E-commerce Analytics

  • Tools Used: Power BI, SQL, Python
  • Dataset: Multi-regional sales data ($2.41B revenue)
  • Key Findings:
    • Tracked performance across 8 regions
    • Analyzed online ($984M) vs offline ($1.42B) channels
    • Identified top revenue drivers: Cosmetics ($724M) and Office Supplies ($531M)

4. Pizza Chain Analytics

  • Tools Used: Power BI, SQL
  • Dataset: 21K orders ($817.86K revenue)
  • Key Findings:
    • Engineered 12+ SQL queries for trend analysis
    • Tracked KPIs including average order value ($38.31)
    • Analyzed category performance (29.02% Classic dominance)

πŸ› οΈ Tools & Skills

  • Programming: Python (Pandas, NumPy, Matplotlib, Seaborn)
  • Database: SQL (5β˜… HackerRank)
  • Visualization: Power BI, Tableau
  • Data Analysis: Excel, Statistical Analysis
  • Version Control: Git

πŸ“š Education & Certifications

  • Masters of Computer Application (CGPA: 8.4) - TECHNO INDIA UNIVERSITY
  • Data Analytics Essentials - Cisco Networking Academy
  • TATA Data Visualization: Empowering Business with Insights
  • Goldman Sachs: Excel Skills for Business

🀝 Connect With Me

πŸ“ˆ Future Updates

This repository is regularly updated with new projects and analyses. Stay tuned for:

  • Time series analysis projects
  • Machine learning implementations
  • Industry-specific case studies

Feel free to reach out for collaborations or questions about any projects!

About

πŸ“Š Portfolio of Data Analysis Projects | SQL, Python, Power BI, Tableau | Exploring insights through visualization and statistical analysis | From e-commerce analytics to workforce trends

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages