🌈 Update: Brand new product analytics tool Rakam UI!

burak emre
2 min readSep 18, 2018

--

We have been working intensely for the last 6 months to develop the new version of our app.

Most of the medium-big size to enterprise companies already have their data pipeline either in-house or managed by third-party SaaS solutions. They usually collect all of their company data (product, marketing, financial etc.) in their data lake and use one or more BI solutions in order to analyze their data.

What we had realized is that these BI solutions are usually not useful enough for product teams so product teams still prefer using SaaS analytics solutions such as Mixpanel and Amplitude. This is mainly because most BI solutions try to be generic, you need to spend time to adopt it for your use-case and product teams usually depend on the data team to build up the user behavior (funnel, retention etc.) reports. We try to remove this bottleneck so that you would have more time, you can ask more questions and dig deeper so that you can have a better understanding of your user data.

However; this option may not possible for some companies since it requires sharing customer data with a third-party company. Also even if they can still use these SaaS solutions, it’s not possible to see the big picture since they don’t have access to all company data other than the product data. When you have more than hundreds of event types, it’s often challenging to use these SaaS tools since they’re designed for medium-sized companies so we decided to provide a Mixpanel-like interface (well, much more than that for enterprise companies) to companies which have their own data warehouse.

We redesigned our whole app and the final solution is more like Looker for product data, you enter your database credentials, map your data and start using it without any need of writing SQL. When our high-level reporting features are not able to cover your use-case, you can use our SQL reporting in order to create custom reports.

Here are some of the features that we added to the new system:

  1. Ability to add label, category, and description to tables and columns with taxonomy feature. It’s especially useful if you have hundreds of tables or columns.
  2. Advanced team features for enterprise companies. (table, row and column level permissions, auditing and feature flags)
  3. Ability to create custom SQL reports with variables. You simply embed variables, parametrize SQL queries and create custom reports with custom UI without any need of writing HTML or CSS.
  4. Ability to create OLAP cubes (summary tables) from your raw event-data. In the segmentation feature, you simply run your ad-hoc queries and we take of caching, incremental materialization for you.

The new version is live at https://beta.rakam.io feel free to try it out, give us feedback so that we can make it even better!

--

--