Skip to content
View Subhrajyouti's full-sized avatar
πŸ’­
Open to Work as a Analyst
πŸ’­
Open to Work as a Analyst

Block or report Subhrajyouti

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

Hi there! I'm Subhrajyouti Mahanta

πŸš€ Aspiring Data Analyst | SQL | Power BI | Python | Data Visualization

Welcome to my GitHub! I'm passionate about transforming raw data into actionable insights through data analytics, visualization, and business intelligence. With a background in data analysis and experience working with large datasets, I thrive on solving complex data challenges.


πŸ“« Connect with Me

πŸ“© Email πŸ’Ό LinkedIn πŸ— GitHub
subhrajyoutimahanta@gmail.com LinkedIn GitHub

πŸ† Projects

πŸš– GoodCabs Performance Analysis (SQL & Power BI)

πŸ“Œ Tech Stack: Power BI, PostgreSQL, SQL, Data Visualization
πŸ“Œ Overview: Analyzed 500,000+ trip records, built a Power BI dashboard, and optimized revenue tracking.
πŸ“Œ Insights: Identified that repeat passengers contribute 40%+ more revenue per trip.
πŸ“Œ GitHub Repo: GoodCabs Analysis

πŸ“Š Diagram:

graph TD;
  A[Raw Trip Data] -->|SQL Queries| B[Database]
  B -->|Power BI Reports| C[Data Visualization]
  C -->|Revenue Insights| D[Business Decisions]
Loading

πŸ“Š Data Analyst Job Market Insights (Python & Excel)

πŸ“Œ Tech Stack: Python, Pandas, Seaborn, Matplotlib, Jupyter Notebook, Excel
πŸ“Œ Overview: Analyzed 10,000+ job postings to uncover salary trends and in-demand skills.
πŸ“Œ Insights: SQL appeared in 50%+ of job postings, Python in 72% of Data Scientist roles.
πŸ“Œ GitHub Repo: Job Market Research

πŸ“Š Diagram:

graph LR;
  A[Job Data Collection] -->|Python Processing| B[Data Cleaning]
  B -->|Visualization| C[Trends & Insights]
  C -->|Job Market Recommendations| D[Career Growth]
Loading

β˜• SQL-Based Market Expansion Analysis (Monday Coffee Project)

πŸ“Œ Tech Stack: SQL, Data Cleaning, Decision Optimization, Market Expansion Strategy
πŸ“Œ Overview: Analyzed 100,000+ sales records to determine optimal city expansion strategy.
πŸ“Œ Insights: Identified Pune, Delhi, and Chennai as best expansion locations.
πŸ“Œ GitHub Repo: Monday Coffee Expansion

πŸ“Š Diagram:

graph TD;
  A[Sales Data] -->|SQL Analysis| B[Market Segmentation]
  B -->|Profit Trends| C[Best Cities Identified]
  C -->|Expansion Plan| D[Business Growth]
Loading

πŸ”§ Skills

πŸ“Œ Languages: SQL, Python, R
πŸ“Œ Databases: PostgreSQL, SQLite, MySQL
πŸ“Œ Tools & Frameworks: Power BI, Tableau, MS Excel, Pandas, NumPy, SciPy, Matplotlib

πŸ“Š Skill Set Overview:

pie
  title Skill Proficiency
  "SQL": 30
  "Python": 25
  "Power BI": 20
  "Excel": 15
  "Tableau": 10
Loading

πŸŽ“ Certifications

βœ… SQL for Data Analytics
βœ… Python for Data Analytics
βœ… Excel for Data Analytics


πŸ“Œ Open to collaboration, job opportunities, and projects in data analytics and business intelligence! πŸš€

Pinned Loading

  1. readme readme Public

  2. Monday_cofee_sales_store_expansion Monday_cofee_sales_store_expansion Public

  3. Data-Science-Job-Market-Research-with-Python Data-Science-Job-Market-Research-with-Python Public

    Jupyter Notebook

  4. GoodCabs-Analytics GoodCabs-Analytics Public