BigQuery SQL Cheat Sheet - Data Analyst with zeba shaikh

Learn the SQL patterns data analysts actually use with this beginner-friendly GCP - BigQuery SQL Cheat Sheet. Instead of just listing syntax, every section starts with a real business question, like "Which payment mode has the highest return rate?" or "Who are my best customers?", and shows the query pattern that answers it.

All examples use a sample Indian retail dataset (orders, customers, products, returns), so you can see how SQL is used in real analysis.

What's included:

* Conditional aggregation and return-rate analysis

* Date functions for monthly and last-30-day reports

* CTEs to build queries step by step

* Window functions: LAG for growth, running totals, share of total

* Top N per group with ROW_NUMBER, RANK and DENSE_RANK

* Join patterns, anti-joins and the join fan-out trap

* RFM customer scoring with NTILE and cohort retention basics

* Data-quality checks and views for dashboards

* BigQuery cost-saving tips

* Quick syntax lookup table

* Common SQL interview one-liners

* Mistakes to avoid and practice questions

Perfect for: Data Analyst freshers, students, career switchers, and job seekers preparing for SQL interviews.

Format: 5-page PDF. Examples use a synthetic dataset and Google BigQuery Standard SQL.

A practical reference to revise SQL faster and answer "how would you analyse this?" with confidence.