coddatg

Learn SQL not through listing grammar like SELECT and WHERE, but by solving business questions like "What are recent sales?", "Who buys more?", and "What are the Top 5 products?". Practice hands-on in a free environment (BigQuery Sandbox + Looker Studio) and complete analysis results with dashboards.
You can gain practical data analysis thinking along with SQL fundamentals without getting bored.

E-commerce Data-Driven Story-Based SQL – BigQuery & Looker Studio Practice

데이터분석실습

대시보드

입문

초급

중급이상

data-visualization

looker-studio

bigquery

Data literacy

Welcome!

Settings

SELECT, FROM, JOIN Basic Querying

Summarizing Data with Aggregate Functions

Breaking Down Questions, Defining Problems

Filtering by WHERE

GROUP BY and Aggregate

INNER JOIN, CROSS JOIN, OUTER JOIN

Window Functions: Calculating Moving Sum, Smoothing

Rank sales using rank function

Setting up a Sales Dashboard

Building a User Analytics Dashboard

Configuring a Product Dashboard

Summary