BigQuery

BigQuery, Powered for Insights: Learn with DataReportive.

This tutorial walks you through BigQuery from basics to advanced reporting. Discover how to structure, query, and optimize your data to fuel smarter dashboards, reports, and analytics—directly aligned with real-world use cases from the DataReportive platform.

Tutorials

Basics

Data Types

Database Management

How to Drop a Column
How to Add a Column
How to Duplicate a Table
How to Rename a Table
How to Drop a Table
How to Create a Table

Dates and Times

How to Round Timestamps
How to Group by Time
How to Query Date and Time
Date and Time Data Types

Analysis

How to Calculate Percentiles
How to Write a Common Table Expression
How to Measure Cohort Retention
How to Generate Series to Avoid Gaps in Data
How to Use countif to Have Multiple Counts