Data Analyst
Uncovering the hidden patterns that turn guesses into growth.
📍 Based in Sylhet, Bangladesh
- SQL — Joins, CTEs, Window Functions, Aggregations
- Power BI — Data Modeling, DAX, Calculated Columns, Power Query, Interactive Dashboards
- Python — Pandas, NumPy
- Excel — Pivot Tables, Power Query, Advanced Formulas, Charts
- Core Analytics — Data Cleaning, EDA, Business Intelligence, Data Storytelling
- Version Control — Git & GitHub
Technologies: MySQL, Power BI (DAX, Data Modeling, Calculated Columns, Power Query)
Analyzed ~829K transaction records across 50 stores in Mexico to surface actionable business insights:
- Diagnosed a -11.3% gross margin decline despite 30.9% revenue growth and 40.8% increase in units sold
- Identified Electronics as the highest margin category (44.6%) yet underleveraged at only 15.55% revenue share
- Flagged 20 SKUs at active stockout risk across all locations, including top seller Lego Bricks with 3 days of stock left
- Built a 5-page interactive Power BI dashboard with drill-through to individual store level across all 50 locations
Technologies: PostgreSQL, SQL (Joins, CTEs, Aggregations, Date Functions)
Analyzed multi-year pizza sales dataset to uncover key business insights:
- Identified top revenue-generating pizzas, categories & sizes
- Discovered peak order hours, busiest days & seasonal trends
- Calculated important KPIs: Total Revenue, Avg Order Value, Orders per Day, etc.
Technologies: SQL (various platforms), VS Code
A growing collection of solved SQL problems from LeetCode, HackerRank, StrataScratch and DataLemur.
Covers: Aggregations, Joins, Subqueries, Window Functions, Case Statements, Date/Time manipulation.
- Advanced SQL (Complex Window Functions, Query Optimization)
- Python for Data Analysis (Matplotlib, Seaborn)
- Workflow Automation
- Email: pallabdey21@gmail.com
- LinkedIn: linkedin.com/in/pallabdey007
- GitHub: github.com/Rusher0077
"In God we trust; all others rely on numbers 😄"