danielmarcgardner

Atom Setup

Atom is a great code editor that has a lot of really great packages. I recommend the emmet package for writing JSX with autocomplete.

To set it up go to Atom -> Preferences -> Install:

1. Install emmet package in atom.
2. Install language-babel package in atom.
3. Go to Atom -> Keymap...
4. Paste the following code at the bottom of the page:

danielmarcgardner

Introduction

Galvanize - Galvanize

Daniel - Linkedin and Github

CSS Lecture Slides

CSS Webinar Objectives:

danielmarcgardner

SELECT 
  cast(MAIN.metro_region as string) as __metro_region__,
  cast(FORMAT("%'d",SUM(MAIN.sessions)) as string) as __sessions__,
  cast(FORMAT("%'d",SUM(MAIN.transactions)) as string) as __transactions__,
  cast(CONCAT("$", format("%'.2f",SUM(MAIN.transaction_revenue))) as string) as __transaction_revenue__,FORMAT_DATE("%m/%d/%Y", date(MAIN.datehour) ) as __datehour__ 
FROM ecommerce.ecommerce as MAIN, 
  (SELECT SUM(transactions) as sum1 , metro_region FROM ecommerce.ecommerce  WHERE date(datehour) >= DATE_ADD(CURRENT_DATE, INTERVAL -7 DAY)  AND date(datehour) <> CURRENT_DATE GROUP BY metro_region) as SUB1 
WHERE ( (MAIN.sessions >= 10)  or (MAIN.transactions > 5) ) 
AND date(MAIN.datehour) = DATE_ADD(CURRENT_DATE, INTERVAL -1 DAY) 
AND  (MAIN.metro_region = SUB1.metro_region) 

danielmarcgardner

//visualMetaData
{
  "schemaName":"ecommerce",
  "tableName":"ecommerce",
  "selectFields":[
    {"column":"metro_region","aggregator":null},
    {"column":"sessions","aggregator":"SUM"},
    {"column":"transactions","aggregator":"SUM"},
    {"column":"transaction_revenue","aggregator":"SUM"},
    {"column":"datehour","aggregator":null}