Evidence
Business intelligence as code: build fast, interactive data visualizations in SQL and markdown
Overview:
Business Intelligence as Code is an open-source tool called Evidence that offers a code-based alternative to traditional drag-and-drop business intelligence platforms. By generating reports using SQL and markdown files, Evidence streamlines the process of querying data sources and rendering visualizations and components on a website.
Features:
- Code-Based Approach: Utilizes SQL statements within markdown files to query data sources.
- Markdown to Website: Generates a website from markdown files, showcasing query results through charts and components.
- Templated Pages: Allows for the creation of multiple pages from a single markdown template.
- Control Structures: Supports loops and if/else statements to customize the display of information to users.
- Ease of Installation: Offers an Evidence VSCode Extension for easy installation and project setup.
- Cloud Hosting: Provides Evidence Cloud for secure project hosting, with self-hosted options available as well.
- Community Engagement: Invites users to join the Evidence community through Slack channels and contribute to the project.
Summary:
- Express
Express.js is a simple Node.js framework for single, multi-page, and hybrid web applications.
- Svelte
Svelte is a modern front-end framework that compiles your code at build time, resulting in smaller and faster applications. It uses a reactive approach to update the DOM, allowing for high performance and a smoother user experience.
- Vite
Vite is a build tool that aims to provide a faster and leaner development experience for modern web projects
- Tailwind
Tailwind CSS is a utility-first CSS framework that provides pre-defined classes for building responsive and customizable user interfaces.
- Dashboard
A dashboard style website template is a pre-designed layout that features a user interface resembling a control panel or dashboard. It typically includes charts, graphs, tables, and other data visualization tools that allow users to monitor and analyze data in real-time.
- Eslint
ESLint is a linter for JavaScript that analyzes code to detect and report on potential problems and errors, as well as enforce consistent code style and best practices, helping developers to write cleaner, more maintainable code.
- Prism JS
PrismJS is an open-source, lightweight, and extensible syntax highlighting library that supports a wide range of programming languages and markup formats.
- Typescript
TypeScript is a superset of JavaScript, providing optional static typing, classes, interfaces, and other features that help developers write more maintainable and scalable code. TypeScript's static typing system can catch errors at compile-time, making it easier to build and maintain large applications.
