Connecting Africa: Nomanini, Google Cloud Platform, and BigQuery

Understanding worldwide mobile networks with BigQuery

Watch the full video here
SELECT
radio,
COUNT(*) c
FROM `fh-bigquery.public_dump.opencellid_201803`
GROUP BY radio
ORDER BY c DESC
The most popular mobile radio technologies around the world, according to the OpenCellID tables
CDMA is primarily seen around the US, while the rest of the world uses GSM
Fourth-gen networks like LTE are seen in Africa, but mostly in the big cities. Asia shows huge adoption.
Country ranking by cell towers per capita
Cell towers per capita in each African country
Video: Connecting Africa: Nomanini, GCP, and BigQuery. Press play to watch.
Can we process 10.6 billion rows with Dataflow while on a tram? Check us out.

--

--

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
Felipe Hoffa

Data Cloud Advocate at Snowflake ❄️. Originally from Chile, now in San Francisco and around the world. Previously at Google. Let’s talk data.