Tweet
Tweet

Slide 1

Slide 1 text

Experts Developer

Slide 2

Slide 2 text

GDE Visualising Mobile Network Data with Google Big Query and Google Maps Dale Humby [email protected] Hiren Patel [email protected]

Slide 3

Slide 3 text

Experts Developer developers.google.com/groups

Slide 4

Slide 4 text

GDE Mobile Networks is Big Data

Slide 5

Slide 5 text

GDE

Slide 6

Slide 6 text

GDE OpenCellID collecting data

Slide 7

Slide 7 text

GDE OpenCellID to Big Query

Slide 8

Slide 8 text

GDE

Slide 9

Slide 9 text

SQL GDE Number of Measurements SELECT COUNT(*) FROM (TABLE_QUERY(africacom, 'table_id CONTAINS "measurements"'))

Slide 10

Slide 10 text

SQL GDE Number of Base Stations SELECT COUNT(*) FROM (SELECT COUNT(*) FROM (TABLE_QUERY(africacom, 'table_id CONTAINS "measurements"')) GROUP BY mcc, net, area, cell)

Slide 11

Slide 11 text

SQL GDE Location of Subscribers SELECT ROUND(lat, 2) AS lat, ROUND(lon, 2) AS lon, COUNT(*) AS count FROM (TABLE_QUERY(africacom, 'table_id CONTAINS "measurements"')) WHERE lat > -34.60 AND lon > 17.80 AND lat < -33.00 AND lon < 20.00 AND HOUR(measured) = 14 GROUP BY lat, lon ORDER BY count DESC LIMIT 8000;

Slide 12

Slide 12 text

GDE Location of Subscribers

Slide 13

Slide 13 text

GDE Subscribers on a Base Station

Slide 14

Slide 14 text

GDE Signal Strength reported by MNO Source: http://www.3g.co.za/index.php/information/coverage-maps/tabbed-coverage-map-of-south-african-networks

Slide 15

Slide 15 text

GDE Signal Strength reported by MNO Source: http://www.3g.co.za/index.php/information/coverage-maps/tabbed-coverage-map-of-south-african-networks

Slide 16

Slide 16 text

GDE Signal Strength on phone

Slide 17

Slide 17 text

GDE What could a MNO use it for: Stream CDR’s to Big Query Bulk loaded in Cloud Store KPI perf monitoring and business trends Engineering, planning and data exploration tool

Slide 18

Slide 18 text

GDE When to use Big Query Adhoc queries on large data Data analysis Streaming inserts keep data live Fast enough for dashboards

Slide 19

Slide 19 text

Experts Developer cloud.google.com $500 promo code: gde-in

Slide 20

Slide 20 text

GDE Thank You App: Data: Code: GDG: Dale Humby [email protected] plus.google.com/+DaleHumby Hiren Patel [email protected] plus.google.com/+HirenPatel dale-humby.appspot.com bigquery.cloud.google.com/queries/dale-humby github.com/GDGCapeTown/bigquery-demo developers.google.com/groups