Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published NCAA Check - Chart 5

Comparison of model results, only first round games
Published Square Example on Sample Data

SELECT DATE_TRUNC('day', e.event_date) AS "Ti... '2014-07-01' GROUP BY 1,2,3,4,5 ORDER BY 6
Published Force Directed Graph Example

Example for making a simple force directed graph. See presentation comments to change n...
Published NCAA Check - Chart 2

FiveThirtyEight's predictions using a narrow sample
Published Company Success by Founder Experience

SELECT z.previous, AVG(z.funding_round... 1 -- HAVING COUNT(*) >= 5000000 ORDER BY 1
Published County Map Query Example

Learn how to make this map! https://github.com/bstancil/ip-lookup/blob/master/README.md
Published Ben Walker 538 Bracket

Source: http://getitben.github.io/weightedCoin
Published Natural disasters

SELECT decile, MIN({{bucket_by}}) AS l...s], ['cars',cars]] {% endform %}
Published MLB, NFL, NBA, and NHL games by week

This shows the number of games played in the MLB, NFL, NBA, and NHL every week.
Published How engaged are your users?

This report breaks down how old your users are, and shows the evolving age of your user...
Published A simple time-series graph

An example of a time series chart in Mode.
Published D3 bar chart example

SELECT * FROM benn.d3_bar_chart_example
Published Referencing data in the Mode Presentation.

A simple example of how to reference query results from Mode's presentation.
Published The most and least exciting days in sports

Searching for the most and least exciting days in the MLB, NBA, NFL, and NHL.
Published User churn and retention

This report shows how your users are retaining over time.
Published Line chart example

Example of format for making a line chart.
Published The Distribution of the U.S. Population

A graphic exploring where Americans live.
Published Test

SELECT 1
Published Crunchbase Example

Example report using Crunchbase data.
Published Retrosheet - Plotting MLB Win Totals

The graphic plots wins for every MLB team for every season since 2004. For win-loss rec...