
Evidence Has a Free BI Tool as Code — Here's How to Use It
Tableau costs $70/month/user. Looker needs Google Cloud. Evidence generates beautiful data dashboards from SQL and Markdown — deploy as a static site for free. What Is Evidence? Evidence is a business intelligence tool that generates polished reports from SQL queries and Markdown. Write SQL, add charts, deploy as a static site. Quick Start npx degit evidence-dev/template my-report cd my-report && npm install && npm run dev Write Reports in Markdown + SQL # Sales Dashboard ``` sql monthly_revenue SELECT date_trunc('month', created_at) as month, SUM(amount) as revenue, COUNT(*) as orders FROM orders WHERE created_at >= '2024-01-01' GROUP BY 1 ORDER BY 1 ``` Revenue has been growing steadily. Last month we hit **{fmt(monthly_revenue[monthly_revenue.length-1].revenue, '$#,##0')}** . <LineChart data={monthly_revenue} x=month y=revenue title="Monthly Revenue" /> <BigValue data={monthly_revenue} value=revenue title="Latest Revenue" fmt='$#,##0' /> ``` ` ## Available Charts - LineChart, BarCha
Continue reading on Dev.to
Opens in a new tab

