BigQuery 1️⃣ 0️⃣ 1️⃣
Karen Hsieh
Director of Platform Product @ ALPHA Camp
Moderator of dbt #local-taipei
A product manager builds company-wide data literacy and empowers the product team to create values for people and grow the company.
Agenda
Why use BQ?
Check Data
Started from waiting too long….⏳
When I needed to check few numbers, download csv from backstages.
It’s easy but not FUN if repeated > 5 times.
🖥
🖥
🖥
🖥
🖥
🖥
🧞SQL
SELECT
month,
SUM(revenue) AS revenue
FROM revenue_raw
GROUP BY 1
ORDER BY 1
It’s easy. Just like a sentence.
Concept is similar to the pivot table.
It’s so FAST.
How to use SQL?
+
= 🤷♀️
Where is the data? How can I get?
Where can I use SQL?
Use BigQuery
as Data warehouse
CTO
Since data is from our production, can I….
Get data from production!
“Are you querying data? 🤪
OLTP is very different from OLAP�Cloud Data Warehouse Benchmark Redshift vs Snowflake vs BigQuery | Fivetran explains more details by George Fraser
How to get started?
Google!
What is BigQuery?
What is Data Warehouse?
What is Google Cloud Platform?
� ……….😅more unknown
Just do it 😆
Using BigQuery right away
Free Trial
+ Public data
UI friendly - view
2
3
4
5
1
UI friendly - query
1
3
2
4
5
SQL in BigQuery
Keep Update 💪
https://cloud.google.com/bigquery/docs/release-notes
What do I use on BQ?
Data Analysis
Data warehouse + computing
🖥
Load
Extract
Transfer
Analysis
👷♂️ Engineer
🙋♀️ Me
Visualize
It’s ok to be a black box.
I don’t need to understand.
It’s fast ⚡️ for exploring data
Transfer
Analysis
Visualize
Known data
Check analysis result
Try different analysis
Insights 💡
Start Now 👩💻 🧑💻
What do you do?
Google Cloud Training
Thank you
Welcome connect 👋�linkedin.com/in/karenhsieh
Q&A
Raise your hand 🙋♀️🙋🙋♂️
Register for Coalesce 2022�The Analytics Engineering Conference
Coalesce Online
October 17-21, Online
FREE
The main experience you know and love.
Visit coalesce.getdbt.com/register
Coalesce Hub
October 17-21, New Orleans�Our first time together, in person!
Coalesce Online +
London, 20 October 2022�Sydney, 21 October 2022
Thank you
Welcome connect 👋�linkedin.com/in/karenhsieh
Q&A
Raise your hand 🙋♀️🙋🙋♂️