{"id":3938,"date":"2022-10-14T12:07:57","date_gmt":"2022-10-14T12:07:57","guid":{"rendered":"https:\/\/decentro.tech\/blog\/?p=3938"},"modified":"2024-06-13T12:01:36","modified_gmt":"2024-06-13T12:01:36","slug":"metabase-for-making-data-driven-product","status":"publish","type":"post","link":"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/","title":{"rendered":"Usage of Metabase for making a data-driven product"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class=\"ez-toc-list ez-toc-list-level-1\"><li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/#Is_Metabase_the_answer\" title=\"Is Metabase the answer?\">Is Metabase the answer?<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/#Lets_dig_deeper_for_the_oil\" title=\"Let\u2019s dig deeper (for the \u201coil\u201d)\">Let\u2019s dig deeper (for the \u201coil\u201d)<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/#Why_is_Metabase_awesome\" title=\"Why is Metabase awesome?\">Why is Metabase awesome?<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n<figure class=\"wp-block-image size-large featured-post-img\"><img loading=\"lazy\" width=\"854\" height=\"854\" src=\"https:\/\/decentro.tech\/blog\/wp-content\/uploads\/Usage-of-Metabase-for-making-a-data-driven-product.jpg\" alt=\"\" class=\"wp-image-6244\"\/><\/figure>\n\n\n\n<p>\u201cData is the new oil\u201d. We have all heard this adage but does it fit in the startup ecosystem? The statement might be true for large enterprises which have multiple verticals and many departments looking at metadata or transactional level information to make sense of it, but what about a growing startup?&nbsp;<\/p>\n\n\n\n<h1><span class=\"ez-toc-section\" id=\"Is_Metabase_the_answer\"><\/span><strong>Is Metabase the answer?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p>It&#8217;s wise to start early and bloom according to the customer or market requirements when they come.<\/p>\n\n\n\n<p>As mentioned earlier, large enterprises might have data engineers setting up pipelines, and dedicated personnel preparing dashboards and presentations using the data collated from the multiple divisions of the organisation, but a startup has limited resources in terms of man-hours and funds.&nbsp;<\/p>\n\n\n\n<p>This is where our trusty friend Metabase comes in. Metabase is a business intelligence tool that lets you access your data in a read-only manner. The only setup required is getting the docker up and running, then following the steps to add your database. No engineers or extra licensing costs are involved.<\/p>\n\n\n\n<h1><span class=\"ez-toc-section\" id=\"Lets_dig_deeper_for_the_oil\"><\/span><strong>Let\u2019s dig deeper (for the \u201coil\u201d)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p>We at Decentro have a central RDBMS database containing transactional data. This makes querying the data easier and extracting information a piece of cake. Metabase sits on a separate instance and has read-only access to this database.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/b544PdMqCr-Lw3TmMjAmYbb7sey5kVNRVu9bGZ264CvTujo8-MwEgt0Qjx0tlhM2mlU-vCosoGENip1UpskCVf46nqQiRusU_buHq7J8U3G9oI-GCdOCGG-98xrTa0xUGS0sX2C_s9vwr5Ujyb0EiocGlKJOQji8IwzDJE9YTPwXSJcUHCBXmAvYTQ\" alt=\"Components of Metabase\"\/><figcaption>Components of Metabase<\/figcaption><\/figure>\n\n\n\n<p>Metabase has 4 important components &#8211;&nbsp;<\/p>\n\n\n\n<ol><li><strong>Questions<\/strong> &#8211; Written and saved queries that can be altered using the query editor or the custom question (used to provide filters and grouping options visually)<\/li><li><strong>Collections<\/strong> &#8211; A set of questions makes a collection. This binding of questions makes them easily manageable.<\/li><li><strong>People<\/strong> &#8211; The users of Metabase.&nbsp;<\/li><li><strong>Groups<\/strong> &#8211; Collections, but for people<\/li><\/ol>\n\n\n\n<p>Metabase allows <strong>people<\/strong> to be self-onboarded using Google SSO, which works very well for us at Decentro. Once a person is onboarded, we assign them a <strong>group<\/strong>, and the group, in turn defines the accesses to the tables and <strong>collections <\/strong>they will have. The permissions can be to view questions in a collection or curate them simply. Groups have policies to manage the access to collections and questions that the admins manage very stringently.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/KtV31dZIdGIR6UOxbQ7DlAlcWCUiVWRh9mIlDeiUjiJKMz_OLGQ80q7H6VmGzweOKHOs2wHejgKgjpCEyxJTKDRJi-TPN2ElYtIrCU9sDL1QQifdv63cPCGxycJr_6NRUGL1-MjXjUx7ZwkwIeg2vIZ4LoIKb1qNe4rC8NsLnjHFxgTHCUNHYEJGBA\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong><em>In the image above, you can see the collections in the left-hand side column and questions belonging to a particular collection.<\/em><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/OQ0eDirLjAAJqVHF7jQB152Ix3kB_mSSdAT2LGtigQX_5KV_CkpLp6TGX7YbGJdFdk12AHATt7ZUcx1uKccBVeLWAyyQV8kKJvlLeWfqBl9py0pIDILvaozXMaQGmsjBfpTrV0ZrG-S82uSl86MO-Vzzl65PT5QoQoi63v7yP-cA98MjnocT_gLB0A\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong><em>In the image above, you can see the groups and people of a Metabase installation<\/em><\/strong><\/p>\n\n\n\n<p>Based on this framework, we have internally divided people into 3 groups<\/p>\n\n\n\n<ol><li>Operations and Sales<\/li><li>Product<\/li><li>Developers<\/li><\/ol>\n\n\n\n<p><strong>The Operations<\/strong> team requires access to dashboards and questions that deal with customer success. Issues like Success rate dipping below a certain threshold, transaction-related issues, and customer billing. Similarly, the Sales team can check how their clients are doing using the data from Metabase.<\/p>\n\n\n\n<p><strong>The Product<\/strong> team needs to have a look at turnaround times, success metrics, and data anomalies. All of these fit in very well with the Metabase way of doing business. It helps the team preemptively check for issues or inefficiencies in our customers&#8217; APIs.<\/p>\n\n\n\n<p><strong>Developers<\/strong> are provided access to Metabase when working with the operations team to debug issues on production servers or do configuration checks or root cause and corrective analyses (RCCA). Since developers work with SQL daily, they can write queries to solve these problems and have a window to the production database.<\/p>\n\n\n\n<p>As you can see the efficiency of the whole Decentro team is benefitted from Metabase.<\/p>\n\n\n\n<h1><span class=\"ez-toc-section\" id=\"Why_is_Metabase_awesome\"><\/span><strong>Why is Metabase awesome?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p>Now that we have seen how to tap into efficiency, let\u2019s dive deep into the why.&nbsp;<\/p>\n\n\n\n<p>Visualizations. Boom. Just, effortless visualizations.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1794\" height=\"489\" src=\"https:\/\/decentro.tech\/blog\/wp-content\/uploads\/Metabase-TYPES.jpg\" alt=\"\" class=\"wp-image-3941\"\/><figcaption><strong>Types of Visualisations <\/strong><\/figcaption><\/figure>\n\n\n\n<p><strong>Scenario:<\/strong> I just fetched some information from the database but want to make a graph.&nbsp;<\/p>\n\n\n\n<p><strong>Solution<\/strong>: A few clicks in the visualization tab, and it&#8217;s done.<\/p>\n\n\n\n<p>No pesky configuration options. Just a clean interface.&nbsp;&nbsp;<\/p>\n\n\n\n<p>Let\u2019s take a closer look at a real-time scenario for better visualization,<\/p>\n\n\n\n<p>Below is a query to fetch Transactions per second for one of the servers. This data represents the traffic on that server and is originally received in tabular format.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/SbHtqEgm01IyKhiDYjyndBicEQj51xtLsQncg5vsL7jfpNLRTc1jruD4lEt7qZDo9G2jICZGpiLnI-vGbE2-V-hP4ETS66iAf1MlQan1RNMx7Si-3393aqnU1T7guFhV2ePPTzexvjIC29G2Z2ISZjbUKVvPuJvRclwKiYnzl1BRbvEroNGZDKbMuA\" alt=\"\"\/><\/figure>\n\n\n\n<p>But tables are not very intuitive. However, charts are. So I click on the visualisation tab and switch my mode from data to visualization, and voila!<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/_99XUHquuuttgcOOC90U2Wssd7CtD6NrcX3jGuMaMBgezGraJvVGu3MGcQMfQ0jTKwuY9ZPplmaSEzJCymQe6Vbn-Gb1thK8vlNYOteU510R2TsJf_niRNu4DBx8J0lCWo5hzywl2Ypmhmaw27jS6NnqMPl6lvYaLPpSvHy7Pk8G-hoSF0ZXJKt8Yg\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong>Bar graph<\/strong><\/p>\n\n\n\n<p>Now, this looks cool and intuitive. I have chosen a bar graph to analyze the TPS data more efficiently. But what if I wanted to further customise it to my liking?<\/p>\n\n\n\n<p>There are options such as setting a goal line if you want to set targets, changing colors (not shown in the screenshot below), showing a trend line, and many more, for each chart type. All the customization is focused on incorporating efficiency and a level of intuitiveness with each chart.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/dxi97d-FlvVwnDTy73pOJftu1xU4tEMsNrvYmJBY6sqLUJvWSHeIA6cJGtT7CjIPo4zoDn3uvrAB8Yq398S6D8oksJ2W44Ei0uIwzcQgAgoX1FdiRkddkIWfLuFetTu-0DS_FQtd7TEwmztGFFvZtvhdOUSgwVg28eoAmZBRhcDAwl6QbX2NXhXgRA\" alt=\"\"\/><figcaption><strong>Stacking option<\/strong><\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/2o1h2v0gaAuRAdEyi2tfMrpRj3sE3y_l961OykTlIQ9JI0YpyuOPiZeesf7WXm95H5ieL6pdx-kXH2TFOJPg2B2Dekmk3mUYAU0WgR9Nl7Z-BiNBGcpkO9FOPU0zwQ_duAm5t1eiDgkc4i5g49CfkZqbZrwfknrOPLBIXo1Yb8A9bYkgbMLOZitnKA\" alt=\"\"\/><figcaption><strong>Axes configuration <\/strong><\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/MNiHiiLuiQ29TvENIs68C92AtJ2_ZyviC9I2hrqX0TDWDX2zhSCghqXpXDs5-iBaKBjqLWNK2JXAFaJFtLtjtjp6JV-qJ54Q-BGjSuAWYI63HgxMGNXqbyp4TY2ZlCUKVChg_H_2lyvmLIQXChz8GReB37HvPdtkNp4Mgp2duT_rHRfAlK9N5i2iTQ\" alt=\"Final Visualisation\"\/><figcaption>Final Visualisation<\/figcaption><\/figure>\n\n\n\n<p>As you can see, my chart now looks good enough for our team to consume and infer information from.<\/p>\n\n\n\n<h1><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p>Metabase is a very important tool in the arsenal of a growing startup. Its impact might be low in the beginning, but as time passes on it becomes more and more valuable. Data-driven product and engineering decisions empower Decentro to understand customer pain points and work on them without the customers conveying them verbally. Metabase is the silent aid for such decisions.&nbsp;<\/p>\n\n\n\n<p>In case it spikes your interest, our engineering team at Decentro has penned more tech blogs to satisfy the developer within you. Be it why we moved to&nbsp;<a href=\"https:\/\/decentro.tech\/blog\/why-we-moved-from-nginx-to-kong-api-gateway\/\" target=\"_blank\" rel=\"noreferrer noopener\">Kong API Gateway from NGINX<\/a>, or a pocket guide on&nbsp;<a href=\"https:\/\/decentro.tech\/blog\/pocket-guide-to-api-request-validation\/\" target=\"_blank\" rel=\"noreferrer noopener\">API Request Validation<\/a>.<\/p>\n\n\n\n<p>We\u2019ll see you next time with yet another tech story!&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u201cData is the new oil\u201d. We have all heard this adage but how does it fit in the startup ecosystem? Let&#8217;s find out<\/p>\n","protected":false},"author":10,"featured_media":3946,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Usage of Metabase for making a data-driven product - Decentro<\/title>\n<meta name=\"description\" content=\"Here&#039;s a quick and simple guide to using Metabase for your data-driven startup. Effortless visualizations and easy data access. Learn more now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Usage of Metabase for making a data-driven product - Decentro\" \/>\n<meta property=\"og:description\" content=\"Here&#039;s a quick and simple guide to using Metabase for your data-driven startup. Effortless visualizations and easy data access. Learn more now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/\" \/>\n<meta property=\"og:site_name\" content=\"Decentro\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/decentrotech\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-14T12:07:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-13T12:01:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/decentro.tech\/blog\/wp-content\/uploads\/Metabase.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1700\" \/>\n\t<meta property=\"og:image:height\" content=\"854\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DecentroTech\" \/>\n<meta name=\"twitter:site\" content=\"@DecentroTech\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data1\" content=\"6 minutes\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/decentro.tech\/blog\/#website\",\"url\":\"https:\/\/decentro.tech\/blog\/\",\"name\":\"Decentro\",\"description\":\"API platform for banking integrations\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/decentro.tech\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/decentro.tech\/blog\/wp-content\/uploads\/Metabase.jpeg\",\"width\":1700,\"height\":854},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/#webpage\",\"url\":\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/\",\"name\":\"Usage of Metabase for making a data-driven product - Decentro\",\"isPartOf\":{\"@id\":\"https:\/\/decentro.tech\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/#primaryimage\"},\"datePublished\":\"2022-10-14T12:07:57+00:00\",\"dateModified\":\"2024-06-13T12:01:36+00:00\",\"author\":{\"@id\":\"https:\/\/decentro.tech\/blog\/#\/schema\/person\/aa045712a482ec089e20e910f756dece\"},\"description\":\"Here's a quick and simple guide to using Metabase for your data-driven startup. Effortless visualizations and easy data access. Learn more now!\",\"breadcrumb\":{\"@id\":\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/decentro.tech\/blog\/\",\"url\":\"https:\/\/decentro.tech\/blog\/\",\"name\":\"Blog\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/decentro.tech\/blog\/engineering-and-apis\/\",\"url\":\"https:\/\/decentro.tech\/blog\/engineering-and-apis\/\",\"name\":\"Engineering &amp; APIs\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/\",\"url\":\"https:\/\/decentro.tech\/blog\/metabase-for-making-data-driven-product\/\",\"name\":\"Usage of Metabase for making a data-driven product\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/decentro.tech\/blog\/#\/schema\/person\/aa045712a482ec089e20e910f756dece\",\"name\":\"Shobhit Verma\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/decentro.tech\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4e80decb62b255327eee313ca610d60?s=96&d=mm&r=g\",\"caption\":\"Shobhit Verma\"},\"description\":\"CTO at Decentro. Making fintech great again!\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/decentro.tech\/blog\/wp-json\/wp\/v2\/posts\/3938"}],"collection":[{"href":"https:\/\/decentro.tech\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/decentro.tech\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/decentro.tech\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/decentro.tech\/blog\/wp-json\/wp\/v2\/comments?post=3938"}],"version-history":[{"count":10,"href":"https:\/\/decentro.tech\/blog\/wp-json\/wp\/v2\/posts\/3938\/revisions"}],"predecessor-version":[{"id":6752,"href":"https:\/\/decentro.tech\/blog\/wp-json\/wp\/v2\/posts\/3938\/revisions\/6752"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/decentro.tech\/blog\/wp-json\/wp\/v2\/media\/3946"}],"wp:attachment":[{"href":"https:\/\/decentro.tech\/blog\/wp-json\/wp\/v2\/media?parent=3938"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/decentro.tech\/blog\/wp-json\/wp\/v2\/categories?post=3938"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/decentro.tech\/blog\/wp-json\/wp\/v2\/tags?post=3938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}