search

CartoDB / academy

Academy
https://carto.com/academy
49 stars 22 forks source link

Migrating lesson from workshop #382

Open mehak-sachdeva opened 8 years ago

mehak-sachdeva commented 8 years ago

Course sql and postgis in CARTO - lesson 4 - Intermediate SQL There could be some styling oversights - let me know if this fits in well. @ohasselblad

andy-esch commented 8 years ago

Looking good so far, @mehak-sachdeva.

What do you think about adding an additional section that normalizes the rat sightings by the number of people in each borough? We can get that data from the Data Observatory API.

mehak-sachdeva commented 8 years ago

Did most of the formatting and file/site linking changes as suggested. Making a new map now and will look to incorporate the normalization by number of people in each borough with DO and add that section subsequently. Also thinking of a better lesson name alongside. @ohasselblad

andy-esch commented 8 years ago

For the naming, I suggest using some terms that are important in the lesson: group by, aggregate, postgis, join, dates, strings, rats, etc. etc. :) it'll be a crazy name!

andy-esch commented 8 years ago

@mehak-sachdeva, what's the status here? seems like it's almost ready to be merged?

mehak-sachdeva commented 8 years ago

@ohasselblad - still need to add the DO part to the map and subsequently to the lesson. Should be able to do this by EOD today.

andy-esch commented 8 years ago

I'd say let's hold off on the DO extension to this until later! We can add it as a separate chapter. Maybe create a ticket and assign for after the DO lessons come out?

mehak-sachdeva commented 8 years ago

Yes, I feel that does make more sense. Okay - let me proof everything once and link the map that I have (without the DO) and then we can merge it!

mehak-sachdeva commented 8 years ago

@ohasselblad relinked to the map in documentation account. Good to go?