Geek Culture
Published in

Geek Culture

Mathematical Functions you should know in BigQuery

How to Work with Numbers in BigQuery

Photo by Jeswin Thomas on Unsplash

Google’s BigQuery offers a whole range of math functions you can use — check here for more info. However, in my opinion there are a few functions that you really use often and need frequently especially in analytics and dashboarding. Maybe these will help you with your next project.




A new tech publication by Start it up (

Recommended from Medium

How to Enable Flutter Language Experiments?

Hacker101 CTF — Micro-CMS v1

What Is GitOps?

How to Write Good Data Science User Stories

鬼滅之刃劇場版無限列車篇Kimetsu no Yaiba 看線上高清完整版影

SAP Tutorial: Serving Data from an On Premise System in a CAP Java Application (Part 6 )

A photo of a laptop with code on the screen.

Binary Tree Cheat Sheet for next Interview

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store


Big Data Enthusiast based in Hamburg and Kiel. Thankful if you would support my writing via:

More from Medium

How to use the Qualify Function in BigQuery SQL

SQL String Templating in BigQuery: Four Methods

Google BigQuery Datetime Formats

Real-Time Analytics: Using BigQuery to Stream Raw JSON Events