rakam-api

The long term solution is usually building an in-house analytics service but it's not easy and cheap. We're also developing a generic analytics platform that can be installed with one-click to your favorite cloud provider so that you can store your event data in your database and build an internal analytics service without coding. Check out: https://github.com/rakam-io/rakam

Data management is a hard problem because most of the companies have different requirements and culture, that's why many "data-driven" companies try to build their in-house own analytics solution. In order to address this problem, we're working on an open-source data analytics platform that let's you to collect data from anywhere and manage it easily with our cloud. Unlike many other analytics services, it solves ETL, data warehouse and BI problem transparently to you so that you can customize them for your needs. It stores your data in optimized format with a schema and allows you to query your data with both SQL and complex behavioral analytics queries via RESTFul API. Check it out: https://github.com/rakam-io/rakam

Shameless plug: I'm the maintainer of Rakam project. You don't have to deal with all of these complexities. There are open-source projects that can setup that infrastructure for you. For example, we provide Cloudformation scripts that setup data analytics cluster for you, Kinesis, S3, PrestoDB and RESTFul API for collecting and querying data-sets so that you can use it similar to how you use a SaaS product. We also have an integrated visualization project that can connect your Rakam API and allow you to create dynamic reports and custom dashboards. You can run queries via user interface similar to Scube UI and also complex behavioral queries such as funnel and cohort queries as well as SQL. https://github.com/rakam-io/rakam