Business Intelligence

Evidence – code-based business intelligence and reporting

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
MetabaseBusiness intelligence and analytics software
GrafanaPlatform for monitoring and observability
SupersetData visualization and data exploration platform
RedashExplore, query, visualize, and share data
Knowage(formerly SpagoBI) Flexible business intelligence suite
ReportServerModern and versatile business intelligence platform
Apache ZeppelinInteractive notebooks for data analytics and visualisation
KNIMEKonstanz Information Miner
JasperReportsA widely used reporting engine
RillOperational BI tool
BIRT ProjectEclipse-based reporting system
QuerybookCollaborative SQL editor for querying and exploring large datasets
LightdashLooker alternative
evidenceCode-based alternative to drag-and-drop business intelligence tools
ShaperSQL-first analytics and dashboard platform
Frappe InsightsSelf-service business intelligence with interactive dashboards

Read our verdict in the software roundup.


Best Free and Open Source Software 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.
Subscribe

Please read our Comment Policy before commenting.

Notify of
guest
0 Comments
Oldest
Newest Most Voted