News for hackers. Stuff that matters.
Re:Show HN: $4.4B in Startup Funding Rounds Visualized by viggity on Tuesday June 24, 2014 @03:42PM (#7940060)
I created this with a new service I released (Machete). Machete is built on top of dc.js (which in turn is built on d3.js and crossfilter). dc and d3 both have decent learning curves, Machete is aimed at non-programmers or as a prototyping tool for developers.

The visualization works best in chrome or any edge browser. In the off chance you're a huge Luddite and surfing HN with IE8, here are a couple extracted stats across the 2,040 rounds:

YC dwarfs other accelerators with $2.8B in funding, next largest is AngelPad with $185M.

Average A Round - $4.3M, B - $17M, C - $58M, D - $98M

Airbnb and Dropbox so skewed stats, that I created a filterable attribute for them called "Freakish_Outlier".

I should be on for a couple hours, please feel free to comment or ask questions.

Re:Show HN: $4.4B in Startup Funding Rounds Visualized by CGamesPlay on Tuesday June 24, 2014 @04:33PM (#7940408)
Looks good. There are two things that will be really important:

- How is data imported? It would be great to be able to set up custom SQL queries, CSV imports, and other service gateways to do analytics on.

- How do I define graphs? I'll want to be able to do time-series, but easily switch between day/week/month/year resolution, and create trailing period averages without having to think about it.

I signed up for the beta. I'd love to play around and do some deep diving on stats we have collected.

Re:Show HN: $4.4B in Startup Funding Rounds Visualized by viggity on Tuesday June 24, 2014 @04:59PM (#7940612)
Right now we only support CSVs they get served directly from blob storage to the browser (without going through our webserver). We obviously want to expand on those options, but CORs makes serving from internal company data sources a PITA. We could use our domain as a proxy to the relevant info, but that has its own issues (auth, perf). I'm sure we'll be able to work it out though. Automated CSV imports will probably be the best way to do things initially.

When you import your CSV, we take educated guesses about the data in each column (number, category, date), but you can change it if necessary (sometimes numbers should be treated like categories). We give you the ability to group dates by day of week and month. Month-year isn't in there yet, but should be by launch.

It works best one un-aggregated source data (since we do so all the fine level aggregation ourselves in the browser). Dealing with weighted averages is possible and we've done it a lot in custom work, but machete doesn't yet have support for it.

Thanks for the kind words :)

Re:Show HN: $4.4B in Startup Funding Rounds Visualized by zheshishei on Tuesday June 24, 2014 @04:57PM (#7940602)
I changed the primary sort to the count, then filtered on just "Fan Go". Then, I wanted to compare the total amount Fan Go had raised in comparison to other companies, so I changed the primary sort back to the total, but then was unable to see "Fan Go" on the "Total Raised - Company" bar chart. I had to hover over the bubble in the graph instead to see the total amount Fan Go had raised.
Re:Show HN: $4.4B in Startup Funding Rounds Visualized by viggity on Tuesday June 24, 2014 @05:28PM (#7940787)
yeah, things can get a bit screwy when you filter and then change the active measure. It isn't a simple fix unforunately. I've added a bug to our backlog. Thanks!
Re:Show HN: $4.4B in Startup Funding Rounds Visualized by unwind on Wednesday June 25, 2014 @04:17AM (#7942791)
Very nice! I missed the currency symbol ($) in the labels, I felt that I wasn't sure sometimes if I was seeing a "count" of something, or a measure of currency.

Perhaps it's all currency so it's redundant, but I still think proper units are a good thing to have when presenting data. Better one too many than one too few, imo.

Re:Show HN: $4.4B in Startup Funding Rounds Visualized by stock_toaster on Tuesday June 24, 2014 @03:53PM (#7940130)
Under "Region" (with raised_total), what is the region between Atlanta and Seattle with no label?
Re:Show HN: $4.4B in Startup Funding Rounds Visualized by viggity on Tuesday June 24, 2014 @03:59PM (#7940172)
its just data that wasn't provided :(
Re:Show HN: $4.4B in Startup Funding Rounds Visualized by pnachbaur on Wednesday June 25, 2014 @12:27AM (#7942240)
You could use median instead of filtering out outliers explicitly so your averages don't get skewed.
Re:Show HN: $4.4B in Startup Funding Rounds Visualized by viggity on Wednesday June 25, 2014 @12:48AM (#7942294)
Median might solve some of that issue, unfortunately it is computationally heavy to do median on a rolling basis, unlike average. Part of the reason the filters work so quickly is because when I add or remove items from the active set, I can just add/subtract from the total and the count for that one item. With median, I'd have to keep the active list sorted which even with a binary tree under the covers is still more expensive than two math operations. The filtering library under the cover is crossfilter.