Catalog of Data Storage Tools
As data proliferates in modern organizations, it has become crucial to help the data flow into the hands of operational departments (sales, finance, marketing, etc…), allowing them to turn data into business insights.
This explains the recent explosion of Business Intelligence tools. This new trend is not going to stop, and we'd rather bring visibility and structure soon.
At Castor, we believe the first step to structuring the Business Intelligence tools market, is more transparency. For that reason, we put up a list of all the BI tools we heard of.
This list is still exploratory, may contain errors, or lacking information. Please reach out to us, if you notice anything wrong: louise@castordoc.com
Get started with Business Intelligence tools
In-depth analysis and evolution
Read the full breakdown by generation and market analysis of BI here.
TOOLS FEATURES
Generation:
- 1st generation: Traditional BI.
- 2nd generation: Self-service BI.
- 3rd generation: Augmented Analytics.
User focus:
- Tools focusing on analysts: code are needed to create and generate reports but business users can refresh them. You need to be SQL fluent to engage in meaningful data manipulation.
- Business focused tools: No-code interface allowing business users to engage in real analysis.
Deployment support: Does the solution support a Saas development model, an open-source model? Both?
Data modeling: Can you engage in data modeling through the BI tool platform?
No code interface: Tool proposes a drag-and-drop interface to create powerful, in-depth analyses or simple dashboards + the user can connect, query and visualize your data without writing code.
DW integrations: Which data storage tools does the platform integrate with?
BI tools landscape
Additional features definition (feel free to add yours) :
Data exploration: Explore the underlying query of every chart without breaking the actual dashboard. Allow non tech user to answer more complex questions.
Dashboard builder: build dashboards that suits our needs: your brand color, etc…
Drill down: Click on a chart to have access to the underlying data of which records are at play to describe your metric.
Metric layer: Define your metric layer so that your users can reuse those metrics in charts or exploration.