Evidence is a framework for building interactive reports, dashboards and other data applications using SQL and Markdown. It is aimed at analysts and developers who prefer working with text files and code rather than designing every report through a graphical editor.
The framework allows queries, explanatory text and visualisations to be combined into data-driven pages. This makes it particularly useful for creating analytical reports in which charts and tables are accompanied by commentary explaining the significance of the results.
Evidence uses web technologies to turn these pages into interactive applications. Projects can be maintained in version control, reviewed collaboratively and published for colleagues or other readers. Its approach is particularly attractive to teams already comfortable with SQL and Markdown.
This is free and open source software.
Key Features
- Build interactive analytical reports using SQL and Markdown.
- Connect to databases, data warehouses and supported external data sources.
- Use query results directly within written reports and visual components.
- Built-in charts for presenting trends, comparisons and distributions.
- Tables with formatting options for displaying analytical results.
- Interactive filters and input controls for exploring data.
- Conditional content using if/else statements.
- Loops for displaying repeated components or sections.
- Generate multiple report pages from reusable templates.
- Dynamic page routing based on underlying data.
- Combine data from multiple sources for SQL-based analysis.
- Reusable components for maintaining consistent reports.
- Custom components using Svelte.
- Support for charts, tables, maps and other interactive visualisations.
- Projects suitable for version control and collaborative development.
Website: github.com/evidence-dev/evidence
Support:
Developer: Evidence
License: MIT License
Evidence is written in JavaScript. Learn JavaScript with our recommended free books and free tutorials.
Related Software
| Business Intelligence Software | |
|---|---|
| Metabase | Business intelligence and analytics software |
| Grafana | Platform for monitoring and observability |
| Superset | Data visualization and data exploration platform |
| Redash | Explore, query, visualize, and share data |
| Knowage | (formerly SpagoBI) Flexible business intelligence suite |
| ReportServer | Modern and versatile business intelligence platform |
| Apache Zeppelin | Interactive notebooks for data analytics and visualisation |
| KNIME | Konstanz Information Miner |
| JasperReports | A widely used reporting engine |
| Rill | Operational BI tool |
| BIRT Project | Eclipse-based reporting system |
| Querybook | Collaborative SQL editor for querying and exploring large datasets |
| Lightdash | Looker alternative |
| evidence | Code-based alternative to drag-and-drop business intelligence tools |
| Shaper | SQL-first analytics and dashboard platform |
| Frappe Insights | Self-service business intelligence with interactive dashboards |
Read our verdict in the software roundup.
LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |


Please read our Comment Policy before commenting.