@the.queryguy
The Learning Stack

Master the
Analytics Workflow.

A curated suite of modules designed to take you from data curious to data expert. Built for the modern analyst who values speed and clarity.

Available Modules (10)

SQL Mastery

Senior Data Analyst perspective on query thinking and optimization.

Excel Analytics

Job-ready skills focused on dashboards, cleaning, and automation.

Python for Data

Analytical problem solving using Pandas and NumPy automation.

Power BI Pro

Insight-driven storytelling and complex DAX modeling.

Capstone Projects

End-to-end business cases: Sales, Retention, and Marketing Funnels.

Viz Fundamentals

The science of visual communication and dashboard psychology.

Tableau Mastery

Visual analytics and storytelling with advanced LOD calculations.

Statistics & Math

The mathematical backbone of reliable data interpretation.

Cloud Data Stack

Modern data warehousing with Snowflake and BigQuery.

Data Engineering

Building robust pipelines with dbt and Airflow automation.

SQL Mastery

Interactive Learning Module

Selected
My Stack:
System Prompt

"You are a senior Data Analyst and SQL interviewer. Teach SQL from beginner to advanced level using real-world business problems. Focus on query thinking, optimization, and interview readiness. Avoid theory-heavy explanations. Use examples, edge cases, and performance tips."

Practice Style
Scenario → Data Model → Query → InsightOptimizing slow business reportsSolving real-world data bottlenecks
Curriculum
01_Basics: SELECT, WHERE, ORDER BY, LIMIT
02_Joins: INNER, LEFT, RIGHT, FULL (Business Cases)
03_Subqueries & CTEs for complex logic
04_Window Functions (RANK, LEAD, LAG)
05_CASE WHEN & Data Categorization
06_Performance Tuning & Indexing
07_Real World Business Queries
08_SQL Interview Case Studies
Practice Sandbox

1WITH monthly_sales AS (

2 SELECT customer_id, SUM(amount) as total

3 FROM sales

4 GROUP BY 1

5)

6SELECT c.name, s.total

7FROM customers c

8JOIN monthly_sales s ON c.id = s.customer_id

9WHERE s.total > 1000

10ORDER BY 2 DESC;

# press button to execute code preview

Level up your stack.

Join a community of 10k+ data enthusiasts who are mastering the tools of the trade. Built with precision for the modern workspace.

Enroll in 1 Module

"Education is the
ultimate stack."

The Stack is more than just tools. It's a philosophy of learning in public, simplifying complexity, and mastering the fundamentals.

alsopranab

Pranab Debnath

Founder, @the.queryguy

The Philosophy

Most analytics training is stuck in the 2010s. We're building for the 2025 analyst who uses LLMs as a co-pilot, not a replacement.

Public Learning

Share your progress, build your brand.

Clean Aesthetics

Design matters in data storytelling.

Core Fundamentals

AI is a tool; SQL is the foundation.