Available for Roles

Helping Businesses Make Smarter Decisions with Data.

I'm a SQL-first analyst with a computer science background. I enjoy turning raw data into dashboards people actually use, and I care more about writing code I can explain than code that just works.

B.Sc. CS — CGPA 3.96/4.00
100+ SQL Problems Solved
Databricks & DataCamp Certified
Pallab Dey Portrait
SELECT * FROM analysts WHERE name = 'Pallab Dey'
Behind the Data

About Me

I got into this by taking messy, half broken datasets and turning them into something a business could actually act on. Along the way I started automating the boring parts too, things like triggering ingestion jobs or sending out alerts, because running the same steps by hand every day felt like a waste of time.

I care more about being able to explain my work than making it look polished. If something is on my resume or in a project writeup, I can walk you through how I got there, the code behind it and where it falls short.

The part I keep coming back to is automation. I don't just want to analyze data, I want to build workflows that do the repetitive work for me, from ingest triggers to alert pipelines. I think analysts who understand this side of things end up being more useful.

3.96
B.Sc. in CS CGPA
Metropolitan University, Sylhet. Grounded in SQL & Data Structures.
100+
SQL Problems
Solved across StrataScratch, DataLemur, and HackerRank.
04
Certifications
DataCamp, Databricks, Coursera & Government-accredited credentials.
Automation
First
Embedding automation into every workflow—not a traditional analyst mindset.
Realized Work

Featured Projects

Maven Toys Sales Dashboard Analysis
SQL Power BI Analysis

Maven Toys Sales Analysis

An end-to-end analysis of ~829K toy transaction rows. Features an interactive dashboard and business report diving deep into monthly trends and category shares.

Cleaned 6 relational tables via SQL queries
5-page structured interactive Power BI report
View Case Study View on GitHub
Daraz Market Intelligence Pipeline
Python PostgreSQL Power BI

Daraz Market Intelligence Pipeline

End-to-end pipeline for 8,287 Daraz Bangladesh listings, with automated cleaning, category-quality checks, cloud storage, and Power BI market intelligence.

8,287 listings processed across 15 categories
Automated batch loads via GitHub Actions
View Case Study View on GitHub
Transaction Monitoring Pipeline Flow
SQL Databricks Automation

Fintech Transaction Monitoring & Risk Analytics

An automated data processing pipeline engineered to flag suspicious transactional activity. Built using Databricks to clean and query anomalous behavior.

Four explainable risk triggers built in Databricks SQL
Automated Telegram alerts via n8n
View Case Study View on GitHub
RAG Pipeline AI Chatbot n8n Workflow
n8n Pinecone DB Gemini API

RAG Pipeline AI Chatbot

An intelligent chatbot named Nova engineered entirely in n8n. Interfaces Gemini LLMs and Pinecone vector indexes for context-rich data answering.

Live knowledge base updates
Dual-trigger setup for vector database uploads
View Case Study View on GitHub
Pizza Sales Analysis Dashboard
SQL Power BI Analysis

Pizza Sales Analysis

An end-to-end sales analysis project investigating key business metrics like KPI trends, hourly peak times, and sales distribution. Built with SQL and interactive Power BI.

Cleaned and prepared transaction data with SQL queries
Interactive Excel dashboard for business insights
View Case Study View on GitHub
Capabilities

My Skill Stack

Core Analysis

SQL Power BI Data Cleaning Excel Data Modelling DAX

Tools & Platforms

Databricks Python NumPy Pandas n8n Flows Git & GitHub

Growing Technologies

RAG Pinecone LLMs
Credentials

Certifications

DataCamp Data Analyst Associate Certificate
DataCamp

Data Analyst Associate

Verify Credential
DataCamp Data Analyst in Databricks Certificate
DataCamp

Data Analyst in Databricks

Verify Credential
Python Programming and Basic Data Science Certificate
Government of Bangladesh

Python Programming & Basic Data Science

Verify Credential
Supervised Machine Learning Certificate
Coursera / Stanford

Supervised Machine Learning: Regression & Classification

Verify Credential
Reach Out

Let's collaborate on data.

I am actively seeking Data Analyst positions or BI dashboard-focused contract roles. If you have an interesting data pipeline problem or simply want to connect, feel free to reach out.