thingsilearned

Super awesome. Well done guys!

Congrats guys!!! I love AeroFS!

That would be interesting. Unfortunately that's not available in the tax dataset we have. If it were I'd also question the accuracy of it as well as restaurants have a reputation for being less than precise with their earning filings.

direct link to the dashboard: https://chartio.com/project/16192/dash/sxsw-alcohol-consumpt...

Link directly to data dashboard: https://chartio.com/project/14404/dash/18166/public/

An article on the data here: http://chartio.com/blog/2013/12/the-data-behind-online-activ...

That's a great point and great feedback. I'll adjust the questions in the next interview I do.

Amazing stuff guys! Thanks for open sourcing!

Thanks! Pushing the fix.

Nah, we make a point not to do that. Plus it would all come from the same IP and it wouldn't count as an upvote.

Yeah, our initial version only has support for a direct connection, so a port would have to be open to our IP. We are working on our tunnel connection, which is our reverse SSH solution, but its a different code path for Windows and not ready yet.

http://chartio.com/security/connection#tunnel-connection

Information Dashboard Design - is definitely the first one you should read. It really gives a more high level overview of charting best practices and dashboard design.

Show me the Numbers - goes much more in depth about the details of the different chart types and visualization best practices. There's a chapter or two on each of the main chart types.

Now You See It - This is described as a companion book to Show me the Numbers and focuses on data analysis as opposed to pure visualization.

Stephen Few actually self publishes for reasons he explains here: http://www.perceptualedge.com/blog/?p=1521

I'm not sure why he hasn't made an ebook though. This is a new release so it may be coming.

Not really. We utilize python-dateutil to help recognize the different date formats, but everything else we built ourselves.

http://labix.org/python-dateutil

Yeah, and that's how we used to direct customers who wanted upload CSV data. We even wrote some nice tutorials on how to set it up

https://chartio.com/education/databases/excel-to-mysql

But we found that many people either aren't technical enough, or didn't want to go through the hassle of setting up a MySQL instance, defining a schema, and cleaning the data. So now we do that for them.

Yeah, DataWrangler is an awesome project. There are actually a few great companies coming out with products based around it. We may just integrate with one of those.

Thanks!

I created this board a while ago that is connected to that chess.js

http://thingsilearned.com/projects/chess/

Super odd... We use Zendesk and I don't have a record of any open support tickets. Feel free to send me a note directly to dave at chartio.com if you're still having an issue.

Agreed. I'll work on it.

I'm curious, what was the reason you chose to highly Chartio out of all the companies in the cloud BI space? We actually feel that we have the best security practices in the space, mostly due to the fact that we're the only ones not doing data warehousing, where you're required to upload a copy of your database to the provider.

Thanks, I am a little less sad :)

Those guys for sure have a lot more manpower than we do (so far!) but I might also point out that security isn't totally about how many people you have working on a problem, but how simple you're able to make it. But - that's not me getting into a security argument...

Great use case! We don't support an API that you can push data to, but that's because whatever API we build, it would never be easier to learn or have as much language support than just spinning up a PostgreSQL instance and writing the data to it. Quite a few of our customers use us this way.

Hi Kevin, thanks for the great response! We should continue to share notes on best practices in all of this.

Sadly the alternative is data warehousing (which all of our competitors do). Its the worst solution as it

1. gives a copy of your data to someone else 2. is legally questionably still your data 3. is stagnant (as you usually only backup once a week) 4. there is no way to track where that data goes

Hi, founder of Chartio here. Other than the title (which makes me a little sad) I liked your post. Its great to fully inform people of the security tradeoffs and you've done a nice job of laying out the levels and options of security that we've spent a lot of time developing.

In anything that is cloud based there is going to be some level where some hacker could get in and destroy everything. Most people on this site use cloud hosted servers, all of which would be at risk if Amazon or Rackspace got hacked. BI in the cloud is a new space and will be cautiously entered by some, but benefits will outweigh the potential risks and just as has happened in every other segment of cloud computing.

(will write more soon)

Thanks for the feedback. I've been a member for 5 years and was unaware of that rule. I just re-reviewed the rules. Thanks for pointing them out.

Also apologies that it came off as condescending. I was experimenting with a bit of a different style of post and writing, attempting to come off a bit quirkier. I've learned that its definitely a style that doesn't go well with the HN audience :).

Splunk is not able to. Check us out at chartio.com

Tile style seems to really de-emphasize the titles of the articles in favor of their score.

Emphasizing the score, especially with the ranking algorithm being so time based is fairly confusing. It seems like the number should be in order, but they of course aren't.

A fix may be as simple as changing the two greys, having the darker grey behind the article title, and the lighter one behind the number. Also, increasing the contrast in the title text would be great.

Its hard to put a handle on what is 'Big' and what isn't. I think a decent place to draw the line is on data that can't fit on one disk, and 1 TB seems to be a pretty standard disk size right now.