At EZTABLE, we encourage a self-serving model when asking questions regarding our massive database. For example, an account manager might ask a question such as “What’s the average age of all customers who made reservations in February of 2015?". Any backend engineer could quickly translate the question into the corresponding SQL query and run it against out MySQL database, however that defies our purpose of being transparent and self-serving. So the key element that we need is “an interface that let everyone in our company to interactively ask questions and learn from data". Enter metabase.
Metabase is an open source project that provides:
- Easy to setup
- Let anyone on your team ask questions without knowing SQL syntax
- Rich & beautiful dashboards
Before jumping into the juicy details, let’s first quickly go through a relational data model 101.
Fundamentally data are stored in a database, which is a huge collection of tables, conceptually similar to a large Excel document that contains lots of sheets. Tables contain one or more columns and rows.
All the cells in a column contain the same type of information. For example, in the sample table below, the name column contains name in each cell and member_id column contains the member ID.
A tables can contain references to other tables, which establishes a relationship between them. For example, a database can lookup the age of members based on the member_id column from the booking table.
With metabase, everyone in the company can quickly produce statistics by looking up demographics or anything they want based on relationships. Don’t worry, sensitive informations are hidden away.
Let’s get back to the main topic. How can metabase help us answering questions such as “What’s the average age of all customers who made reservations in February of 2015″? Let’s see a little animation.
Each part of our question can be translated to a corresponding element on the user interface, which is simple enough that anyone within our organization to play with and answer their own questions.
There more tricks that metabse can do e.g.
Subscribe to EZTABLE IDEAS for more articles!
P.S. For those who use Facebook’s PrestoDB, Airbnb has release a similar tool called Airpal.