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.97/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.97
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
Transaction Monitoring Pipeline Flow
SQL Databricks Automation

Transaction Monitoring Pipeline

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 Docker

Growing Technologies

RAG Pinecone LLMs
Credentials

Certifications

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.