It can also be extremely slow when downloading data from Metabase into a CSV file (sometimes then failing after ages of waiting), and even re-ordering columns within Metabase. This can be so frustrating, because I occasionally need some data urgently and this really impacts my productivity. It can be so slow sometimes - quite often I have to use it late at night when fewer colleagues are also accessing it and it seems to go much faster then. It's really good and makes using SQL easy. Finally, I like that it comes up with suggestions when I'm writing SQL about data columns and tables. I also use Metabase to run SQL scripts created by colleague's as part of our employee payment process - it works really well with google sheets for this. I also like that I can then download it as a CSV with ease. It's integration with SQL is just fantastic, it makes it really easy for me to run a script to find virtually any data I need from our company's performance. Metabase is an amazing tool for storing vast quantities of data. I use Metabase to run SQL scripts to find data from our large database - which is itself stored in Metabase. And secondly, for me to collect any data I require from our company database in Metabase - with an SQL script, I can find everything I want and I cannot express with words how useful that is for me every day! I believe has efforts in building a metrics and self-service analytics layer (like Looker) but is not very well integrated with the product and seems very complicated to use.Īlso some of the features have bugs, but most of the time they are fixed very quickly.Ĭomments: It has two main functions for me - converting data entered into Google Sheets by colleagues into a suitable format for us to be able to upload it as payment data via an SQL script. If you can use SQL you can use Metabase to amazing results and give your company great BI.Īs an open-source product, Metabase is also constantly evolving: each update comes with new features that are useful for us. I also like the fact that it is a SQL first tool and doesn't require any specific knowledge to use. It also offer somewhat advanced features considering its simplicity (like email and slack integrations). I love that Metabase is open source and extremely easy to implement. It is difficult for us to move away from it because its very expensive competitors offer very little comparatively. It is not the most advanced tool avaliable, but it offers amazing value as an open source product. It was very easy to implement and we were able to offer great analytics quickly with it. If you want more information or to see how Metabase could help you visualise and analyse your data, please contact us using the form below.Comments: Metabase is omnipresent in our company: everybody uses it everyday for one thing or another here. In the meantime, more information about Metabase here. We’ll be showing alternative, more powerful ways to share visualisations in future posts. If you’re using Internet Explorer, now would be a good time to use a different browser.Īll the examples above have been embedded using a simple Iframe. The dashboard below is ‘live’ and there’s even a filter so you can see sales by individual or groups of states (go ahead and click the State button to the top right!). Next we can create a Dashboard containing multiple questions. Embedding ‘questions’ is simply a case of turning on sharing and copying a url. The pie chart is ‘live’ running from our test server. The more observant amongst you will have noticed that hovering over the chart provides more details. Two clicks later, you have a simple table of product sales by category: You start of by asking questions of your data: Instead, the focus is on exploring and interacting with your data. Metabase doesn’t give you the what-if analysis of Crystal Dashboard. Our test server is costing about £10 per month on Microsoft Azure! More importantly, you’re getting the choice of running on your own server or in the cloud, rather than being forced into an expensive monthly licence. If you don’t know what any of that means don’t worry, we’re here to help. It can be deployed in a multitude of ways: we’re currently running on Windows Server 2016 and Ubuntu Linux, but you can just as easily use Docker, AWS Elastic Beanstalk or Heroku. In their own words:Īs it’s Open Source, there are no licence fees, so you can use throughout your organisation without worrying about purchasing or managing licences. First off, there are appear to be an infinite number of alternatives!Īfter weighing up the pros and cons of various products, we’re now focussing on Metabase. The demise of Crystal Dashboard has spurred us to look at alternative visualisation tools that are suitable for creating easy to use dashboards.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |