Own your business intelligence reports with evidence.dev

09/28/23 • 9 min

Ever felt trapped by traditional BI tools? We did too. That's why we're thrilled to share our experience with evidence – a tool that lets you build business intelligence dashboards using good old SQL and Markdown.
Highlights
00:00 Introduction
00:48 Features and capabilities of evidence
01:31 Portability and open source nature of evidence
02:52 Examples and use cases
04:17 Component reference and data sources
05:35 Build process and deployment
06:04 Code examples and dynamic routes
07:08 Adding static information to dashboards
08:13 Intended use
Links
- Evidence Website: https://evidence.dev/
- Evidence Examples: https://evidence.dev/examples
- Evidence Docs: https://docs.evidence.dev/
- Markdown Basics: https://www.markdownguide.org/basic-syntax/
- SQL Tutorial: https://www.w3schools.com/sql/
- DuckDB: https://duckdb.org/

Previous Episode

Reality Check: The Limits of View Transitions

Ever wondered how to animate between two UI states without wrangling heaps of extra code? Well, get ready to unlock a new level of web development capabilities with us, as we dive into the exciting world of view transitions.
Highlights
00:00 Introduction
00:44 Understanding View Transitions
02:05 Demos & Practical Applications
03:14 Current Reality vs. The Dream
06:47 Potential Use Cases & WordPress Context
07:25 View Transitions With HTMX
08:31 Working With View Transitions in CSS
12:54 Conclusion
Links
- Chrome Developers Article: https://developer.chrome.com/docs/web-platform/view-transitions/
- Astro 3.0 View Transitions: https://astro.build/blog/astro-3/#astro-view-transitions
- Svelte View Transitions: https://svelte.dev/blog/view-transitions
- HTMX View Transitions: https://htmx.org/docs/#view-transitions
- View Transitions API Overview: https://developer.mozilla.org/en-US/docs/Web/API/View_Transitions_API
- Maxi Ferrera's Demo: https://live-transitions.pages.dev/
- Turbo: https://turbo.hotwired.dev/
- swup: https://swup.js.org/
- Shuffle.js: https://vestride.github.io/Shuffle/

Next Episode

The only 3 tools you need for perfect image optimization

Want to serve the fastest loading images in the wild wild web? By the end of this episode, you'll be armed with Google-recommended tools and strategies that set you on a fast track to becoming an image optimization expert.
Highlights
00:00 Intro
00:41 The magic wand
01:46 The right image format
03:02 Going the extra mile
04:20 The right perspective
05:55 Mastering SVGs
07:20 The no-brainer tool
08:38 Conclusion
Links
- Squoosh: https://squoosh.app/
- SVGO: https://svgomg.net/
- ImageOptim: https://imageoptim.com/

Siegfried, deploy! - Own your business intelligence reports with evidence.dev

Transcript

Steffen00:00:00.140

If you want to create a business intelligence board as a developer , evidencedev is a great choice .

Dominik00:00:09.800

Yeah , so actually we are developers , right , but we are also business owners and sometimes we need to find a way to visualize data , to do like business intelligence , to create dashboards , to visualize something that we might not see Oth