Mixpanel: Introducing JQL, a query language to analyze and learn from data
mixpanel.com
mixpanel.com
https://confluence.atlassian.com/jira/advanced-searching-179...
BAM.
(Disclaimer: I work for Treasure Data. That said, there's also an open source way to do this with Embulk + many common SQL databases. See https://github.com/embulk)
In my mind, the whole value of these providers is that they make that one kind of analysis really easy and pretty. But if you feel like you're outgrowing that and want to slice your data in new ways, I don't think you'd choose Mixpanel for their data capture alone, right? So is it just that the cost of Mixpanel is sunk and so might as well get the data they're already recording out?
You are what you measure, this had made it easy for us to centralize our data.
e.g.
https://amplitude.com/sql-queries
etc
The only thing I loathe about SQL is its lack of re-usability. It is hard to write reusable parts and pass them around in functions. Need ten filters which you may / may not use? Write ten queries!
Thankfully, the problem is solved by ORMs ( SQLAlchemy, in my case ). Certainly, in many cases, the mental mapping of map, filter and reduce makes more sense but in the most, I have been more comfortable with using a powerful ORM layer and SQL.
ORMs were a huge step forward for devs, but there wasn't really anything similar for analysts. Looker (where I now work after three years as a customer) is, in many ways, the equivalent of an ORM for analytics.
while(true) {
// it's great feature but i'm not sure that javascript is the right language. just because sql is not the best way to run analytic queries such as funnel and retention, it doesn't mean that we need a replacement. you basically expect all data analysts to learn javascript instead of sql.
}
}