Skip to content
View Pratham719's full-sized avatar
2 followers · 2 following

Highlights

  • Pro

Block or report Pratham719

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

Aspiring Data Analyst · SQL · Python · Power BI

Building business-focused analytics projects — profitability, revenue, and operational analysis turned into dashboards that support real decisions.

📬 prathamrangoon2007@gmail.com

🌐 Socials

LinkedIn Streamlit

💻 Tech Stack

Analytics & Visualization

Python SQL Pandas NumPy Matplotlib Seaborn Plotly

BI & Reporting

Power BI Excel PowerPoint

Deployment & Dashboards

Streamlit

Tools & Environment

Git GitHub VS Code Jupyter Google Colab DBeaver XAMPP

⭐ Featured Projects

📊 Nassau Candy — Profitability & Margin Analysis 3 divisions analyzed across 2 years of sales data. Chocolate alone drove 95%+ of total profit — Sugar and Other divisions flagged as margin risk despite active revenue. Top 5 products accounted for ~80% of gross profit. → Live Dashboard · Repo

☕ Afficionado Coffee — Sales & Product Mix Analysis 9 product categories · 80 products analyzed across store locations and product types. Top 42 products (52.5%) drive 80% of total revenue — remaining 38 contribute only 20%. Moderate concentration risk flagged: single-product dominance within Tea and Drinking Chocolate divisions signals menu dependency worth monitoring. → Live Dashboard · Repo

🗄️ SQL Practice — Business Datasets & LeetCode Employee and coffee shop datasets · 21 Easy + 3 Medium LeetCode problems solved. → Repo

🧠 Where I Am

✅ Python · Pandas · Streamlit · EDA · Business dashboards
🔄 SQL (joins, aggregations, subqueries) · Power BI
🎯 Window functions · CTEs · Analyst-level business queries

📊 GitHub Stats

Pinned Loading

  1. Nassau-Candy-Analysis-v2 Nassau-Candy-Analysis-v2 Public

    Profitability and margin analysis for a candy distributor — Pareto concentration, division performance, and pricing risk using Python and Streamlit.

    Python 3

  2. Afficionado-coffee-roster Afficionado-coffee-roster Public

    Sales and product mix analysis for a specialty coffee roaster — revenue concentration, category performance, and margin insights using Python and Streamlit.

    Python 3

  3. neetcode-submissions neetcode-submissions Public

    Solutions and notes from my DSA practice journey using NeetCode

    Python 3

  4. sql-practice sql-practice Public

    SQL practice covering joins, subqueries, aggregations, window functions, and CTEs — includes a self-designed coffee shop business case using MySQL/MariaDB.

    2