![]() self help analytics for non-technical users, via interactive dashboards that analysts will prepare (I know tableau is good for this) I'm looking to expand the team adding more analysts and engineers so we can proper coverage of the maintenance of our data pipeline and eventual data warehouse. it's new, and we currently have 1 analyst and 1 data engineer. random data sources like google spreadsheet, data exports (as CSVs), S3, with a postgreSQL db in the near future. We clone it instead, with some additional processing through python scripts(setting up airflow for this) for our analytics/BI Data engineering doesn't interact with that DB. main production database is a mongo NoSQL database. Thanks, really appreciate any information you could share! PowerBI - Still the market leader by share.QlikSense - A slightly older option, but still used by lots of big co's.Tableau - Supports lots of connection types including local csvs etc.Lightdash - An open source alternative to Looker - self hosted is free.Supports embedded analytics with a bit of setup. Evidence - Build reports using just SQL and markdown.Good for a few things but lacks the power and flexibility that other tools can bring.ĭon't pretend to know everything about Data Eng, but my sense is that you are right, without a SQL database you'll struggle to unlock the power of most major BI tools. But I've heard that most BI/analytics tool prefer to connect to a SQL database. it'll take a significant amount of time for us to restructure into a SQL-esque db. *Edit* forgot to mention that we're running a Mongo database. I'd really appreciate opinions or experiences about integrating with them, the cost to maintain as your data size scales, and general long term traps that I might only discover a few years down the road. Our 2 leading considerations are Sisense & Tableau, and I would like to hear everyone's opinions on integrating with either one of them, if there are other (cheaper) alternatives, or if sticking with Metabase is a viable option at all. The biggest issue being Metabase has some severe limits on visualizing large amounts of data (charts don't support more than 100 series of data for example). We are, however, looking to upgrade because Metabase has a number of issues and is still in its prototype phase. My company currently uses Metabase as an analytics tool, we host it on-prem and it mostly fulfills our needs. tableau extracts are useful if your underlying dB is slow.Hey there! I'm sure this has been asked many times before but I've been struggling with this decision for a while and would like some help.But their analyses are of similar if not higher quality. We’ve hired Tableau people and they could pick up Metabase in no time, but they are sometimes resistant and often miss the power of Tableau. Metabase is still niche (though one of the most starred GitHub projects). it is easy to find and hire people with Tableau experience.Keeping hour dashboards simple is often a better idea. interactive dashboards in Tableau can be excellent but they are rarely intuitive.Data blending in tableau is a powerful feature but you need to know what you are doing.Since the Metabase defaults are good, any further refinement in Tableau is likely a waste of time. With Metabase, formatting is quite limited. Tableau has a ton more control over formatting. ![]() Sometimes hierarchies and can make things easier, but Metabase is more intuitive IMO. Tableau required predefined drill paths with hierarchies. Metabase offers drill-down on any dimension.In Tableau, SQL is at the modeling step and not easily accessible if you want to just write sql and get a chart. in Metabase, SQL queries is a first class concern for generating reports.At my organization we use both, but for the most part, I think Metabase is superior. I’m a long time (on and off for 10 years) Tableau user and recent convert to Metabase. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |