Metabase bi4/16/2023 ![]() The key task is to keep all this data consistent and up to date. ![]() 2023 Mirko Morandini Asset Management, Unified Monitoring Using GLPI with the Metabase Open Source BI Tool for Visualizing Rich Reports and DashboardsĪsset management/CMDB tools play (or should play!) a central role in IT operations and management, gathering data from hardware assets on contracts, software licenses, network configurations, tickets and many more. It’s ease of use, great user interface, and strong community support make it a business intelligence tool that can rival, if not outdo, many commercial options available in the market.04. Overall, We believe that Metabase is one of the best available open-source BI tools currently available on the web. No”plug-and-play” connectors you can easily use to integrate data from a SaaS system.Need to do some data mapping to get started.Inability to create complex questions without the use of MySQL.Local version to quickly get up and running is only available for Mac.Reminders, or “pulses”, that can be programmatically sent out.Variety of databases you can connect to.Multiple ways by which you can set up Metabase on cloud platforms.Free and open-source with an active developer community.Metabase also has the ability to send out updates on specific queries (Metabase calls them “questions”) on a repeating frequency or whenever that particular question changes to either Slack or e-mail. One of the downsides of Metabase is that it doesn’t possess the level of granularity in creating questions (ie: queries) that Domo, or particularly Tableau, have. More technology-savyy users can use basic MySQL to create more complex queries. Once Metabase is set up users can access the Metabase question creator and intuitively create questions without the use of any programming. They can serve to convey data in a simple and fast way, especially when you take a collection of these and group them in a dashboard as you can see below. One of the best features of Metabase is its stunning visualizations and the fact that non-technical users can create them. The following are all the database types Metabase supports and can connect to: Usually, commercial offerings will have multiple integrations with the more popular web applications, one of these is Domo, which we will cover later on in this series. It’s unfortunate there aren’t any “plug-and-play” connections you can create with SaaS services such as LinkedIn, Google Drive, Twitter.etc but that is usually the case with the open-source business intelligence offerings. There are multiple databases that you can connect with Metabase. ![]() You can install Metabase in the following ways using a wide array of cloud platforms: In this case, Metabase won’t be accessible via a public URL via an internet browser like Google Chrome or Mozilla Firefox since it’ll only live on your local machine. There are many ways to install Metabase, but if you’re looking simply to test it out, have a Mac computer, and don’t want to spend too much time doing installation and configuration you can install Metabase directly on your computer. It does require some level of technical proficiency to both install, set up a database connection, and then configure the database table relationships between the various tables (ie: one of the major steps you need to do is set up the proper foreign keys between tables which you can do via the Metabase interface but you still need to know what table keys link to what other table keys). Metabase is our favorite business intelligence tool to get up-and-running within a small amount of time relative to other open-source alternatives. In this series we will cover the four following applications: In this first of our series on “Business Intelligence Tools We Recommend” we’re going to cover Metabase – a popular open-source BI tool you can find on GitHub. In this 4-part series, we’ll briefly explore some the tools we believe are best suited towards helping you get value out of your data. But it never really matters unless you’re getting real value out of it. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |