Your browser doesn't support the features required by impress.js, so you are presented with a simplified version of this presentation.

For the best experience please use the latest Chrome, Safari or Firefox browser.

Introduction to Location Intelligence with CartoDB

Juan Ignacio Sánchez Lara

juanignaciosl@cartodb.com

@juanignaciosl

Juan Ignacio Sánchez Lara

juanignaciosl@cartodb.com

@juanignaciosl

UVa
I. T. Sistemas + I. Superior Informática
AVA, Telefónica, Thales
Developer
ITACyL
Software Analyst / Developer
CExC
Developer, CTO ...
CAG JCyL
Analyst
Compiled Cubes
Cofounder / iOS Developer
CartoDB
Backend Developer

More information at personal and (newborn) develop blogs

Introduction to Location Intelligence with CartoDB

  1. What is CartoDB?
  2. Importing data
  3. Creating maps
  4. How does it work?
  5. Programming with CartoDB

The company

  1. Since 2012. HQ in NY. Offices in Madrid, Tartu
  2. Over 200,000 users
  3. 1,500 paying customers
  4. 300% revenue & user growth YOY
  5. 102 employees around the world (most in EU/US)
  6. Total funding to date: $30M

More information at CartoDB.com

The product

Uncover the unknown with CartoDB…

Make the invisible visible. Give meaning to your business data to identify patterns, discover trends and make faster, better decisions.

CartoDB is Location Intelligence.

Choices for riders along the L to get to Manhattan

Full analysis at The L Train closure—what data can tell us

Every shot Kobe Bryant ever took

Try it at Los Angeles Times

Big Data for Business Intelligence

Wanna more?

The product: distribution channels

  • Open Source
  • SaaS
  • On-premise

This has many challenges, see Continuous Integration at CartoDB talk if you're interested

The product: components

  • Editor
  • APIs
    • CartoDB PostgreSQL extension
    • Data Services API
    • Import API
    • Maps API, SQL API
    • CartoDB.js, DeepInsights.js
  • Mobile SDK

Editor Demo

  1. Register

Editor Demo

  1. Register
  2. Import

Editor Demo

  1. Register
  2. Import
  3. Edit

Editor Demo

  1. Register
  2. Import
  3. Edit
  4. Publish

Editor Demo

  1. Register
  2. Import
  3. Edit
  4. Publish
  5. LET'S TRY IT!

Editor

More CartoDB editor information

Editor

More CartoDB editor information

Importer

Importer

Importer

PostgreSQL

PostgreSQL great documentation

PostgreSQL

PostgreSQL great documentation

PostgreSQL

PostgreSQL great documentation

PostGIS

PostGIS manual

PostGIS

PostGIS manual

CartoDB <3 PostgreSQL + PostGIS

CartoDB <3 PostgreSQL + PostGIS

CartoDB <3 PostgreSQL + PostGIS

Full demo

  1. Import and geocode Valladolid bus stops.

Full demo

  1. Import and geocode Valladolid bus stops.
  2. Import "statistical areas" dataset

Full demo

  1. Import and geocode Valladolid bus stops.
  2. Import "statistical areas" dataset
  3. Import demographics from areas.

Full demo

  1. Import and geocode Valladolid bus stops.
  2. Import "statistical areas" dataset
  3. Import demographics from areas.
  4. Create `population_at_areas` cleaning previous and joining with areas by `clave`.

Full demo

  1. Import and geocode Valladolid bus stops.
  2. Import "statistical areas" dataset
  3. Import demographics from areas.
  4. Create `population_at_areas` cleaning previous and joining with areas by `clave`.
  5. Create a map with areas and bus stops.

Full demo

  1. Import and geocode Valladolid bus stops.
  2. Import "statistical areas" dataset
  3. Import demographics from areas.
  4. Create `population_at_areas` cleaning previous and joining with areas by `clave`.
  5. Create a map with areas and bus stops.
  6. Get the number of bus stops per area.

Full demo

  1. Import and geocode Valladolid bus stops.
  2. Import "statistical areas" dataset
  3. Import demographics from areas.
  4. Create `population_at_areas` cleaning previous and joining with areas by `clave`.
  5. Create a map with areas and bus stops.
  6. Get the number of bus stops per area.
  7. Add the count to the population per areas zone.

Full demo

  1. Import and geocode Valladolid bus stops.
  2. Import "statistical areas" dataset
  3. Import demographics from areas.
  4. Create `population_at_areas` cleaning previous and joining with areas by `clave`.
  5. Create a map with areas and bus stops.
  6. Get the number of bus stops per area.
  7. Add the count to the population per areas zone.
  8. Create a map showing areas, stops, population and count.

Full demo

  1. Import and geocode Valladolid bus stops.
  2. Import "statistical areas" dataset
  3. Import demographics from areas.
  4. Create `population_at_areas` cleaning previous and joining with areas by `clave`.
  5. Create a map with areas and bus stops.
  6. Get the number of bus stops per area.
  7. Add the count to the population per areas zone.
  8. Create a map showing areas, stops, population and count.
  9. Create a Deep Insights page with some widgets!

Time for more?

Questions?

Thank you very much!

Slides & content available soon at juanignaciosl.github.io

Use a spacebar or arrow keys to navigate