Hey Alfaz, the tools you mentioned are not exactly BI tools and are essentially ELT tools meant to collect data from third-party data sources (tools used for sales, marketing, advertising, etc) and ingest the data into a data warehouse (Snowflake, Redshift, BigQuery, etc). You can check out the linked article to learn more.
I have also recommended some BI tools like Mode, Looker, and SiSense. Happy to answer follow-up questions!
Created by analysts, for analysts, Mode is a SQL-based analytics tool that connects directly to your database. Mode is designed to alleviate the bottlenecks in today's analytical workflow and drive collaboration around data projects.
Superset's main goal is to make it easy to slice, dice and visualize data. It empowers users to perform analytics at the speed of thought.
Amazon QuickSight is a fast, cloud-powered business analytics service that makes it easy to build visualizations, perform ad-hoc analysis, and quickly get business insights from your data.
Write, save, and share SQL queries with other analysts in your company; Empower non-technical folks to update queries on their own; Run queries on a schedule, create lists of related reports, and explore a project's history as it changes over time;
Build reports using standard charting or create completely customer, interactive visuals with HTML, CSS, and Javascript;Database connectors for MySQL, Postgres, Redshift, Vertica, Hive, Heroku, Segment, BigQuery, Impala;
Mode also offers SQL School (sqlschool.modeanalytics.com), a free, interactive SQL tutorial and the Mode Playbook.
A rich set of visualizations to analyze your data, as well as a flexible way to extend the capabilities;An extensible, high granularity security model allowing intricate rules on who can access which features, and integration with major authentication providers (database, OpenID, LDAP, OAuth & REMOTE_USER through Flask AppBuiler);A simple semantic layer, allowing to control how data sources are displayed in the UI, by defining which fields should show up in which dropdown and which aggregation and function (metrics) are made available to the user;Deep integration with Druid allows for Caravel to stay blazing fast while slicing and dicing large, realtime datasets;
Pay-per-session pricing; Deliver rich, interactive dashboards for your readers; Explore, analyze, collaborate; SPICE (super-fast, parallel, in-memory, calculation engine); ML Insights
Statistics
Stacks
125
Stacks
421
Stacks
208
Followers
227
Followers
1.0K
Followers
394
Votes
17
Votes
45
Votes
5
Pros & Cons
Pros
4
Empowering for SQL-first analysts
3
Collaborative query building
3
Easy report building
2
Integrated IDE with SQL + Python for analysis
2
In-app customer chat support
Pros
13
Awesome interactive filtering
9
Free
6
Shareable & editable dashboards
6
Wide SQL database support
5
Great for data collaborating on data exploration
Cons
4
Link diff db together "Data Modeling "
3
It is difficult to install on the server
3
Ugly GUI
Pros
1
Dataset versionning
1
Super cheap
1
Better integration with aws
1
More features (table calculations, functions, insights)