@benn
Bennett Stancil
-
Published Gradient with controls
SELECT DATE_TRUNC('day',created_at) AS day, ....fake_dimension_users GROUP BY 1 ORDER BY 1 -
Published Event Concurrency By Session
Shows which events overlap most often in sessions -
Published Connections by founders
SELECT person_permalink AS financial_org_perm...) a WHERE companies_founded >= 3 ORDER BY 1 -
Published Playoff HCA - Series Data
Series results since 2000. -1 means team with series HCA lost at home. 1 means team wit... -
Published HCA Aggregates
Shows if NBA teams regain home court advantage after losing it in the first two games. ... -
Published How VCs Invest
A visualization of the VC ecosystem. -
Published Recasting Example
Presentation recasts numbers as numbers; should fix scientific notation formatting prob... -
Published Line Chart Example
Example presentation code for line chart. -
Published Age Distribution of Oscar Nominees
SELECT CASE WHEN age >= 5 AND age < 10 THEN '...D a.age > 0 GROUP BY 1 ORDER BY 1 LIMIT 100 -
Published Cohorted Churn Analysis - raw output
Shows output data for this example: https://modeanalytics.com/benn/reports/7a94101077c2... -
Published Retrosheet - Early Season Wins
Shows relationship between 20-game win total and final win total -
Published Movie synopses
Source: Rovi -
Published By Previous Experience - Individuals
SELECT CASE WHEN z.founded_order < 5 THEN z.f...2013-07-01' GROUP BY 1 ORDER BY 1 LIMIT 100 -
Published Previous Founding Success - Individual
SELECT preivous_acquired, COUNT(z.pers...2013-07-01' GROUP BY 1 ORDER BY 1 LIMIT 100 -
Published How Many Pro Athletes - And Olympians - Are Younger Than You?
Same data graphic as by Reuben Fischer-Baum on Deadspin, but with Olympic athletes adde... -
Published Success of Initial Companies - Individual
SELECT CASE WHEN z.companies_founded < 5 THEN...-07-01' GROUP BY 1,2 ORDER BY 1,2 LIMIT 100 -
Published Difference between Winners and Losers
Shows average age of winners and losers by gender for all acting Oscars since 1990. -
Published example
SELECT county_code AS county_id, COUNT...AND county.state = ip.region_code GROUP BY 1 -
Published How Public Debt Affects GDP Growth
GDP growth slows dramatically as public debt rises -
Published Bus Arrival Times
SELECT a.nextbus_arrival_time AS arr_time, ...er: type: text default: N {% endform %}