![]() Vendor lock-in is a very real (and very scary!) thing.Want to avoid potential migrations down the road, don’t care about spend, and want to have/pay for support straight from the company? Looker is great. Want to optimize for speed of implementation and a low cost but know that you’ll have to migrate in a couple years? Metabase is a very solid option (and getting much better, quickly). Having a solid awareness of the tradeoffs, and answering those before picking one solution over another is probably the most important part.There is no perfect solution, and the gripes about various systems are almost always the same: “inflexible for pure exploration”, “doesn’t let me do what shows on their site”, “too expensive”, “slow” (b/c a lot of data is still a lot of data, and a columnar db is still a columnar db), etc.With all this being said, what I’ve found is the following: Periscope/Mode are awesome lower-priced options for small to medium-sized teams (and you don’t want to maintain the system yourself). I’ve also helped companies like Friday Feedback and GetAbstract with analytics, and Mode/ Periscope have worked well.įor pricing context, Metabase cost 100k annually for a UI. A small team of application/ bi engineers builds out the Looker blocks/models, and a large number of analysts are free to explore the data at depth, with no prior SQL experience. But then again, Looker has a very hefty price tag.Ĭurrently the team I work on at CarGurus uses Looker very heavily, sitting on top of a pretty large Snowflake database. Metabase just doesn’t have some of the functionality that Looker does, and Looker is definitely a common solution as BI/ analytics teams mature. During that time, the knowledge of internal data assets and shared understanding of how it was generated/loaded/represented was enormously valuable to the organization. ![]() Eventually the company outgrew the system and moved onto Looker (where the snowplow block is easily implemented as mentioned above). PopSQL has become the closest post-Wagon-acquisition analog.Īt Wanderu we used Metabase sitting on top of Redshift with good success for a couple of years (at an extremently low operational cost). Wagon was heavily used at O’Reilly/Safari for collaborative sql, and worked incredibly well. It was relatively expensive, inflexible, and well… cubes were valuable in Kimball land before columnar db’s came into their own and storage became cheap. I totally agree with about starting to gain traction and thorough understanding of your data with a lower-cost solution.Īt O’Reilly, we used Pentaho sitting on top of a number of cubes in Postgres/Redshift.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |