Question

What are your top 5 BI tools?

Choose the ones that have great value. Great user experience. Brings you tons of ROI from stats & insights. And great price that you think it's right.

Mentioned
#Tableau #Google Analytics #Mixpanel #Business Intelligence #Analytics #Spreadsheets
Share
ajay's avatar
2 years ago

The purpose of BI being to gain insight, the simplest and quickest tool works best, and often that's whatever built in reporting a SaaS platform provides, for me.

On the other end of the spectrum, Tableau has been my go-to for a long time now. It has a good user experience for those developing dashboards, and a great UX for dashboard users. I'm a fan of the data visualization principles of Edward Tufte and Stephen Few and Tableau does a great job in naturally guiding you to better dashboards and the speed at which it allows you to iterate your thoughts while developing dashboards is the best I've found. Their cloud service makes it easy to build and share interactive dashboards without any infrastructure. However, it is a little more fragile to maintain without investing in some infrastructure.

Somewhere in the middle, the Google Suite is a great solution for simple BI when you need broad sharing, low cost, and the ability to edit some of the data. We've built many dashboards and scorecards this way, including our company "one page scorecard" that tracks.

9 points
Livenadav's avatar
@Livenadav (replying to @ajay )
2 years ago

Best answer.
10X for sharing!

1 point
ajay's avatar
@ajay (replying to @Livenadav )
2 years ago

Glad it was useful. I left off a few words at the end, meant to finish with "tracks company KPIs".

2 points
maguay's avatar
2 years ago

We're using Amplitude at Capiche now; I'd used Looker at a previous job and have found Amplitude to be far easier to use. On the far more basic scale, Google Data Studio can be a good way to get insights from Google Analytics and more, though without as much detail as Amplitude or similar tools.

Then, a discussion from a couple weeks ago about what business intelligence tools you use had the most people say they used Metabase, Amplitude, and Microsoft Power BI, with others using Looker, Databox, and Holistics.

This other discussion on best data visualization tools has some other simpler tools to start out, where Metabase again came up strong along with Chartio.

5 points
mike_seekwell's avatar
@mike_seekwell (replying to @maguay )
2 years ago

If you're a SQL junky and don't want the overhead of a traditional BI tool (e.g. Tableau), check out https://seekwell.io/. It has a blazing fast SQL editor + ability to send query results to Sheets, Excel, Slack and email. Great for quickly spinning up dashboards, alerts and other analytics. We also have some light weight visualizations.

Disclaimer: I made this.

3 points
mike_seekwell's avatar
2 years ago
1 point
MLGavaudan's avatar
2 years ago

We use:
- Amplitude for quantitative data
- Fullstory for individual deep dive (not sure if this counts as BI)
- Tagai.io for qualitative data
- Typeform for surveys

4 points
maguay's avatar
@maguay (replying to @MLGavaudan )
2 years ago

Interesting, I don't think Fullstory would typically get listed as BI, but you can definitely pull a lot of business intelligence from it.

3 points
MLGavaudan's avatar
@MLGavaudan (replying to @maguay )
2 years ago

I've actually found it can also act as a superset of Google Analytics

1 point
maguay's avatar
@maguay (replying to @MLGavaudan )
2 years ago

Right absolutely. My favorite use is to go back and build funnels retroactively based on, say, people who clicked a specific link or text that otherwise wouldn't have been tracked. One of the few ways to quickly answer questions like that.

1 point
ankitpansari_'s avatar
2 years ago

I am guessing the question is regarding general-purpose BI tools rather than specific tools that are built for web or product analytics such as Google Analytics or Amplitude/Mixpanel?

For general-purpose BI tools, I would recommend MS PowerBI. Especially, if you work with large Excel based datasets. It is user-friendly and Microsoft is expanding the number of integration with PowerBI. It also has an embedded solution. Most importantly, it is one of the most cost-efficient tool out there. A PowerBI license cost $10/user/month compared $70 USD/user/month.

4 points
AdelH's avatar
9 months ago

I agree with @ajay, Tableau is the best. But for digital marketers, i think web platforms are more efficient and easier to use.
In my company we've been using Windsor ai 's connector and platform for pretty much all of our data.
Especially they have a new Google Analytics and CRM connector, which they will be explaining next Tuesday.
Here is a link if you're interested :
https://windsor.ai/forum/t/connecting-google-analytics-and-crm-data-to-understand-customer-lifetime-value/1135

2 points
jeremyb's avatar
2 years ago

Exploratory.io has been rapidly become my go-to BI tool. It’s essentially a nice UI on top of R. I love being able to use random R libraries to transform my data. Having the power of R at your fingertips makes it possible to wrangle and transform data all in one place.

It also has integrated dashboard hosting. Only problem is that their dashboards are limited in their interactivity (so your report consumers can’t easily slice and dice the reports you create). But I don’t see any reason why they won’t add this functionality over time.

2 points
sahanlak's avatar
2 years ago

Ranked in terms of usage frequency.

  • Amplitude
  • Google Data studio
  • Tableau (I have to write code to extract data from systems before loading them into tableau)
2 points
ezramechaber's avatar
2 years ago

Amplitude and Metabase continue to be the tools I'd take to any new project I work on.
Amplitude's free tier has a ton of value and the behavioral analysis

1 point
ezramechaber's avatar
@ezramechaber (replying to @ezramechaber )
2 years ago

Hit send too soon! The behavioral analysis is top-notch.

Meanwhile Metabase doesn't have my favorite SQL editor of all time, but the drag-and-drop functionality for your database is excellent, it has community extensions, and can do the SQL when you need it. Plus it's self-hosted and free. Hard to beat!

1 point
maguay's avatar
@maguay (replying to @ezramechaber )
2 years ago

Did you find Metabase difficult to setup and maintain? Because open-source/free is definitely a huge advantage compared to the price tags on most BI tools.

1 point
What are your favorite small, single-purpose apps?

There are plenty of advanced, powerful software filled with enough features to do almost anything. And then there are the tiny utilities that don't do much, but that are great at what they do do. ...

Do you use Readwise app? How much are you paying for the service?

I came across Readwise this week and I thought it was a very nice app. It sends emails with highlights from Kindle books, Instapaper, Pocket, iBooks and other services. It also offers the spaced re...

How do you manage your chat inbox?

Hey guys, first post here. As part of my work, I have to deal with and respond to a lot of incoming messages from different chats: Linkedin/WhatsApp/Signal/IG. I try to use Unreads/Archive features...

The community for power users.